PL-300 · Question #97
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report…
The correct answer is B. Remove the Subject and Body columns during the import. Removing columns at import time means the data is never loaded into the model at all, which both protects the email content and directly minimizes the model size. RLS (option A) restricts who can see rows but does not remove data from the model - the Subject and Body columns…
Question
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to. You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do?
Options
- AImplement row-level security (RLS) so that the report recipients can only see results based on the
- BRemove the Subject and Body columns during the import.
- CFrom Model view, set the Subject and Body columns to Hidden.
How the community answered
(29 responses)- A14% (4)
- B79% (23)
- C7% (2)
Explanation
Removing columns at import time means the data is never loaded into the model at all, which both protects the email content and directly minimizes the model size. RLS (option A) restricts who can see rows but does not remove data from the model - the Subject and Body columns would still exist and contribute to model size. Setting columns to Hidden (option C) only prevents users from seeing them in the field list; the data is still stored in the model and model size is unchanged. Removing unneeded columns at the Power Query step is the correct approach for both security and size goals.
Topics
Community Discussion
No community discussion yet for this question.