Explanatory Question

What are Aggregation Tables?

👁 0 Views

📘 Detailed Answer

🕒 Easy to Read

Read the answer carefully and go through the related questions on the right side to improve your understanding of this topic.

Answer with Explanation

Aggregation Tables store summarized data to accelerate report queries.

Example:

Detailed Sales Table → 500 Million Rows
Monthly Summary Table → 10 Thousand Rows

Power BI can automatically use the summary table to improve performance.

How to use this answer better

First read the answer fully, then try to explain it in your own words. After that, open a few related questions and compare the concepts. This method helps you remember the topic for a longer time and improves exam preparation.