Crucial Exams

ISC2 Certified Secure Software Lifecycle Professional (CSSLP) Practice Question

You are preparing a synthetic data set for system-integration testing of an e-commerce platform that stores customers, orders, and order_items linked through foreign-key constraints. Production data cannot be used, yet the automated test queries must still return valid results across joins. Which approach best ensures that the generated test data preserves referential integrity while avoiding disclosure of real customer information?

  • Populate each table with randomly generated rows independently, disabling foreign-key constraints during the load to avoid referential errors.

  • Copy production tables verbatim, then hash customer names and addresses while leaving all key columns unchanged.

  • Generate customer and order records first, capture their new primary keys, and use those keys when creating related order_items so every foreign-key reference resolves correctly.

  • Insert only order_items with placeholder foreign keys and rely on the database engine to create any missing parent rows automatically during testing.

ISC2 Certified Secure Software Lifecycle Professional (CSSLP)
Secure Software Testing
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot