Secure Test Data CSSLP Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   What is a key benefit of reusing production data for testing?

   • AIt eliminates the need for any data sanitization
   • BIt guarantees that all test cases will pass
   • CIt provides a highly realistic dataset that reflects actual usage patterns
   • DIt removes the need for test environment access controls
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A logistics company is generating test data for a shipment tracking system. The database has `Shipments`, `Packages`, and `DeliveryAttempts` tables. Each package must belong to a shipment, and each delivery attempt must reference a package. The QA team wants to ensure that every foreign key is valid. Which generation strategy should they use?

   • AGenerate shipments, then packages using shipment IDs, then delivery attempts using package IDs.
   • BUse a single large table for all entities to avoid foreign keys.
   • CGenerate all tables in parallel and then run a script to delete orphaned records.
   • DGenerate packages first, then shipments, then delivery attempts.
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which characteristic is essential for test data to ensure that database queries and joins behave as they would in production?

   • AData replication
   • BReferential integrity
   • CData encryption
   • DData compression
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A bank is preparing a test environment with a copy of production data. They need to hide customer account numbers and names, but the data must still support joins between the `Customers` and `Accounts` tables. Which obfuscation technique should they use?

   • AReplace all names with 'Test User' and all account numbers with '000000'.
   • BEncrypt the entire database and give the test team the decryption key.
   • CShuffle the names and account numbers among records so they no longer match.
   • DReplace names with fake names and account numbers with unique tokens that map consistently across tables.
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   What does 'statistical quality' in test data primarily refer to?

   • AThe data containing only values that are statistically significant at the 95% confidence level
   • BThe data being encrypted using statistically secure algorithms
   • CThe data being generated using a random number generator with a high entropy source
   • DThe data reflecting realistic distributions, ranges, and patterns similar to production
   Reveal Solution Discussion Select an answer first