ExpertMedium1 markMultiple Choice
GCP PCA · Question 36 · Domain 1: Designing and Planning a Cloud Solution Architecture
You are designing a highly available Cloud SQL architecture for a mission-critical application. Which TWO configurations are required to ensure automatic failover in case of a zone outage? (Select TWO)
You are designing a highly available Cloud SQL architecture for a mission-critical application. Which TWO configurations are required to ensure automatic failover in case of a zone outage? (Select TWO)
Answer options:
A.
Enable High Availability (Regional) on the instance.
B.
Create a cross-region read replica.
C.
Configure Cloud DNS to route to the standby IP.
D.
Ensure the application uses the standard connection string, as the IP remains the same during failover.
E.
Manually promote the standby instance during an outage.
How to approach this question
Understand Cloud SQL HA mechanics.
Full Answer
Enable High Availability (Regional) on the instance.
Ensure the application uses the connection pooler or standard connection string, as the IP remains the same during failover.
Cloud SQL HA creates a synchronous standby in a different zone. During a failure, the primary IP automatically points to the standby, requiring no application changes.
Common mistakes
Thinking HA requires manual DNS or IP changes.
Practice the full GCP Professional Cloud Architect Practice Exam 2
50 questions · hints · full answers · grading
More questions from this exam
Q01CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...MediumQ02CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...MediumQ03CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...HardQ04CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...MediumQ05CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...Easy