A database is being hosted using the Amazon RDS service. This database will be deployed in production and needs to be highly available. Which of the following could be used to achieve this requirement?

Answer options:

A.Use Multi-AZ for the RDS instance to ensure that a secondary database is created in another region.
B.Use the Read Replica feature to create another instance of the DB in another region.
C.Use Multi-AZ for the RDS instance to ensure that a secondary database is created in another Availability Zone.
D.Use the Read Replica feature to create another instance of the DB in another Availability Zone.

Correct Answer - C
Option A is incorrect because the Multi-AZ feature allows high availability across Availability Zones, not regions.
Options B and D are incorrect because Read Replicas can be used to offload database reads. But if you want high availability, the Multi-AZ feature is required.
AWS Documentation mentions the following:
Amazon RDS Multi-AZ deployments provide enhanced availability and durability for Database (DB) Instances. When you provision a Multi-AZ DB Instance, Amazon RDS automatically creates a primary DB Instance and synchronously replicates the data to a standby instance in a different Availability Zone (AZ).
For more information on AWS RDS Multi-AZ, please visit the following URL:
https://aws.amazon.com/rds/details/multi-az/