A MySQL on the Amazon RDS database is deleted. What happens to the read replicas?

Answer options:

A.All read replicas are set to replication status “terminated”.
B.Read replicas in the same region are promoted. Cross-region read replicas are set to replication status “terminated”.
C.All read replicas are promoted.
D.Read replicas in the same region are deleted. Cross-region read replicas are set to replication status “terminated”.

Answer: C
For MariaDB, MySQL, and Oracle RDS instances, when the source database is deleted, read replicas in the same region and cross-region read replicas are promoted.
For PostgreSQL RDS instances, when the source database is deleted, read replicas in the same region are promoted, and cross-region read replicas are set to replication status “terminated.”
Therefore, Option C is CORRECT, and all other options are incorrect.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html