This CCSP practice question tests your understanding of cloud data security. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. 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 company uses a cloud-based database that contains personally identifiable information (PII). They need to allow developers to run queries against the database for testing purposes without exposing actual PII. Which technique should they use?
Encrypt the PII fields at rest
Why wrong: Encryption doesn't allow plaintext queries without decrypting.
Grant developers direct access to a copy of the production data
Why wrong: This exposes actual PII.
Apply dynamic data masking to the PII columns
Masking provides realistic but fake data.
Tokenize the PII fields with a one-way hash
Why wrong: Tokenization may break relationships needed for testing.
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Apply dynamic data masking to the PII columns
Option C is correct because dynamic data masking (DDM) allows the database to return masked PII to developers in real time without altering the underlying stored data. This technique applies masking rules at query runtime, so developers can run functional tests against production-like data while sensitive values are obfuscated. It avoids the need for separate sanitized copies and preserves referential integrity for testing.
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.
Encrypt the PII fields at rest
Why it's wrong here
Encryption doesn't allow plaintext queries without decrypting.
Grant developers direct access to a copy of the production data
Why it's wrong here
This exposes actual PII.
Apply dynamic data masking to the PII columns
Why this is correct
Masking provides realistic but fake data.
Related concept
Read the scenario before looking for a memorised answer.
Tokenize the PII fields with a one-way hash
Why it's wrong here
Tokenization may break relationships needed for testing.
Common exam traps
ISC2 often tests the distinction between dynamic data masking and tokenization, where candidates mistakenly choose tokenization because they think a one-way hash is sufficient for testing, but they overlook that testing requires reversible or format-preserving transformations to maintain data utility.
Detailed technical explanation
Dynamic data masking works by defining masking policies on columns (e.g., showing only last four digits of a Social Security number) that are applied at query compile time in the database engine, such as SQL Server's DDM or Oracle's Data Redaction. Unlike static data masking, which creates a separate sanitized copy, DDM operates inline and can be toggled per user or session, making it ideal for scenarios where developers need to test against live schema and data volumes without duplicating storage. A subtle behavior is that DDM does not prevent users from inferring masked values through brute-force queries (e.g., guessing SSNs via WHERE clauses), so it must be combined with access controls and auditing for sensitive workloads.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
A SOC analyst notices unusual lateral movement in the network at 2 AM. The IR playbook dictates: identify and contain (isolate the affected machine), then eradicate (remove the malware), then recover (restore from backup), then document. Skipping containment before eradication risks the attacker regaining access. Questions like this test the sequence and rationale of incident response phases.
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: Apply dynamic data masking to the PII columns — Option C is correct because dynamic data masking (DDM) allows the database to return masked PII to developers in real time without altering the underlying stored data. This technique applies masking rules at query runtime, so developers can run functional tests against production-like data while sensitive values are obfuscated. It avoids the need for separate sanitized copies and preserves referential integrity for testing.
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 →
Keep practising
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.