A data model has a table named 'DimProduct' with a column 'ProductCategory'. Users are confused by the column name because it actually contains subcategory values. The company wants to make the model clearer without changing the underlying data source. What should you do?

Hide the column and create a measure that returns the column value.

Rename the column to 'ProductSubcategory' in the data model and update the column description.

Change the data type of the column to a numeric type.

Create a calculated table that duplicates the column with a new name.

Which of the following is a common use case for a calculated table?

Creating a date table using the CALENDAR function.

Creating a relationship between two tables.

Creating a measure that calculates total sales.

Creating a column that extracts the year from a date.

A retail company has sales data in multiple tables, each with its own date column. They want all reports to use a consistent fiscal calendar that starts in April. What should they do to ensure all date-related calculations use the same fiscal calendar?

Create a calculated table that generates a continuous date range with fiscal year, quarter, and month columns, then relate it to each fact table's date column.

Use the built-in date hierarchy and change its start month to April in the model settings.

Create a calculated column in each fact table that extracts the fiscal year from the date.

Add fiscal year, quarter, and month columns directly to each fact table's date column.

What is the primary purpose of a calculated table in Power BI?

To store data imported from an external source.

To create a visual that displays table data.

To create a new table based on an expression that returns a table, often used for modeling or analysis.

To define row-level security rules.

Microsoft Certified:Power BI Data Analyst Associate

Domain 2Objective 1

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

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 26–30

26application · easy
A data model has a table named 'DimProduct' with a column 'ProductCategory'. Users are confused by the column name because it actually contains subcategory values. The company wants to make the model clearer without changing the underlying data source. What should you do?
Select an answer first
27foundation · easy
Which of the following is a common use case for a calculated table?
Select an answer first
28application · medium
A retail company has sales data in multiple tables, each with its own date column. They want all reports to use a consistent fiscal calendar that starts in April. What should they do to ensure all date-related calculations use the same fiscal calendar?
Select an answer first
29foundation · easy
In Power BI Desktop, which column property determines how numeric values are displayed, such as currency, percentage, or decimal places?
Select an answer first
30foundation · easy
What is the primary purpose of a calculated table in Power BI?
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.