You plan to deploy Cloud SQL using MySQL. You need to ensure high availability in the event of a zone failure. What should you do?

A Create a Cloud SQL instance in one zone, and create a failover replica in another zone within the same region.

B Create a Cloud SQL instance in one zone, and create a read replica in another zone within the same region.

C Create a Cloud SQL instance in one zone, and configure an external read replica in a zone in a different region.

D Create a Cloud SQL instance in a region, and configure automatic backup to a Cloud Storage bucket in the same region.

EVERY WHERE I AM GEETING ANSWER C BUT I AM CONFUSED ALL THE GOOGLE BLOG IS SHWOING A AND THE JUSTTIFIACTION IS Multiple zones (Highly available) Automatic failover to another zone within your selected region. Recommended for production instances. Increases cost."

hence please help to guide only the correct answer will be appreciated else i will directly give you negative rating