A company has a 'Date' table and an 'Orders' table with 'OrderDate' and 'ShipDate'. They need to create a report that shows both order counts by order date and by ship date on the same page. What is the best approach?

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

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

Create two measures, one using USERELATIONSHIP on the active relationship and one on the inactive relationship, and use them in separate visuals.

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

A sales manager reports that the 'SalesAmount' column in the 'Orders' table appears in the Fields list but is not visible in the report canvas when they drag it onto a table visual. You confirm the column exists and contains data. What should you configure to resolve this?

Set the 'Orders' table's 'Is hidden' property to false.

Change the 'SalesAmount' column's data type to Decimal.

Create a new relationship from 'Orders' to a date table.

Set the 'SalesAmount' column's 'Is hidden' property to false.

A company has a 'Customers' table and an 'Orders' table. They want to filter orders by customer region, but also want to filter customers by the number of orders they have placed. What cross-filter direction should you set on the relationship?

Single direction from 'Orders' to 'Customers'.

Single direction from 'Customers' to 'Orders'.

A model has a 'Customers' table with a unique CustomerID and an 'Orders' table with multiple orders per customer. Each order has a CustomerID. What relationship cardinality should you define between these tables?

Many-to-one from Customers to Orders.

One-to-one from Customers to Orders.

One-to-many from Customers to Orders.

Many-to-many between Customers and Orders.

Microsoft Certified:Power BI Data Analyst Associate

Domain 2Objective 1

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

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 16–20

16foundation · easy
Which column property in Power BI Desktop controls the default aggregation behavior when a numeric column is added to a visual?
Select an answer first
17expert · hard
A company has a 'Date' table and an 'Orders' table with 'OrderDate' and 'ShipDate'. They need to create a report that shows both order counts by order date and by ship date on the same page. What is the best approach?
Select an answer first
18application · medium
A sales manager reports that the 'SalesAmount' column in the 'Orders' table appears in the Fields list but is not visible in the report canvas when they drag it onto a table visual. You confirm the column exists and contains data. What should you configure to resolve this?
Select an answer first
19application · medium
A company has a 'Customers' table and an 'Orders' table. They want to filter orders by customer region, but also want to filter customers by the number of orders they have placed. What cross-filter direction should you set on the relationship?
Select an answer first
20application · easy
A model has a 'Customers' table with a unique CustomerID and an 'Orders' table with multiple orders per customer. Each order has a CustomerID. What relationship cardinality should you define between these tables?
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.