PL-300 Question #454: Real Exam Question with Answer & Explanation

Question

You have a Power BI query named Expenses that imports the following data. Users only use the date portion of the TransactionDate value when performing data analysis. You need to minimize the model size without affecting the analysis. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

• AChange the data type of the TransactionDate column to Date.
• BChange the data type of the PostDate column to Date.
• CRemove the PostDate column.
• DRemove the TransactionID column.

Explanation

To minimize Power BI model size without affecting analysis when only the date portion of a datetime column is used, convert the column to a date data type and remove any other unnecessary date columns.

Common mistakes.

• B. Changing the data type of the PostDate column to Date is redundant if the column is to be removed, and even if kept, 'PostDate' is likely already a date type, so this action would have no impact on model size.
• D. Removing the TransactionID column would negatively affect analysis if unique transaction identification is ever required, and it is not explicitly stated as unnecessary for the given analysis, unlike the 'PostDate' column.

Concept tested. Power Query data type optimization, column removal for model size reduction

Reference. https://learn.microsoft.com/en-us/power-bi/guidance/import-modeling-guidance#model-optimization

No community discussion yet for this question.