What is a data warehouse primarily used for?a. Storing transactional datab. Storing processed data for analysisc. Storing real-time datad. Storing metadata

he deployment of large data warehouses with terabytes or even petabytes of data been crucial to the growth of decision support. All the following explain why EXCEPT  data warehouses have assisted the collection of data from multiple sources.data warehouses have enabled the collection of decision makers in one place.data warehouses have enabled the affordable collection of data for analytics.data warehouses have assisted the collection of data for data mining

Why do we want to have a Data Warehouse in a company?Group of answer choicesWe need to take snapshots of data for recovery purposesTo archive data in case some years later an audit needs to look at itEvery company needs to have a real storage for their disk, tapes and thus we need a warehouse for itCompanies that wish to make data analysis, check trends and make high level decisions need a Data Warehouse

The important aspect of the data warehouse environment is that data found within the data warehouse is___________.Question 14Answera.time-variantb.subject-oriented.c.integratedd.All of the above

29. This is a broad category of applications and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions.Question 21Answera.Business warehouseb.Business intelligencec.Business information warehoused.Data mart

Identify characteristics of data warehouses. More than one answer is possible.1 pointPopulated from operational databases and external data sourcesOptimized for efficient and reliable processing of large volumes of daily transactions.Transformations and integrations performed to support decision makingOptimized for reporting that summarizes large amounts of data