Exam DA-100 topic 1 question 1 discussion

Actual exam question from Microsoft's DA-100

Question #: 1
Topic #: 1

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?

A. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
B. Remove the Subject and Body columns during the import.
C. From Model view, set the Subject and Body columns to Hidden.

Show Suggested Answer

Suggested Answer: B 🗳️

by vinothravi at Oct. 14, 2020, 7:05 p.m.

Comments

Submit Cancel

vinothravi

Highly Voted 4 years, 8 months ago

B. Remove the Subject and Body columns during the import.

upvoted 89 times

Regina18

1 year, 5 months ago

Option C: Implementing row-level security (RLS) is a more appropriate solution for controlling access to data based on the sender's email ID. While it doesn't directly address minimizing the model size, it provides a way to filter the data at runtime, ensuring that each user sees only the relevant information.

upvoted 1 times

Regina18

1 year, 5 months ago

Option A: Hiding columns in the model view doesn't necessarily minimize the model size. It only controls the visibility of columns in the report. The data is still present in the model. Option B: Removing unnecessary columns during import can reduce the model size, but it might not be the best solution if you need those columns for analysis. It also doesn't address the requirement of restricting access to the analyzed emails.

upvoted 1 times

...

binah

Highly Voted 3 years, 11 months ago

Hi analysts. l took my exam on June 13 2021 and passed with 800+ score. All two case studies were from here and also 70% of the questions just verify your answers with discussions and on PowerBi as well. Thank you examtopics and thank you everyone!

upvoted 24 times

troydavidcook

3 years, 8 months ago

What's the format of the case studies.?

upvoted 2 times

...

vikiviki

Most Recent 1 year, 2 months ago

vikiviki 0 minutes ago Awaiting moderator approval I think must be A 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.

upvoted 1 times

...

3 years, 3 months ago

on exam 3/1/2022

upvoted 1 times

...

teeman001

3 years, 5 months ago