Exam 3: Data Warehousing

Which of the following statements is more descriptive of active data warehouses in contrast with traditional data warehouses?

In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?

The three main types of data warehouses are data marts, operational ________, and enterprise data warehouses.

A common way of introducing data warehousing is to refer to its fundamental characteristics. Describe three characteristics of data warehousing.

Without middleware, different BI programs cannot easily connect to the data warehouse.

Moving the data into a data warehouse is usually the easiest part of its creation.

Briefly describe four major components of the data warehousing process.

Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure.

Data warehouses provide direct and indirect benefits to using organizations. Which of the following is an indirect benefit of data warehouses?

________ modeling is a retrieval-based system that supports high-volume query access.

Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks.

A well-designed data warehouse means that user requirements do not have to change as business needs change.

________ (also called in-database analytics) refers to the integration of the algorithmic extent of data analytics into data warehouse.

According to Kassam (2002), business metadata comprise information that increases our understanding of traditional (i.e., structured) data. What is the primary purpose of metadata?

Data ________ comprises data access, data federation, and change capture.

In which stage of extraction, transformation, and load (ETL) into a data warehouse are data aggregated?

In the Isle of Capri case, the only capability added by the new software was increased processing speed of processing reports.

There are several basic information system architectures that can be used for data warehousing. What are they?

Most data warehouses are built using ________ database management systems to control and manage the data.

The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage.