Question
Why are dimensional OLAP schemas often denormalized?
Select an option. Your answer will be checked instantly.
Correct Answer: A. To simplify analytical queries and reduce joins
Explanation:
Denormalized dimensions make business attributes easier to query.
Fewer joins can improve usability and analytical performance.
Leave a Reply