Which of the following is a common example of a role-playing dimension in a data model?

A Geography table used to filter a single Sales fact table.

A Customer table used to filter both Sales and Returns fact tables.

A Date table used for both Order Date and Ship Date in a Sales fact table.

A Product table used in a single relationship with a Sales fact table.

What is the primary purpose of creating a common date table in a Power BI data model?

To replace all date columns in fact tables with a single date column.

To provide a consistent calendar dimension for time intelligence calculations and filtering across multiple fact tables.

To store all date values from every fact table in one place.

To automatically create relationships between all tables in the model.

A company has a table of customer transactions. They want to create a separate table that lists only customers who have made more than 10 purchases, and this table should be used as a filter in reports. What should you do?

Use a measure to count purchases and apply a visual-level filter to show only customers with more than 10.

Create a calculated column in the transactions table that flags customers with more than 10 purchases.

Create a calculated table using FILTER and GROUPBY to summarize customers with a purchase count greater than 10.

Create a calculated column that concatenates customer IDs with purchase counts.

A model has a 'Products' table and a 'Sales' table. Each product can appear in multiple sales, and each sale can include multiple products (many-to-many). The company wants to filter sales by product. What should you do?

Create a calculated column in Sales that concatenates all product IDs.

Create a bridge table with ProductID and SaleID and create relationships from Products to bridge and bridge to Sales.

Create a measure that filters sales by product using a DAX expression.

Create a direct many-to-many relationship between Products and Sales.

A model has a 'Products' table and a 'Sales' table with a one-to-many relationship. Users want to filter product-related visuals by selecting products, and they also want to filter sales-related visuals by selecting products. What cross-filter direction should you set?

Single direction from Sales to Products.

Single direction from Products to Sales.

Both directions (cross filter both).

Microsoft Certified:Power BI Data Analyst Associate

Domain 2Objective 1

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

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

11foundation · easy
Which of the following is a common example of a role-playing dimension in a data model?
Select an answer first
12foundation · easy
What is the primary purpose of creating a common date table in a Power BI data model?
Select an answer first
13application · medium
A company has a table of customer transactions. They want to create a separate table that lists only customers who have made more than 10 purchases, and this table should be used as a filter in reports. What should you do?
Select an answer first
14expert · hard
A model has a 'Products' table and a 'Sales' table. Each product can appear in multiple sales, and each sale can include multiple products (many-to-many). The company wants to filter sales by product. What should you do?
Select an answer first
15application · easy
A model has a 'Products' table and a 'Sales' table with a one-to-many relationship. Users want to filter product-related visuals by selecting products, and they also want to filter sales-related visuals by selecting products. What cross-filter direction should you set?
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.