Task Statement 3.3: Implement Automated Recovery Processes to Meet RTO and RPO Requirements. DOP-C02 Practice Questions (Page 4)

Questions 16–20

1. 16expert · hard

   A company runs an Amazon Aurora PostgreSQL cluster with a primary and two replicas in different Availability Zones. The database team plans to test failover during a maintenance window. The application uses a custom JDBC connection string that points to the cluster endpoint. After the failover test, the team notices that some application requests fail for about 30 seconds. What is the MOST likely cause and what should the team do to minimize this impact?

   • AThe JDBC connection pool is not configured to validate connections on borrow; configure the pool to test connections before use.
   • BThe Aurora cluster endpoint takes time to update to the new primary; use the instance endpoint instead.
   • CThe failover test caused a brief DNS propagation delay; increase the TTL on the cluster endpoint DNS record.
   • DThe replicas are not in the same VPC as the application; move the replicas to the application's VPC.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which AWS service can be used to automatically copy EBS snapshots to a different Region for cross-Region backup?

   • AAmazon S3 Cross-Region Replication
   • BAmazon CloudWatch Events
   • CAWS Systems Manager
   • DAWS Backup
   Reveal Solution Discussion Select an answer first
4. 18expert · hard

   A company runs a critical application in us-east-1 that uses Amazon RDS for SQL Server. The application must be recoverable in us-west-2 with an RPO of 15 minutes and an RTO of 1 hour. The company currently uses AWS Backup to copy nightly snapshots to us-west-2. During a recovery drill, the team found that restoring the RDS instance from the snapshot took 45 minutes, and the total recovery time exceeded the RTO. Which change would MOST effectively reduce the RTO?

   • APre-provision an RDS instance in us-west-2 and use AWS Database Migration Service (DMS) for continuous replication.
   • BUse a larger DB instance class for the restored instance.
   • CEnable Multi-AZ on the primary RDS instance.
   • DIncrease the frequency of AWS Backup jobs to every 15 minutes.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A company has a disaster recovery plan that uses AWS Backup to copy EBS snapshots to a secondary Region. During a recovery drill, the team restored the EC2 instances from the snapshots, but the application could not connect to the restored database because the database was not yet available. Which step should be added to the recovery plan to prevent this issue?

   • AConfigure the application to retry the database connection indefinitely.
   • BIncrease the EBS volume size on the restored instances.
   • CRestore the database first and then start the application instances.
   • DUse a larger EC2 instance type for the application.
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A company runs an Amazon Aurora MySQL database with a primary instance and one replica in a different Availability Zone. The database team needs to test failover behavior without disrupting the production workload. Which approach should they use to validate automatic failover and data consistency?

   • AReboot the primary instance with the 'Failover' option to trigger a controlled failover to the replica.
   • BModify the DB cluster to disable Multi-AZ and then re-enable it.
   • CStop the primary instance and then start it again after a few minutes.
   • DTake a manual snapshot of the cluster and restore it to a new cluster in the same Region.
   Reveal Solution Discussion Select an answer first