Crucial Exams

Microsoft Power BI Data Analyst Practice Question

In Power Query Editor you have a query named FactSales that contains 25 million rows with the columns TerritoryID, OrderDate, and SalesAmount. You must create a second query named TerritoryStats that

  • returns exactly one row per TerritoryID,
  • includes two aggregated columns: TotalSales (sum of SalesAmount) and FirstSaleDate (earliest OrderDate), and
  • is loaded to the data model while FactSales continues to load using incremental refresh. The solution must minimize memory usage and avoid bringing another full copy of the 25 million detail rows into the evaluation container during refresh. Which approach should you use?

  • Within FactSales itself, insert a Group By step that aggregates on TerritoryID, then create a new query that references FactSales and removes unnecessary columns.

  • Reference the FactSales query, apply a Group By transformation on TerritoryID that sums SalesAmount and finds the earliest OrderDate, and load both queries.

  • Create a Mashup Evaluation Container to pre-aggregate FactSales, then disable load for FactSales and load only the aggregated result.

  • Duplicate the FactSales query, then apply a Group By transformation on TerritoryID to create TotalSales and FirstSaleDate, and load both queries.

Microsoft Power BI Data Analyst
Prepare the data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot