Question
a.
Operational systems contain historical data
b.
Data warehouse data is highly normalized
c.
Data storage for operational systems supports analysis
d.
Data storage for operational systems is "read-only"
Posted under Data Warehousing and OLAP
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. What distinguishes data storage for operational systems from data storage for a data warehouse?
Similar Questions
Discover Related MCQs
Q. Why is it important for data in a data warehouse to be stable and represent snapshots at specified periods?
View solution
Q. What is the primary purpose of multidimensional database management systems (MDDBs) in data warehouses?
View solution
Q. What type of databases are commonly employed in most data warehouses?
View solution
Q. Who typically needs prepackaged reports and preset queries from the data warehouse?
View solution
Q. Which type of user needs information once in a while, not regularly, and also requires prepackaged information?
View solution
Q. What is the primary objective of a business analyst when using the data warehouse?
View solution
Q. What distinguishes a power user from other types of users in a data warehouse?
View solution
Q. What methods of information delivery are included in the information delivery component of a data warehouse?
View solution
Q. What is the purpose of data-mining applications in a data warehouse?
View solution
Q. What is the metadata component in a data warehouse?
View solution
Q. How does metadata in a data warehouse differ from a data dictionary in a database management system?
View solution
Q. Where does the management and control component sit in the data warehouse architecture?
View solution
Q. What are the primary functions of the management and control component in a data warehouse?
View solution
Q. How does the management and control component interact with the metadata component?
View solution
Q. What role does metadata play in a data warehouse?
View solution
Q. What is the primary purpose of operational metadata in a data warehouse?
View solution
Q. How do data elements selected for the data warehouse differ from the source systems' data elements?
View solution
Q. What type of information does Extraction and Transformation Metadata contain in a data warehouse?
View solution
Q. What is the primary purpose of End-User Metadata in a data warehouse?
View solution
Q. What special significance does metadata have in a data warehouse?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond Data Warehousing and OLAP? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
