DA0-001 · Question #171
A sales director has requested a report for individual team members within the division be developed. The director would like the report to be shared with all team members, but individual team…
The correct answer is B. Release the report as user-group-based access and include data masking. To share a report with all team members while preventing individual identification, user-group-based access should be implemented along with data masking.
Question
A sales director has requested a report for individual team members within the division be developed. The director would like the report to be shared with all team members, but individual team members should not be identifiable within the report. Which of the following access requirements would support the director's needs?
Options
- ACreate an acceptable use policy for the sales data.
- BRelease the report as user-group-based access and include data masking.
- CGet a data use agreement from the individual team members.
- DProvide the report based on role and include data encryption.
How the community answered
(56 responses)- A2% (1)
- B82% (46)
- C11% (6)
- D5% (3)
Why each option
To share a report with all team members while preventing individual identification, user-group-based access should be implemented along with data masking.
An acceptable use policy sets guidelines for data usage but does not technically enforce anonymization or restrict visibility of specific data points within a report.
User-group-based access ensures that only authorized personnel can view the report, while data masking techniques anonymize or obscure sensitive individual data points within the report itself, thus satisfying the requirement that individual team members should not be identifiable.
Concept tested: Data privacy and access control (data masking)
Source: https://learn.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking
Topics
Community Discussion
No community discussion yet for this question.