adplus-dvertising
frame-decoration

Question

What are the main building blocks or components of a data warehouse?

a.

Data marts, data staging, and data extraction

b.

Metadata, information delivery, and management and control

c.

Source data, data staging, data storage, information delivery, metadata, and management and control

d.

Business rules, data transformation, and data cleansing

Answer: (c).Source data, data staging, data storage, information delivery, metadata, and management and control Explanation:The main building blocks or components of a data warehouse include source data, data staging, data storage, information delivery, metadata, and management and control.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. What are the main building blocks or components of a data warehouse?

Similar Questions

Discover Related MCQs

Q. What is a practical approach to data warehousing that combines the advantages of both the top-down and bottom-up approaches?

Q. What are the defining features of a data warehouse?

Q. What does End-User Metadata enable end-users to do in a data warehouse?

Q. What does Extraction and Transformation Metadata contain information about in a data warehouse?

Q. What special significance does metadata have in a data warehouse?

Q. What is the primary purpose of End-User Metadata in a data warehouse?

Q. What type of information does Extraction and Transformation Metadata contain in a data warehouse?

Q. How do data elements selected for the data warehouse differ from the source systems' data elements?

Q. What is the primary purpose of operational metadata in a data warehouse?

Q. What role does metadata play in a data warehouse?

Q. How does the management and control component interact with the metadata component?

Q. What are the primary functions of the management and control component in a data warehouse?

Q. Where does the management and control component sit in the data warehouse architecture?

Q. How does metadata in a data warehouse differ from a data dictionary in a database management system?

Q. What is the metadata component in a data warehouse?

Q. What is the purpose of data-mining applications in a data warehouse?

Q. What methods of information delivery are included in the information delivery component of a data warehouse?

Q. What distinguishes a power user from other types of users in a data warehouse?

Q. What is the primary objective of a business analyst when using the data warehouse?

Q. Which type of user needs information once in a while, not regularly, and also requires prepackaged information?