ISC2 Certified Secure Software Lifecycle Professional (CSSLP) Practice Question
Your development team must provide the QA group with a copy of the customer database so they can run realistic regression tests. The tables contain customer names, mailing addresses, credit-card PANs, and loyalty-program IDs that must not be exposed outside production. To satisfy the CSSLP requirement for sanitization when re-using production data in test environments, which approach best meets the goal?
Apply a deterministic, keyed hashing or format-preserving masking algorithm to overwrite each sensitive value with an irreversible but syntactically valid surrogate, ensuring the same original value is always mapped to the same replacement across all tables.
Drop all columns that contain sensitive data before exporting the database and let testers work with the remaining fields, even if this breaks some foreign-key references.
Encrypt the entire database and provide the decryption key only to authorized testers under a nondisclosure agreement.
Generate a completely synthetic data set with random values and load it into the QA database without attempting to match it to production records.
Sanitization requires that sensitive values be removed or replaced so the data set no longer contains real personal information, yet remains useful for testing. Replacing each sensitive field with an irreversible, format-preserving surrogate produced by a secret, consistent keyed hash (or similar data-masking algorithm) eliminates exposure of actual customer data while keeping record lengths and inter-table relationships intact-enabling realistic functional and regression testing. Simply encrypting the database and sharing the key, deleting entire columns, or generating unrelated random records either fails to prevent disclosure during testing or breaks referential integrity needed for meaningful tests. Therefore, the option that uses deterministic, irreversible substitution of sensitive values while preserving format and consistency best implements proper sanitization.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is keyed hashing, and how does it help with data sanitization?
Open an interactive chat with Bash
What is format-preserving masking, and why is it necessary?
Open an interactive chat with Bash
How does database sanitization ensure referential integrity during testing?
Open an interactive chat with Bash
ISC2 Certified Secure Software Lifecycle Professional (CSSLP)
Secure Software Testing
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .