nerdexam
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)
  • A
    5% (1)
  • B
    15% (3)
  • C
    10% (2)
  • D
    70% (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.

Full DBS-C01 Practice