Exam PL-300 topic 2 question 6 discussion

B is the best option to prevent report recipients from reading the analyzed emails and minimize the model size. Removing the Subject and Body columns during the import process ensures that they are not included in the model, which prevents report recipients from being able to access the analyzed email content. A and C are not effective solutions for preventing report recipients from reading the analyzed emails. A: Hiding the Subject and Body columns in the model view may prevent report recipients from seeing the content in the report, but the data is still stored in the model and can potentially be accessed by someone with the appropriate permissions. C: Implementing row-level security (RLS) restricts data access based on user roles or permissions, but it does not prevent access to the analyzed email content in the model. No confusion, and no need to discuss further

correct, "prevent report recipients from reading the analyzed emails"

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.

correct

This is was on the exam today. 2024-04-19

I think must be B because if you choose to remove Subject and Body columns you will have report based on whom they send emails , so the report and analyzed data (to whom..) of the rest part of the mails will still be visible.

ChatGPT C. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent. Explanation: Row-Level Security (RLS) allows you to control access to data at the row level based on user roles or filters. By applying RLS, you can restrict report recipients’ visibility to only the data relevant to them. In your scenario, you want to ensure that employees can only see results related to the emails they sent. RLS provides a fine-grained approach to achieve this without affecting the model size. Hiding columns or removing them during import won’t prevent recipients from accessing the data if they have direct access to the model.

correct

CLS is not available in Power Bi so we either Mask or remove the columns. Mask them though still potentially leaves chances to view the data.

dissect the question and only keep key elements: custom connector : ID, From, To, Subject, Body, and Has Attachments -build a report analyzing send emails to. -prevent report from reading emails. -minimize the model size. What should you do? Pretty obvious you only need to keep : [ID, From, To], right ?

Correct

C is the correct answer. In this scenario, we want to prevent report recipients from reading the analyzed emails while still allowing them to analyze internal networks based on whom employees send emails to. To achieve this this goal while minimizing the model size, implementing row-level security (RLS) is the most appropriate solution. Option A doesn't prevent access to the underlying data. Option B might limit our ability to perform analysis based on the content of emails.

B es correcta

B is the best option to prevent report recipients from reading the analyzed emails and minimize the model size. Removing the Subject and Body columns during the import process ensures that they are not included in the model, which prevents report recipients from being able to access the analyzed email content. A and C are not effective solutions for preventing report recipients from reading the analyzed emails. A: Hiding the Subject and Body columns in the model view may prevent report recipients from seeing the content in the report, but the data is still stored in the model and can potentially be accessed by someone with the appropriate permissions. C: Implementing row-level security (RLS) restricts data access based on user roles or permissions, but it does not prevent access to the analyzed email content in the model. No confusion, and no need to discuss further

Remove the sensitive info at the very beginning

B is correct for me