A data modeler has a 'Sales' fact table with a 'CustomerID' column and a 'Customers' dimension table with a 'CustomerID' column. They need to create a relationship between the two tables. What should they do?

Create a relationship in the data model using CustomerID as the key.

Create a calculated column in Sales using RELATED(Customers[CustomerID]).

Append the Customers table to the Sales table.

Merge the two tables in Power Query on CustomerID.

You have two Power Query queries: 'Sales' with columns SalesID, ProductID, Quantity, and Revenue; and 'Products' with columns ProductID, ProductName, and Category. You need to create a query that includes all sales records and the product name, but you also need to include sales records that have no matching product in the 'Products' table. Which join type should you use?

Full outer join from 'Sales' to 'Products' on ProductID.

Left outer join from 'Sales' to 'Products' on ProductID.

Right outer join from 'Sales' to 'Products' on ProductID.

Inner join from 'Sales' to 'Products' on ProductID.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 3

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

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 11–15

11foundation · easy
In Power Query, which transformation converts unique values from a column into new columns, spreading row values across those columns?
Select an answer first
12application · medium
A data modeler has a 'Sales' fact table with a 'CustomerID' column and a 'Customers' dimension table with a 'CustomerID' column. They need to create a relationship between the two tables. What should they do?
Select an answer first
13foundation · easy
In Power Query Editor, which action creates a new column that derives its values from an expression based on existing columns?
Select an answer first
14foundation · easy
In a relational data model, which key uniquely identifies each row in a table and is used to create relationships with other tables?
Select an answer first
15expert · hard
You have two Power Query queries: 'Sales' with columns SalesID, ProductID, Quantity, and Revenue; and 'Products' with columns ProductID, ProductName, and Category. You need to create a query that includes all sales records and the product name, but you also need to include sales records that have no matching product in the 'Products' table. Which join type should you use?
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 3)

Questions 11–15

In Power Query, which transformation converts unique values from a column into new columns, spreading row values across those columns?

A data modeler has a 'Sales' fact table with a 'CustomerID' column and a 'Customers' dimension table with a 'CustomerID' column. They need to create a relationship between the two tables. What should they do?

In Power Query Editor, which action creates a new column that derives its values from an expression based on existing columns?

In a relational data model, which key uniquely identifies each row in a table and is used to create relationships with other tables?

Keep studying — Prepare the data