AWS Certified Database – Specialty — Question 187

An ecommerce company runs an application on Amazon RDS for SQL Server 2017 Enterprise edition. Due to the increase in read volume, the company’s application team is planning to offload the read transactions by adding a read replica to the RDS for SQL Server DB instance.

What architectural conditions should a database specialist set? (Choose two.)

Answer options

• A. Ensure that the automatic backups are turned on for the RDS DB instance
• B. Ensure the backup retention value is set to 0 for the RDSDB instance
• C. Ensure the RDS DB instance is set to Multi-AZ
• D. Ensure the RDS DB instance is set to Single-AZ
• E. Ensure the RDS DB instance is in a stopped state to turn on the read replica

Correct answer: A, C

Explanation

The correct answers are A and C. Automatic backups must be enabled to create a read replica, as they are essential for replicating the data. Additionally, Multi-AZ deployments provide high availability and redundancy, which are beneficial for read replicas. The other options either disable necessary features or suggest configurations that do not support read replicas.