You have a fact table 'Sales' with columns: SalesID, DateKey, ProductKey, CustomerKey, and SalesAmount. You need to create a dimension table for dates that includes Date, Year, Month, and Quarter to support time-based analysis. What should you do?

Use the Sales table itself as the date dimension by selecting distinct dates.

Merge the Sales table with itself on the DateKey to create a date dimension.

Create a calculated column in the Sales table for Year, Month, and Quarter.

Create a new query that generates a list of dates from the minimum to the maximum date in the Sales table, then add Year, Month, and Quarter columns.

A data analyst needs to create a fact table from multiple source tables: 'Orders' and 'OrderDetails'. The fact table should contain one row per order line with columns: OrderID, ProductID, Quantity, and LineTotal. The analyst wants to minimize the number of queries in the data model. What should they do?

Append Orders and OrderDetails into one table.

Use Group By on OrderID to aggregate OrderDetails.

Merge Orders and OrderDetails on OrderID, then add a custom column for LineTotal.

Load both tables separately and create a relationship.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 3

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

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 26–30

26application · medium
You have a fact table 'Sales' with columns: SalesID, DateKey, ProductKey, CustomerKey, and SalesAmount. You need to create a dimension table for dates that includes Date, Year, Month, and Quarter to support time-based analysis. What should you do?
Select an answer first
27foundation · easy
In Power Query, which operation combines two queries by matching rows on a common column, similar to a SQL JOIN?
Select an answer first
28foundation · easy
In Power Query, which transformation swaps the rows and columns of a table so that columns become rows and rows become columns?
Select an answer first
29expert · hard
A data analyst needs to create a fact table from multiple source tables: 'Orders' and 'OrderDetails'. The fact table should contain one row per order line with columns: OrderID, ProductID, Quantity, and LineTotal. The analyst wants to minimize the number of queries in the data model. What should they do?
Select an answer first
30foundation · easy
In Power Query, which transformation converts multiple columns into attribute-value pairs, effectively turning columns into rows?
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 6)

Questions 26–30

You have a fact table 'Sales' with columns: SalesID, DateKey, ProductKey, CustomerKey, and SalesAmount. You need to create a dimension table for dates that includes Date, Year, Month, and Quarter to support time-based analysis. What should you do?

In Power Query, which operation combines two queries by matching rows on a common column, similar to a SQL JOIN?

In Power Query, which transformation swaps the rows and columns of a table so that columns become rows and rows become columns?

In Power Query, which transformation converts multiple columns into attribute-value pairs, effectively turning columns into rows?

Keep studying — Prepare the data