AWS Certified Database – Specialty — Question 230

A database specialist is working with a company to launch a new website. The website accesses a database on an Amazon Aurora MySQL DB cluster that is configured with several Aurora Replicas. The website will replace an on-premises website that is connected to a legacy relational database. Because of stability issues in the legacy database, the company wants to test the resiliency of the Aurora cluster.

Which action can the database specialist take to test the resiliency of the Aurora cluster?

Answer options

• A. Simulate a failover test of the Aurora cluster resiliency by using the failover testing feature from the Resiliency Toolkit.
• B. Submit a fault injection query to one of the Aurora Replica instances by connecting to the endpoint for the Aurora Replica.
• C. Simulate a failover test of the Aurora cluster by using the PromoteReadReplica API operation to promote one of the read replica DB instances to a standalone Aurora DB instance.
• D. Use Amazon RDS Performance Insights to capture resiliency-related metrics for the Aurora cluster during periods of high load.

Correct answer: B

Explanation

The correct answer is B because submitting a fault injection query to an Aurora Replica allows the database specialist to directly test the resilience of the cluster by simulating a failure scenario. Option A refers to a feature that does not exist, while C incorrectly describes promoting a read replica instead of testing resilience. Option D involves analyzing metrics rather than actively testing resilience.