You migrated an on-premise MySQL database to AWS RDS MySQL in region ap-southeast-1. The database has stored key information such as customers’ phone numbers, addresses and date of birth. In order to decrease the read load on the master DB instance, a Read Replica has been created in region ap-southeast-2. This Read Replica can also be promoted as a data recovery scheme if the source DB instance fails. In which scenarios can the data be successfully recovered by the Read Replica? (Select TWO.) 

Answer options:

A.Data has been deleted mistakenly by a bug in the application code.
B.A RDS hardware failure on the master instance.
C.AWS account is compromised.
D.The master database instance has been mistakenly deleted.
E.An AWS regional failure happening in both ap-southeast-1 and ap-southeast-2.

Correct Answer – B, D
When creating a Read Replica, the user can select another region so that updates made to the source DB instance are copied to the Read Replica in this new region:
When needed, this Read Replica can be promoted to be a new standalone instance.
Option A is incorrect: Because the data gets deleted in the Read Replica as well. In this case, to recover the data, regular DB snapshots are needed.
Option B is CORRECT: Because the hardware failure only affects the master node. Promoting the Read Replica can recover the database.
Option C is incorrect: Because it affects all regions and replicas may also be deleted.
Option D is CORRECT: Because Read Replica still exists and can be used to be a functional database.
Option E is incorrect: Because the hardware failure exists in both regions so that Read Replica may not fully work.