Database Fundamentals CV0-004 Practice Questions (Page 1)

Questions 1–5

1. 1expert · hard

   A global e-commerce platform uses a distributed database with multiple replicas across regions. The platform must ensure that when a customer places an order, the order is immediately visible to the customer and that inventory is not oversold. However, the platform also wants low latency for reads. Which consistency model should they choose?

   • AStrong consistency for writes and inventory checks, eventual consistency for other reads
   • BStrong consistency for all reads and writes
   • CRead-your-writes consistency for all operations
   • DEventual consistency for all operations
   Reveal Solution Discussion Select an answer first
2. 2expert · hard

   A company's database is critical to operations, and they have a recovery point objective (RPO) of 5 minutes and a recovery time objective (RTO) of 1 hour. They are considering using a cloud database service with automated backups and point-in-time recovery. Which additional measure is necessary to meet the RTO?

   • AEnable automated backups with a retention period of 30 days
   • BConfigure a standby replica in a different availability zone
   • CIncrease the database instance size for faster recovery
   • DUse manual snapshots taken every hour
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   A company's database workload is unpredictable, with sudden spikes in read traffic. They want to ensure high availability and performance without over-provisioning. They are considering using a managed database service with read replicas. Which configuration best handles the unpredictable read spikes?

   • AAutoscaling read replicas based on read latency
   • BA fixed number of read replicas
   • CNo read replicas, rely on the primary instance
   • DA single large read replica
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which backup strategy involves taking a full backup of the database and then only backing up the changes since the last full backup?

   • ASnapshot backup
   • BIncremental backup
   • CDifferential backup
   • DFull backup only
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A company's compliance policy requires that database backups be retained for at least one year and that backups be stored in a separate geographic location from the primary database. Which backup strategy meets these requirements?

   • ADaily backups stored in the same region with a 30-day retention
   • BContinuous backups stored in the same region with indefinite retention
   • CWeekly backups stored in a different region with a 13-month retention
   • DMonthly backups stored in a different region with a 12-month retention
   Reveal Solution Discussion Select an answer first