Amazon
DBS-C01 · Question #313
A company has a Microsoft SQL Server 2017 Enterprise edition on Amazon RDS database with the Multi-AZ option turned on. Automatic backups are turned on and the retention period is set to 7 days. The c
The correct answer is D. Add the new read replica without making any other changes to the RDS database.. https://aws.amazon.com/blogs/database/using-in-region-read-replicas-in-amazon-rds-for-sql-
Submitted by noor.lb· Mar 6, 2026Management and Operations
Question
A company has a Microsoft SQL Server 2017 Enterprise edition on Amazon RDS database with the Multi-AZ option turned on. Automatic backups are turned on and the retention period is set to 7 days. The company needs to add a read replica to the RDS DB instance. How should a database specialist achieve this task?
Options
- ATurn off the Multi-AZ feature, add the read replica, and turn Multi-AZ back on again.
- BSet the backup retention period to 0, add the read replica, and set the backup retention period to
- CRestore a snapshot to a new RDS DB instance and add the DB instance as a replica to the
- DAdd the new read replica without making any other changes to the RDS database.
How the community answered
(20 responses)- A5% (1)
- B15% (3)
- C10% (2)
- D70% (14)
Explanation
https://aws.amazon.com/blogs/database/using-in-region-read-replicas-in-amazon-rds-for-sql-
Topics
#RDS SQL Server#read replicas#Multi-AZ#database operations
Community Discussion
No community discussion yet for this question.