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

A user is configuring the Multi AZ feature of an RDS DB. The user came to know that this RDS DB does not use the AWS technology, but uses server mirroring to achieve HA. Which DB is the user using right now?

Answer options

• A. My SQL
• B. Oracle
• C. MS SQL
• D. PostgreSQL

Correct answer: C

Explanation

Amazon RDS for MS SQL Server utilizes SQL Server Database Mirroring to achieve high availability in a Multi-AZ deployment. Other engines like MySQL, Oracle, and PostgreSQL rely on Amazon's native block-level replication to keep the standby replica synchronized.