A company has a 'Date' table and an 'Orders' table with both an 'OrderDate' and a 'DueDate'. They need to create a report that shows order counts by due date. What is the best way to set up the model?

Create two active relationships from Date to Orders, one on OrderDate and one on DueDate.

Create a calculated column in Orders that shows the due date as text and use that for filtering.

Create a separate Date table for due dates and relate it to Orders.

Create two relationships from Date to Orders, one active on OrderDate and one inactive on DueDate, and use USERELATIONSHIP in the measure for due date analysis.

A company has sales data with 'OrderDate' and 'ShipDate'. They need to create a date table that supports time intelligence functions for both dates. What is the best approach?

Create two separate date tables, one for each date.

Create a single date table using CALENDARAUTO() and create two relationships to 'Sales'.

Use the 'OrderDate' column directly in time intelligence functions.

Create a calculated column in the 'Sales' table for the date.

A sales table contains UnitPrice and Quantity columns. The company wants to add a new column that shows the line total for each row, and this value will be used in row-level calculations. What should you do?

Use Power Query to merge the sales table with itself on the row number.

Create a calculated table that summarizes the sales table by product.

Add a calculated column with the expression [UnitPrice] * [Quantity].

Create a measure that multiplies SUM(UnitPrice) by SUM(Quantity).

In Power BI, what does the cross-filter direction of a relationship control?

The number of relationships a table can have.

The storage mode of the tables.

The direction in which filters propagate from one table to another.

The order in which tables are loaded into the model.

A company has a 'Date' table and a 'Sales' table with both 'OrderDate' and 'DueDate'. They need to create a report that shows sales by order date and also by due date, but they want to use a single date table. What is the most efficient way to achieve this?

Create two separate date tables, one for each date.

Create two active relationships from 'Date' to 'Sales'.

Create one active relationship for 'OrderDate' and one inactive for 'DueDate', then use USERELATIONSHIP in measures.

Use calculated columns to extract the date parts.

Microsoft Certified:Power BI Data Analyst Associate

Domain 2Objective 1

Design and Implement a Data Model PL-300 Practice Questions (Page 5)

Part of the Model 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 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

8concepts

25–30%of the exam

Questions 21–25

21application · medium
A company has a 'Date' table and an 'Orders' table with both an 'OrderDate' and a 'DueDate'. They need to create a report that shows order counts by due date. What is the best way to set up the model?
Select an answer first
22expert · hard
A company has sales data with 'OrderDate' and 'ShipDate'. They need to create a date table that supports time intelligence functions for both dates. What is the best approach?
Select an answer first
23application · medium
A sales table contains UnitPrice and Quantity columns. The company wants to add a new column that shows the line total for each row, and this value will be used in row-level calculations. What should you do?
Select an answer first
24foundation · easy
In Power BI, what does the cross-filter direction of a relationship control?
Select an answer first
25expert · hard
A company has a 'Date' table and a 'Sales' table with both 'OrderDate' and 'DueDate'. They need to create a report that shows sales by order date and also by due date, but they want to use a single date table. What is the most efficient way to achieve this?
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.