nerdexam
Isaca

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.

Submitted by parkjh· Apr 18, 2026Risk Response and Reporting

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)
  • A
    24% (12)
  • B
    57% (28)
  • C
    6% (3)
  • D
    12% (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.

AImplement role-based access control

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.

BImplement a data masking processCorrect

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.

CInclude sanctions in nondisclosure agreements (NDAs)

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.

DInstall a data loss prevention (DLP) tool

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

#Data Masking#Confidentiality Protection#Data Security Controls#Risk Mitigation Strategies

Community Discussion

No community discussion yet for this question.

Full CRISC Practice