When configuring table properties in Power BI Desktop, what is the purpose of the Description property for a table?

It controls the order of tables in the Fields list.

It provides a tooltip or metadata that helps users understand the table's content.

It determines which tables can be used in relationships.

It sets the default summarization for all columns in the table.

A company has a 'Sales' table with 'Quantity' and 'UnitPrice'. They want to add a column that shows the line total, but they also want to ensure that the column is not visible to report users. What should you do?

Create a calculated column for the line total and set its visibility to Hidden.

Create a measure for the line total and use it in visuals.

Add the line total as a new column in the source data and hide it in Power Query.

Create a calculated table that contains the line total and hide the table.

In Power BI, what is the purpose of creating a role-playing dimension?

To enforce row-level security on a dimension table.

To combine multiple fact tables into a single table for analysis.

To allow the same dimension table to be used in multiple relationships with a fact table, each representing a different context.

To create a hierarchy that can be used in multiple visuals.

In Power BI, what does the cardinality of a relationship define?

The number of rows in each table.

The number of columns used in the relationship.

The type of join between tables, such as one-to-many or one-to-one.

The direction in which filters flow between tables.

Microsoft Certified:Power BI Data Analyst Associate

Domain 2Objective 1

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

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 6–10

6foundation · easy
When configuring table properties in Power BI Desktop, what is the purpose of the Description property for a table?
Select an answer first
7expert · medium
A company has a 'Sales' table with 'Quantity' and 'UnitPrice'. They want to add a column that shows the line total, but they also want to ensure that the column is not visible to report users. What should you do?
Select an answer first
8foundation · easy
In Power BI, what is the purpose of creating a role-playing dimension?
Select an answer first
9foundation · easy
In Power BI Desktop, which table property can be configured in the Properties pane to change how the table is displayed in the Fields list?
Select an answer first
10foundation · easy
In Power BI, what does the cardinality of a relationship define?
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.