A data modeler has a 'Sales' query with a 'ProductID' column and a 'Products' query with 'ProductID', 'ProductName', and 'Category'. They want to create a single table for a report that shows product names alongside sales amounts. What should they do?

Use a reference query of Products and then merge with Sales on Category.

Append the Products query to the Sales query.

Create a calculated column in Sales using RELATED(Products[ProductName]).

Merge the Sales and Products queries on ProductID using a Left Outer join.

A data modeler has a 'Customer' column that contains values like 'John Smith' and 'Jane Doe'. They need to split this into 'FirstName' and 'LastName' columns for better filtering. What should they do in Power Query?

Use Split Column by Delimiter on the Customer column.

Use Transpose on the Customer column.

Use Group By on the Customer column.

Use Replace Values to change spaces to underscores.

A data modeler has a 'Products' table with columns: ProductID, ProductName, Category, and SupplierID. They need to create a dimension table that contains only ProductID and ProductName for use in reports. What should they do?

Merge the Products table with itself on ProductID.

Append the Products table to itself.

Duplicate the Products query and remove the Category and SupplierID columns.

Reference the Products query and remove the Category and SupplierID columns.

You have a Power Query query named 'Sales' that loads sales data from a SQL database. You need to create a new query that contains only sales records from the last 30 days, but you must avoid duplicating the entire data load and ensure that the new query reflects any future changes to the source data. What should you do?

Duplicate the 'Sales' query and apply a date filter in the duplicate.

Merge the 'Sales' query with itself and filter on the date column.

Create a reference to the 'Sales' query and apply a date filter in the new query.

Create a new query that directly queries the SQL database with a date filter, ignoring the 'Sales' query.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 3

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

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 6–10

6application · medium
A data modeler has a 'Sales' query with a 'ProductID' column and a 'Products' query with 'ProductID', 'ProductName', and 'Category'. They want to create a single table for a report that shows product names alongside sales amounts. What should they do?
Select an answer first
7application · medium
A data modeler has a 'Customer' column that contains values like 'John Smith' and 'Jane Doe'. They need to split this into 'FirstName' and 'LastName' columns for better filtering. What should they do in Power Query?
Select an answer first
8application · medium
A data modeler has a 'Products' table with columns: ProductID, ProductName, Category, and SupplierID. They need to create a dimension table that contains only ProductID and ProductName for use in reports. What should they do?
Select an answer first
9expert · hard
You have a Power Query query named 'Sales' that loads sales data from a SQL database. You need to create a new query that contains only sales records from the last 30 days, but you must avoid duplicating the entire data load and ensure that the new query reflects any future changes to the source data. What should you do?
Select an answer first
10foundation · easy
In Power Query, which operation creates a new query that points to the same data source and inherits the transformations of the original query, but does not duplicate the data?
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 2)

Questions 6–10

A data modeler has a 'Sales' query with a 'ProductID' column and a 'Products' query with 'ProductID', 'ProductName', and 'Category'. They want to create a single table for a report that shows product names alongside sales amounts. What should they do?

A data modeler has a 'Customer' column that contains values like 'John Smith' and 'Jane Doe'. They need to split this into 'FirstName' and 'LastName' columns for better filtering. What should they do in Power Query?

A data modeler has a 'Products' table with columns: ProductID, ProductName, Category, and SupplierID. They need to create a dimension table that contains only ProductID and ProductName for use in reports. What should they do?

In Power Query, which operation creates a new query that points to the same data source and inherits the transformations of the original query, but does not duplicate the data?

Keep studying — Prepare the data