CAF-3 · Chapter 6 · Question 7 of 15
The executive board wants to analyze historical sales trends over the past ten years to make strategic business decisions. They query a system that contains integrated, time-variant, and non-volatile data. Which system are they querying?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: C) A Data Warehouse
Explanation
A data warehouse is subject-oriented, integrated, time-variant, and non-volatile, making it specifically designed for historical data analysis and business intelligence rather than daily transactions . --------------------------------------------------------------------------------
More Data Warehouse Schemas & Data Marts MCQs
- Q9In the ETL process, standardizing date formats across different systems (e.g., converting DD/MM/YYYY to MM/DD/YYYY) and calculating new…
- Q10To save processing time and bandwidth, a company updates its data warehouse every midnight by only bringing in the new transactions that…
- Q11A data architect designs a schema for a new data warehouse. The design features a single central 'Fact Table' containing total sales…
- Q12To save storage space and ensure stricter data integrity, a database engineer modifies a Star Schema by breaking down the 'Product'…
- Q13An enterprise wants to integrate its 'Sales' process and its 'Inventory' process into one analytical model. The database designer creates…