Filters
Question type

Study Flashcards

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

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


A) transformation
B) extraction
C) load
D) cleanse

E) B) and C)
F) A) and B)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Subject oriented. Data are organ...

View Answer

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Generally speaking, these architectures ...

View Answer

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

Correct Answer

verifed

verified

In-databas...

View Answer

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


A) strategic decisions whose impacts are hard to measure
B) detailed data available for strategic use only
C) large numbers of users, including operational staffs
D) restrictive reporting with daily and weekly data currency

E) C) and D)
F) B) and D)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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


A) better and more timely information
B) extensive new analyses performed by users
C) simplified access to data
D) improved customer service

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

Briefly describe four major components of the data warehousing process.

Correct Answer

verifed

verified

Data sources. Data are sourced f...

View Answer

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?

Correct Answer

verifed

verified

The primary purpose of metadat...

View Answer

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

A) True
B) False

Correct Answer

verifed

verified

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


A) transformation
B) extraction
C) load
D) cleanse

E) A) and C)
F) B) and C)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Showing 41 - 60 of 70

Related Exams

Show Answer