Beginner
Big Data & Data Engineering
Q29 / 100
Why might a data engineer intentionally "denormalize" data in an analytics warehouse?
Correct! Well done.
Incorrect.
The correct answer is A) To reduce the number of joins needed and improve read/query performance for analytics
A
Correct Answer
To reduce the number of joins needed and improve read/query performance for analytics
Explanation
Denormalization trades some redundancy for faster reads by combining related data, which is often desirable in analytical (OLAP) workloads with heavy reads.
Progress
29/100