A logistics company has a fact table with one row per package scan (multiple scans per package). The report shows daily package counts and average transit time. The table has 500 million rows and refresh takes over 2 hours. You need to reduce refresh time while keeping the ability to drill from year to month to day. What should you do?

Pre-aggregate the data to one row per package per day in Power Query, keeping the date and package count.

Use a calculated table to summarize the data instead of importing the raw data.

Keep all rows but remove the status column to reduce column count.

Remove the package ID column and keep only the scan timestamp and status.

A sales analytics model imports a fact table with one row per order line. The table includes a 'ProductDescription' column with lengthy text, a 'ProductKey' column, and a 'ProductCategory' column. The report only displays product category names. The model refresh takes too long. What should you do to improve refresh performance while keeping the report functional?

Remove the ProductDescription column and keep ProductKey and ProductCategory.

Change the ProductDescription column to a text data type with a maximum length of 50.

Remove the ProductKey column and keep ProductDescription and ProductCategory.

Replace the ProductDescription column with a calculated column that extracts the first 50 characters.

A financial reporting model imports transaction-level data with a row for every transaction. The report only shows monthly totals by account. The model is large and slow. What should you do to reduce granularity while maintaining the monthly totals?

Pre-aggregate the transactions to one row per account per month in Power Query.

Change the transaction amount to a whole number.

Remove the account column and keep only the transaction amount.

Keep the transaction-level data but remove the date column.

A data table includes several columns that are not used in any report, measure, or relationship. What is the most effective way to improve model efficiency regarding these columns?

Hide the unused columns from report view.

Remove the unused columns from the table.

Rename the unused columns to shorter names.

Change the data type of the unused columns to text.

A DAX measure uses a FILTER function that iterates over a large table. Performance Analyzer shows the measure is slow. You want to improve the measure's performance. What should you do?

Increase the number of rows in the table to improve the filter's accuracy.

Add more columns to the table to give the filter more options.

Use a calculated column instead of a measure to precompute the result.

Replace the FILTER with a CALCULATE and a simple filter expression.

Microsoft Certified:Power BI Data Analyst Associate

Domain 2Objective 3

Optimize Model Performance 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 35 practice questions to prepare you well beyond it. (estimate)

35questions here

7free pages

5concepts

25–30%of the exam

Questions 6–10

6expert · hard
A logistics company has a fact table with one row per package scan (multiple scans per package). The report shows daily package counts and average transit time. The table has 500 million rows and refresh takes over 2 hours. You need to reduce refresh time while keeping the ability to drill from year to month to day. What should you do?
Select an answer first
7application · medium
A sales analytics model imports a fact table with one row per order line. The table includes a 'ProductDescription' column with lengthy text, a 'ProductKey' column, and a 'ProductCategory' column. The report only displays product category names. The model refresh takes too long. What should you do to improve refresh performance while keeping the report functional?
Select an answer first
8application · medium
A financial reporting model imports transaction-level data with a row for every transaction. The report only shows monthly totals by account. The model is large and slow. What should you do to reduce granularity while maintaining the monthly totals?
Select an answer first
9foundation · easy
A data table includes several columns that are not used in any report, measure, or relationship. What is the most effective way to improve model efficiency regarding these columns?
Select an answer first
10application · medium
A DAX measure uses a FILTER function that iterates over a large table. Performance Analyzer shows the measure is slow. You want to improve the measure's performance. What should you do?
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.

Optimize Model Performance PL-300 Practice Questions (Page 2)

Questions 6–10

A financial reporting model imports transaction-level data with a row for every transaction. The report only shows monthly totals by account. The model is large and slow. What should you do to reduce granularity while maintaining the monthly totals?

A data table includes several columns that are not used in any report, measure, or relationship. What is the most effective way to improve model efficiency regarding these columns?

A DAX measure uses a FILTER function that iterates over a large table. Performance Analyzer shows the measure is slow. You want to improve the measure's performance. What should you do?

Keep studying — Model the data