CAF-3 · Chapter 6 · Question 5 of 15
When designing a database, an IT team debates whether to fully normalize the data or leave it partially denormalized. What is the primary trade-off of high normalization?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: B) It increases storage efficiency and data integrity, but complex queries may run slower due to multiple table joins.
Explanation
Normalization trade-offs include increased storage efficiency and simplified maintenance, but it can lead to slower query performance because fetching related data requires joining multiple tables . --------------------------------------------------------------------------------
More Data Warehouse Schemas & Data Marts MCQs
- Q7The executive board wants to analyze historical sales trends over the past ten years to make strategic business decisions. They query a…
- Q8During the creation of a data warehouse, raw data is pulled from a CRM system, an ERP system, and several flat files. Before this data is…
- 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…