CompTIA DS0-002: CompTIA DataSys+ (V2)

Last checked October 22, 2026 against the official CompTIA exam page.

1. Question 1Database Fundamentals

   A table stores customer orders, and each order must reference exactly one existing customer. Which constraint enforces this relationship?

   1. AA check constraint on the orders table that limits the order total to a fixed amount
   2. BA default value on the customer name column that fills in a placeholder name for new rows
   3. CA unique index on the order date to prevent duplicate dates
   4. DA foreign key from the orders table to the customers table's primary key
   Show answer and explanationHide answer

   Correct answer: D

   A foreign key ensures each order references an existing customer through the primary key. A unique date index, a total check and a default name do not enforce the relationship.

2. Question 2Database Deployment

   A team is designing a new database schema and wants a shared reference of tables, columns, data types, and their meaning. Which artifact should be created?

   1. AA wallpaper for the database server
   2. BA data dictionary
   3. CA marketing brochure
   4. DA customer invoice template
   Show answer and explanationHide answer

   Correct answer: B

   A data dictionary documents tables, columns, types and definitions. The other artifacts are unrelated to schema documentation.

3. Question 3Data and Database Security

   What does data masking primarily protect?

   1. ANetwork cable length between the application tier and the storage array
   2. BDisk partition labels assigned during the operating system installation
   3. CSensitive values from being seen by unauthorized users in non-production or reports
   4. DThe server's power supply unit rated for 1200 watts with dual hot-swap modules
   Show answer and explanationHide answer

   Correct answer: C

   Masking hides sensitive values from users who should not see them, especially outside production. The other items are unrelated.

4. Question 4Database Management and Maintenance

   A monitoring alert shows that a database's disk usage will reach capacity in two weeks. What is the most appropriate first action?

   1. ADeleting the transaction logs to free space immediately on the production server
   2. BReviewing growth trends and planning storage expansion or data archiving before capacity is reached
   3. CIgnoring the alert until the disk is full and assuming autogrowth will keep working on the current volume
   4. DRebooting the database server every night as a scheduled task to keep temp space available
   Show answer and explanationHide answer

   Correct answer: B

   Trend review and planned expansion or archiving prevents an outage before it happens. Deleting transaction logs can break recovery, ignoring alerts causes outages, and rebooting does not free disk.

5. Question 5Business Continuity

   Which backup type copies only the data that changed since the last full backup?

   1. AOS disk snapshot
   2. BPrinted report backup
   3. CFull database backup
   4. DDifferential backup
   Show answer and explanationHide answer

   Correct answer: D

   A differential backup captures changes since the last full backup. A full backup copies everything, OS snapshots are not database backups, and print backups are not backup types.