FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Data Warehousing

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

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?

A(n)________ architecture is used to build a scalable and maintainable infrastructure that includes a centralized data warehouse and several dependent data marts.

When representing data in a data warehouse,using several dimension tables that are each connected only to a fact table means you are using which warehouse structure?

Performing extensive ________ to move data to the data warehouse may be a sign of poorly managed data and a fundamental lack of a coherent data management strategy.

Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?

Data warehouses are subsets of data marts.

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

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

The ETL process in data warehousing usually takes up a small portion of the time in a data-centric project.

Because of performance and data quality issues,most experts agree that the federated architecture should supplement data warehouses,not replace them.

How does the use of cloud computing affect the scalability of a data warehouse?

One way an operational data store differs from a data warehouse is the recency of their data.

Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?

When querying a dimensional database,a user went from summarized data to its underlying details.The function that served this purpose is

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

The ________ Model,also known as the EDW approach,emphasizes top-down development,employing established database development methodologies and tools,such as entity-relationship diagrams (ERD),and an adjustment of the spiral development approach.

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