Question
Why would a warehouse create an aggregate table?
Select an option. Your answer will be checked instantly.
Correct Answer: D. To pre-summarize data for frequently requested query levels
Explanation:
Aggregate tables reduce the number of detailed rows processed for common summaries.
They improve speed but require storage and refresh management.
Leave a Reply