BenchMark Quizzes by MDFT Pro

Create Aggregations For Large Datasets In Power BI

You have a dataset with a very large Telemetry table at MDFT Pro and want to reduce its size. The Telemetry table contains multiple records per day, and the academy needs to analyze summarized data efficiently.

You want to create aggregations for the table columns ’eventValue’ and ’eventDuration’. Which steps are required to create and configure an aggregation table in Power BI?

Choose all correct answers from the options below.

Explanations for each answer:

Create a new table named Telemetry_Aggregate containing the columns to hold aggregate data. is correct. You must first create an aggregation table to store summarized data.
Open the Manage aggregations dialog. is correct. The Manage aggregations dialog allows you to map the columns of the Telemetry_Aggregate table to the detailed Telemetry table and define how aggregations are performed.
Select the Telemetry_Aggregate table as the aggregation table. is correct. Designating the Telemetry_Aggregate table as the aggregation table enables Power BI to use it for query acceleration and summarized data retrieval.
For each aggregation column, choose the appropriate summarization (Group By, Count, Sum, Average) is correct. Selecting the correct summarization for each column ensures that the aggregation table accurately represents the summarized data needed for analysis.
For each aggregation column, select the table and column from the Telemetry table. is correct. Mapping each aggregation column to the corresponding source column in the Telemetry table allows Power BI to relate the summarized data to the detailed data.
Create a calculated column for each aggregation. is incorrect. Calculated columns are not required for aggregations.

Learn more about aggregations in Power BI:

Power BI Aggregations

Exam Preparation Quiz

Create Aggregations For Large Datasets In Power BI