Question

A cryptocurrency company wants to go global with its international money transfer app. your project is to make sure that the database of the app is highly available in multiple regions. what are the benefits of adding multi-az deployments in amazon rds? (select two.)

A. Creates a primary DB Instance and synchronously replicates the data to a standby instance in a different Availability Zone (AZ) in a different region.
B. Provides SQL optimization.
C. It makes the database fault-tolerant to an Availability Zone failure.
D. Increased database availability in the case of system upgrades like OS patching or DB Instance scaling.
E. Significantly increases the database performance.

Answer 1

Multi-AZ deployments in Amazon RDS create a primary DB Instance with a synchronous standby replica in a different AZ, ensuring fault tolerance and higher availability during system maintenance. It's a feature designed for continuous operation and data protection rather than performance enhancement.

Step-by-step explanation:

When leveraging Amazon RDS for database deployment with a focus on high availability across multiple regions, Multi-AZ deployments offer significant benefits. The key advantages to consider are:

• Creates a primary DB Instance and synchronously replicates the data to a standby instance in a different Availability Zone (AZ), providing fault tolerance in case an AZ becomes unavailable.
• Increased database availability in scenarios such as system upgrades, OS patching, or DB Instance scaling by failing over to the standby in case the primary database becomes unavailable due to these maintenance activities.

It is important to note that Multi-AZ deployments are aimed at ensuring continuous operation and data protection rather than enhancing performance. SQL optimization or significant performance increases are benefits typically associated with other AWS services or configuration tweaks rather than Multi-AZ deployments specifically.