Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
B. Remove the Subject and Body columns during the import. Why? Removing sensitive columns like Subject and Body during import ensures those email contents are not loaded into the model at all, minimizing model size and protecting privacy. Simply hiding columns (Option A) keeps the data in the model, so it could still be accessed by advanced users. Implementing RLS (Option C) restricts which rows users see but doesn’t remove sensitive columns—so the email content could still be exposed for allowed rows and increases model size.
B is the correct answer because A and C cannot reduce model size.
For exclusion B is the only one that reduce the complexity. Hide or implement RLS is not the correct way to do that. I totally agree with you: B. Remove the Subject and Body columns during the import.