CRISC · Question #113
Which of the following is the BEST method to mitigate the risk of an unauthorized employee viewing confidential data in a database''
The correct answer is B. Implement a data masking process. Data masking is the best method to mitigate the risk of an authorized employee viewing confidential data in a database by obscuring sensitive information while maintaining data utility.
Question
Which of the following is the BEST method to mitigate the risk of an unauthorized employee viewing confidential data in a database''
Options
- AImplement role-based access control
- BImplement a data masking process
- CInclude sanctions in nondisclosure agreements (NDAs)
- DInstall a data loss prevention (DLP) tool
How the community answered
(49 responses)- A24% (12)
- B57% (28)
- C6% (3)
- D12% (6)
Why each option
Data masking is the best method to mitigate the risk of an authorized employee viewing confidential data in a database by obscuring sensitive information while maintaining data utility.
Role-based access control restricts access to the database or specific tables, but if an employee has authorized access, RBAC alone does not prevent them from viewing unmasked confidential data within their authorized scope.
Data masking alters sensitive data elements with realistic but false data, making the original confidential data unreadable or unintelligible to unauthorized individuals, even if they have database access permissions, thereby directly preventing viewing of actual confidential information.
NDAs and sanctions are legal and deterrent controls, but they do not technically prevent an unauthorized employee from viewing confidential data if they manage to gain access.
A Data Loss Prevention (DLP) tool primarily monitors and prevents sensitive data from *leaving* the organization's controlled environment, not from being viewed by an employee with internal database access.
Concept tested: Mitigating insider threat to confidential data
Source: https://learn.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking
Topics
Community Discussion
No community discussion yet for this question.