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 financial services company is migrating a critical database to the cloud. The database contains columns with PII that must be encrypted. Performance is the highest priority, and the system must support queries on encrypted data. Which technique should be used?
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Tokenization
Tokenization is correct because it replaces sensitive PII with non-sensitive tokens that retain the format and length of the original data, allowing queries to run on the tokens without exposing the actual values. This approach provides strong security while maintaining high performance, as the token mapping is stored separately and queries are executed against the tokenized data without decryption overhead.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✗
Hashing
Why it's wrong here
Hashing is one-way and does not allow reversing to original data, so it cannot be used for queries requiring original values.
✗
Application-level encryption
Why it's wrong here
Application-level encryption adds overhead for encryption/decryption on each query, reducing performance.
✗
Transparent Data Encryption (TDE)
Why it's wrong here
TDE encrypts the entire database at rest, not column-level, and requires decryption for each read, impacting performance.
✓
Tokenization
Why this is correct
Tokenization replaces sensitive data with tokens that preserve format and length, enabling efficient queries without encryption overhead.
Related concept
Read the scenario before looking for a memorised answer.
Common exam traps
Common exam trap: answer the scenario, not the keyword
ISC2 often tests the misconception that TDE supports queries on encrypted data, but TDE only encrypts data at rest and decrypts it during access, failing the 'query on encrypted data' requirement without performance degradation.
Detailed technical explanation
How to think about this question
Tokenization typically uses a vault-based or vaultless approach; in vault-based tokenization, a secure token server maps tokens to original values using a lookup table, while vaultless tokenization uses format-preserving encryption (FPE) with a key. For query support, tokenization can preserve data type and length (e.g., a 16-digit credit card number becomes a 16-digit token), enabling indexed searches and range queries without decryption. In real-world scenarios, PCI DSS compliance often drives tokenization adoption for payment data, where performance and queryability are critical.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
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
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Cloud Data Security — This question tests Cloud Data Security — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Tokenization — Tokenization is correct because it replaces sensitive PII with non-sensitive tokens that retain the format and length of the original data, allowing queries to run on the tokens without exposing the actual values. This approach provides strong security while maintaining high performance, as the token mapping is stored separately and queries are executed against the tokenized data without decryption overhead.
What should I do if I get this CCSP question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
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 →
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.
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.