CDPSE Privacy Engineering Practice Question
When configuring 'Dynamic Data Masking' in SQL Server, which permission is required for a user to see the unmasked data?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
UNMASK permission
The 'UNMASK' permission is required for a user to view the original values hidden by dynamic data masking.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
db_datareader
Why it's wrong here
This only allows reading; it does not bypass the masking.
- ✗
SELECT permission
Why it's wrong here
Standard select permissions are subject to the masking rules.
- ✓
UNMASK permission
Why this is correct
This explicit permission allows the user to view the raw, unmasked data.
- ✗
sysadmin role
Why it's wrong here
While sysadmin works, it is not the 'required' granular permission; UNMASK is the specific control.
About these practice questions
One of 215 original CDPSE practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official ISACA exam blueprint
This CDPSE practice question is part of Courseiva's free ISACA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the CDPSE exam.