Question
When may physical denormalization be justified in a warehouse?
Select an option. Your answer will be checked instantly.
Correct Answer: A. When measured query benefits outweigh redundancy and maintenance costs
Explanation:
Physical design can duplicate or prejoin data to reduce expensive query operations.
The decision should be supported by workload tests and controlled refresh logic.
Leave a Reply