FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Data Warehousing Concepts

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

Analytical databases are created for the analysis of one or more specific business subject areas,such as sales,returns,cost,or profit.

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following is NOT true:

A) Data marts typically have fewer data sources than data warehouses
B) Data marts typically have broader focus than data warehouses
C) Data marts are typically not as big as data warehouses
D) Data marts typically have shorter implementation time than data warehouses

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

The operational data sources include the data warehouses and data marts.

Data warehouse requirements can be refined and/or expanded following:

Creating ETL infrastructure includes creating necessary procedures and code for:

Increasing the speed of a single query is always a priority,even if it requires slowing down the majority of other queries.

A typical organization maintains and utilizes a number of operational data sources.

Describe the data update difference between operational and analytical database systems.

The design and creation of data warehouse front-end applications can take place in parallel with data warehouse creation.

In contrast to a narrow constituency of operational data,analytical data is used by a widespread set of users.

Analytical databases are referred to as application-oriented.

What is an independent data mart?

It is usually possible to configure the system to optimally process frequent queries requiring smaller amounts of data and to optimally process less frequent queries requesting large amounts of data at the same time.

A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis.

Explain the term structured repository in the following data warehouse definition: The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.

Keeping data in the operational system past its time horizon enables the operational queries to run faster.

The purpose of the source system is:

Show an example data set organized in two different ways illustrating the difference between the application-oriented and subject-oriented organization of data.

ETL infrastructure has to account for and reconcile all of the differences in the metadata and the data between the operational sources and the target data warehouses.

What is a dependent data mart?