Quick Answer
Dynamic data masking is the correct choice because it enables real-time obfuscation of sensitive columns like SSN and diagnosis at the database query layer, based on user permissions, without altering the underlying stored data. This technique transforms result sets on-the-fly for unauthorized users such as database administrators, ensuring they see masked values while authorized personnel view the actual data. On the Certified Cloud Security Professional CCSP exam, this scenario tests your understanding of access control at the data layer versus storage-layer encryption, with a common trap being the selection of static masking or encryption, which permanently alter the data at rest. The key distinction is that dynamic data masking operates at query time, preserving the original data for compliance and auditing. For a memory tip, think “DDM = Don’t Disturb the Data” — it masks on output, not on disk.
This CCSP practice question tests your understanding of cloud data security. The scenario asks you to isolate a root cause — eliminate options that address a different problem before choosing. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
A healthcare organization stores patient records in a cloud database. They need to ensure that database administrators cannot view sensitive columns like SSN and diagnosis. Which data masking technique should be applied?
Dynamic data masking
DDM masks data in query results based on user privileges.
Static data masking
Why wrong: Static masking creates a copy with masked data, not real-time.
Encryption at rest
Why wrong: Encryption protects data at rest but DBAs with keys can still see plaintext.
Tokenization
Why wrong: Tokenization replaces sensitive data with tokens, but requires mapping.
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Dynamic data masking
Dynamic data masking (DDM) is the correct choice because it allows the healthcare organization to mask sensitive columns (e.g., SSN, diagnosis) in real-time at the database query layer, based on user permissions. DDM does not alter the underlying stored data; it transforms the result set on-the-fly for unauthorized users (like DBAs), ensuring they see masked values while authorized personnel see the actual data. This meets the requirement of preventing database administrators from viewing sensitive columns without changing the data at rest.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Dynamic data masking
Why this is correct
DDM masks data in query results based on user privileges.
Related concept
Read the scenario before looking for a memorised answer.
Static data masking
Why it's wrong here
Static masking creates a copy with masked data, not real-time.
Encryption at rest
Why it's wrong here
Encryption protects data at rest but DBAs with keys can still see plaintext.
Tokenization
Why it's wrong here
Tokenization replaces sensitive data with tokens, but requires mapping.
Common exam traps
ISC2 often tests the distinction between masking at query time (dynamic) versus masking at rest (static), and candidates mistakenly choose static masking because they think it 'permanently' protects data, but the key requirement is that DBAs cannot view sensitive columns in the live production database, which only dynamic masking addresses without altering the original data.
Detailed technical explanation
Dynamic data masking works by defining masking rules (e.g., partial masking like 'XXX-XX-1234' for SSN) at the database schema level, which are applied transparently by the database engine during query execution. In cloud databases like Azure SQL Database or Amazon RDS, DDM is implemented as a security feature that integrates with role-based access control (RBAC), ensuring that even if a DBA has read permissions, they see masked data unless explicitly granted the UNMASK permission. A subtle behavior is that DDM does not prevent data leakage through side channels (e.g., inference attacks or logs), so it should be combined with other controls like auditing and row-level security for comprehensive protection.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
A developer is choosing between AES-256 (symmetric) and RSA-2048 (asymmetric) for encrypting a large file that will be sent to a partner. Symmetric encryption is fast but requires key exchange; asymmetric is slower but solves the key distribution problem. A hybrid approach — encrypt the file with AES, encrypt the AES key with RSA — is standard. Questions like this test whether you understand when each approach applies.
What to study next
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Cloud Data Security — study guide chapter
Learn the concepts, then practise the questions
Cloud Data Security practice questions
Targeted practice on this topic area only
All CCSP questions
504 questions across all exam domains
Certified Cloud Security Professional CCSP study guide
Full concept coverage aligned to exam objectives
CCSP practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise CCSP questions linked to Cloud Application Security.
Practise CCSP questions linked to Cloud Security Operations.
Practise CCSP questions linked to Legal, Risk and Compliance.
Practise CCSP questions linked to Cloud Concepts, Architecture and Design.
Practise CCSP questions linked to Cloud Platform and Infrastructure Security.
Practise CCSP questions linked to Cloud Data Security.
Practise CCSP questions linked to CCSP fundamentals.
Practise CCSP questions linked to CCSP scenario.
Practise CCSP questions linked to CCSP troubleshooting.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Cloud Data Security — This question tests Cloud Data Security — Read the scenario before looking for a memorised answer..
The correct answer is: Dynamic data masking — Dynamic data masking (DDM) is the correct choice because it allows the healthcare organization to mask sensitive columns (e.g., SSN, diagnosis) in real-time at the database query layer, based on user permissions. DDM does not alter the underlying stored data; it transforms the result set on-the-fly for unauthorized users (like DBAs), ensuring they see masked values while authorized personnel see the actual data. This meets the requirement of preventing database administrators from viewing sensitive columns without changing the data at rest.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 30, 2026
This CCSP practice question is part of Courseiva's free ISC2 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 CCSP exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.