You have a table with columns 'UnitPrice' and 'Quantity'. You need to create a new column that calculates the total sales amount for each row. Which approach should you use in Power Query?

Add a custom column with the formula [UnitPrice] * [Quantity].

Use the 'Group By' feature to sum the UnitPrice and Quantity columns.

Use the 'Transpose' feature to swap rows and columns, then calculate the total.

Use the 'Merge Queries' feature to combine UnitPrice and Quantity into a single column.

A sales analyst receives a monthly report with columns: Region, Jan Sales, Feb Sales, Mar Sales, ... Dec Sales. They need a table with one row per region and a single 'Sales Amount' column for all months, plus a 'Month' column, to build a star schema. What should they do in Power Query?

Use Group By on the Region column.

Use Transpose on the entire table.

Select the Region column and use Pivot Column.

Select the month columns and use Unpivot Columns.

A company has sales data for the current year stored in three separate Excel files, each with the same columns: Date, ProductID, Quantity, and Revenue. You need to combine these files into a single query for analysis. What should you do in Power Query?

Transpose one table and then append it to another.

Use the 'Append Queries' feature to stack the three tables into one.

Create a calculated column in one table that references the other tables.

Use the 'Merge Queries' feature to join the tables on the Date column.

You have a Power Query query that loads a large fact table (100 million rows) from a SQL database. The query currently performs several transformation steps, including filtering, merging with a dimension table, and adding calculated columns. The report performance is slow. You need to optimize the data load. What should you do?

Load the data into Power BI and then use DAX to perform the transformations.

Push down the filtering and merging operations to the SQL source using query folding.

Use the 'Duplicate' feature to create a copy of the query and then filter.

Disable the load of the query and use a direct query connection.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 3

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

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 31–35

31application · medium
You have a table with columns 'UnitPrice' and 'Quantity'. You need to create a new column that calculates the total sales amount for each row. Which approach should you use in Power Query?
Select an answer first
32application · medium
A sales analyst receives a monthly report with columns: Region, Jan Sales, Feb Sales, Mar Sales, ... Dec Sales. They need a table with one row per region and a single 'Sales Amount' column for all months, plus a 'Month' column, to build a star schema. What should they do in Power Query?
Select an answer first
33application · medium
A company has sales data for the current year stored in three separate Excel files, each with the same columns: Date, ProductID, Quantity, and Revenue. You need to combine these files into a single query for analysis. What should you do in Power Query?
Select an answer first
34expert · hard
You have a Power Query query that loads a large fact table (100 million rows) from a SQL database. The query currently performs several transformation steps, including filtering, merging with a dimension table, and adding calculated columns. The report performance is slow. You need to optimize the data load. What should you do?
Select an answer first
35foundation · easy
In Power Query, which operation stacks rows from two or more queries that have the same columns into a single query?
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 7)

Questions 31–35

You have a table with columns 'UnitPrice' and 'Quantity'. You need to create a new column that calculates the total sales amount for each row. Which approach should you use in Power Query?

A sales analyst receives a monthly report with columns: Region, Jan Sales, Feb Sales, Mar Sales, ... Dec Sales. They need a table with one row per region and a single 'Sales Amount' column for all months, plus a 'Month' column, to build a star schema. What should they do in Power Query?

A company has sales data for the current year stored in three separate Excel files, each with the same columns: Date, ProductID, Quantity, and Revenue. You need to combine these files into a single query for analysis. What should you do in Power Query?

In Power Query, which operation stacks rows from two or more queries that have the same columns into a single query?

Keep studying — Prepare the data