Answer – C
Amazon RDS handles failovers automatically so you can resume database operations as quickly as possible without administrative intervention. The primary DB instance switches over automatically to the standby replica if any of the following conditions occur.
An Availability Zone outage
The primary DB instance fails
The DB instance`s server type is changed
The operating system of the DB instance is undergoing software patching
A manual failover of the DB instance was initiated using Reboot with failover
Hence, options A, B, and D are incorrect. Option C is CORRECT because if there is a region-wide failure, the Multi-AZ feature may not work.
For more information on multiAZ RDS, please visit the link:
https://aws.amazon.com/rds/details/multi-az/