AWS Certified SysOps Administrator – Associate (legacy) — Question 907

A user has enabled the Multi AZ feature with the MS SQL RDS database server. Which of the below mentioned statements will help the user understand the Multi
AZ feature better?

Answer options

• A. In a Multi AZ, AWS runs two DBs in parallel and copies the data asynchronously to the replica copy
• B. In a Multi AZ, AWS runs two DBs in parallel and copies the data synchronously to the replica copy
• C. In a Multi AZ, AWS runs just one DB but copies the data synchronously to the standby replica
• D. AWS MS SQL does not support the Multi AZ feature

Correct answer: C

Explanation

In an Amazon RDS Multi-AZ deployment, AWS provisions a single active primary database instance and synchronously replicates the data to a passive standby instance in another Availability Zone. Since the standby instance does not actively serve database traffic under normal operations, AWS is not running two active databases in parallel. This makes option C the correct description of the architecture.