AWS Certified Database – Specialty — Question 192

A company is using an Amazon Aurora PostgreSQL DB cluster for the backend of its mobile application. The application is running continuously and a database specialist is satisfied with high availability and fast failover, but is concerned about performance degradation after failover.

How can the database specialist minimize the performance degradation after failover?

Answer options

• A. Enable cluster cache management for the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-0
• B. Enable cluster cache management tor the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-1
• C. Enable Query Plan Management for the Aurora DB cluster and perform a manual plan capture
• D. Enable Query Plan Management for the Aurora DB cluster and force the query optimizer to use the desired plan

Correct answer: A

Explanation

Enabling cluster cache management and setting the promotion priority to tier-0 allows for faster access to cached data after a failover, minimizing performance degradation. Options B, C, and D do not specifically address the immediate performance impact of failover as effectively as tier-0 promotion priority, making them less suitable for this scenario.