A Power BI developer has a data model with a large fact table and several dimension tables. The fact table is updated frequently, but the dimension tables are static. The developer wants to reduce the time it takes to refresh the dataset while keeping report performance fast. What should they do?

Use incremental refresh for the fact table and keep dimensions in Import mode.

Set the fact table to DirectQuery and the dimension tables to Import mode.

Set all tables to Import mode and disable load for unused columns.

Set all tables to DirectQuery mode.

A company stores sales data for each region in separate Excel files with identical columns. An analyst needs to combine all files into a single query for reporting. What should they do in Power Query?

Merge each file query on a common date column.

Create a calculated table in DAX using UNION.

Load each file separately and create relationships between them.

Use the Combine Files feature from a folder, then Append queries as needed.

A retail analyst has a table of daily store sales with columns: StoreID, Date, and SalesAmount. They need a summary table showing total sales per store for the current year. What should they do in Power Query?

Create a calculated column for year and then use a DAX SUMMARIZE table.

Pivot the Date column and then group by StoreID.

Filter Date to the current year, then use Group By on StoreID with Sum of SalesAmount.

Use Group By on Date with Sum of SalesAmount.

You have a table with columns: Product, Q1, Q2, Q3, Q4, where each row represents a product and the columns contain quarterly sales figures. You need to restructure the table so that each product has four rows, one for each quarter, with columns: Product, Quarter, and Sales. Which transformation should you use?

Unpivot the Q1, Q2, Q3, and Q4 columns to create a Quarter column and a Sales column.

Pivot the Product column to create separate columns for each product.

Transpose the table so that quarters become rows and products become columns.

Group by Product and sum the quarterly columns.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 3

Transform and Load the Data PL-300 Practice Questions (Page 9)

Part of the Prepare the data domain, which accounts for 25–30% of the PL-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 3–7 from this objective — we provide 51 practice questions to prepare you well beyond it. (estimate)

51questions here

11free pages

16concepts

25–30%of the exam

Questions 41–45

41expert · hard
A Power BI developer has a data model with a large fact table and several dimension tables. The fact table is updated frequently, but the dimension tables are static. The developer wants to reduce the time it takes to refresh the dataset while keeping report performance fast. What should they do?
Select an answer first
42application · medium
A company stores sales data for each region in separate Excel files with identical columns. An analyst needs to combine all files into a single query for reporting. What should they do in Power Query?
Select an answer first
43application · medium
A retail analyst has a table of daily store sales with columns: StoreID, Date, and SalesAmount. They need a summary table showing total sales per store for the current year. What should they do in Power Query?
Select an answer first
44application · medium
You have a table with columns: Product, Q1, Q2, Q3, Q4, where each row represents a product and the columns contain quarterly sales figures. You need to restructure the table so that each product has four rows, one for each quarter, with columns: Product, Quarter, and Sales. Which transformation should you use?
Select an answer first
45foundation · easy
In Power Query Editor, which data type should you assign to a column that contains dates in the format '2024-01-15' to ensure proper chronological sorting and date-based calculations?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PL-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “PL-300” is a trademark of its owner, used for identification only.

Transform and Load the Data PL-300 Practice Questions (Page 9)

Questions 41–45

A Power BI developer has a data model with a large fact table and several dimension tables. The fact table is updated frequently, but the dimension tables are static. The developer wants to reduce the time it takes to refresh the dataset while keeping report performance fast. What should they do?

A company stores sales data for each region in separate Excel files with identical columns. An analyst needs to combine all files into a single query for reporting. What should they do in Power Query?

A retail analyst has a table of daily store sales with columns: StoreID, Date, and SalesAmount. They need a summary table showing total sales per store for the current year. What should they do in Power Query?

In Power Query Editor, which data type should you assign to a column that contains dates in the format '2024-01-15' to ensure proper chronological sorting and date-based calculations?

Keep studying — Prepare the data