Question 190
A report uses an obsolete debug column containing sensitive employee IDs that is not required. Which configuration should the team choose?
Explanation
Correct Answer
Early field pruning reduces confidential exposure and memory use. It meets the scenario requirement of remove unnecessary sensitive source columns.
Incorrect Answers
Loading makes the dimension available in the semantic model for relationships and reports. It would instead address materialize a lookup dimension, not the stated remove unnecessary sensitive source columns.
Subtotal records duplicate values already represented by detail rows. It may be appropriate for avoid source subtotal double counting, whereas the current need is remove unnecessary sensitive source columns.
Disable Load prevents redundant model storage while preserving downstream query logic. This solves staging-only transformation query, not the requested remove unnecessary sensitive source columns.






Microsoft Power BI Data Analyst (PL-300) Practice Tests