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?
To prevent report recipients from reading the analyzed emails and minimize the model size, it is best to remove the Subject and Body columns during the import process. This ensures that these columns are not included in the model, thereby reducing the model size and eliminating any possibility of report recipients accessing the email content.
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
Gracias por tu explicación :)
correct, "prevent report recipients from reading the analyzed emails"
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
This was on Exam Today
This was in the exam this week.
This is was on the exam today. 2024-04-19
This was on the exam today
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.
C doesnt minimize the size , B does
This question was on the exam today 9/12/2023
B es correcta
Correct
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 ?
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.
correct
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.
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.
correct