Question 27
Domain 7: Ensuring Data Security and ComplianceAn organization wants to protect sensitive table data by limiting which rows users can see and by hiding values in specific columns. Which combination should it use?
Correct answer: A
Explanation
Use row filters to restrict access to selected rows and column masks to obscure sensitive values in specific columns. — official.txt
Why each option is right or wrong
A. Apply row filters for row-level visibility and column masks for sensitive column values.
The source states that row filters and column masks are used to filter and mask sensitive table data. In this scenario, row filters address which rows are visible, and column masks address hiding sensitive values in columns.
B. Apply column masks for row-level visibility and row filters for sensitive column values.
Row filters are used for rows, while column masks are used for columns.
C. Apply row filters for both row-level visibility and sensitive column values.
Column masks are needed to mask sensitive values in specific columns.
D. Apply column masks for both row-level visibility and sensitive column values.
Row filters are needed to filter which rows users can access.