A data model contains a table named 'DimProduct' with a column 'ProductName'. Users are complaining that the column name is not descriptive enough. You want to change the display name without affecting the source data. What should you do?

Change the data type of the column.

Hide the column and create a new one.

Change the column's description.

Rename the column in the data model.

A model has a 'Customers' table and an 'Orders' table with a one-to-many relationship. Users want to filter customers by orders (e.g., show customers who have placed orders in a certain region) and also filter orders by customers. What cross-filter direction should you set?

Single direction from Orders to Customers.

Both directions (cross filter both).

Single direction from Customers to Orders.

A financial report has a column named 'Revenue' that currently displays as a whole number. Users want to see it with two decimal places and a dollar sign. What should you do?

Set the column's format to Currency with 2 decimal places.

Change the data type to Text and manually add dollar signs.

Create a calculated column that multiplies Revenue by 1.00.

Use a measure that returns Revenue and set the measure's format.

What is the default cross-filter direction for a relationship in Power BI?

Depends on the data type of the key columns

Microsoft Certified:Power BI Data Analyst Associate

Domain 2Objective 1

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

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 1–5

1application · medium
A data model contains a table named 'DimProduct' with a column 'ProductName'. Users are complaining that the column name is not descriptive enough. You want to change the display name without affecting the source data. What should you do?
Select an answer first
2expert · hard
A model has a 'Customers' table and an 'Orders' table with a one-to-many relationship. Users want to filter customers by orders (e.g., show customers who have placed orders in a certain region) and also filter orders by customers. What cross-filter direction should you set?
Select an answer first
3application · easy
A financial report has a column named 'Revenue' that currently displays as a whole number. Users want to see it with two decimal places and a dollar sign. What should you do?
Select an answer first
4foundation · easy
What is the default cross-filter direction for a relationship in Power BI?
Select an answer first
5foundation · easy
Which relationship cardinality is most commonly used between a dimension table and a fact table in a star schema?
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.