ExpertGCP PCA · Question 40 · Domain 2: Managing and Provisioning a Solution Infrastructure
You are provisioning a Cloud SQL for MySQL instance for a production application. The application requires high availability (HA) to survive a zone failure, and needs to support heavy read traffic from reporting dashboards without impacting the primary transactional workload. Which TWO configurations should you enable? (Select TWO)
You are provisioning a Cloud SQL for MySQL instance for a production application. The application requires high availability (HA) to survive a zone failure, and needs to support heavy read traffic from reporting dashboards without impacting the primary transactional workload. Which TWO configurations should you enable? (Select TWO)
Answer options:
Enable Regional High Availability (HA) to create a standby instance in a different zone.
Configure a multi-region Cloud Spanner instance.
Create a Read Replica and point the reporting dashboards to it.
Enable automated backups and point the reporting dashboards to the backup bucket.
Increase the vCPU and RAM of the primary instance to handle both workloads.
How to approach this question
Full Answer
Common mistakes
Practice the full GCP Professional Cloud Architect Practice Exam 4
50 questions · hints · full answers · grading