ExpertMedium1 markMultiple Choice
GCP ACE · Question 28 · Domain 3.4: Deploying and implementing data solutions
You are initializing a new Cloud SQL for PostgreSQL instance for a production application. The database must be highly available and able to survive a zone failure with zero data loss and minimal downtime.
Which TWO configuration choices must you make during initialization? (Select TWO)
You are initializing a new Cloud SQL for PostgreSQL instance for a production application. The database must be highly available and able to survive a zone failure with zero data loss and minimal downtime.
Which TWO configuration choices must you make during initialization? (Select TWO)
Answer options:
A.
Select 'Zonal' availability.
B.
Select 'Regional' availability.
C.
Enable automatic backups.
D.
Create a read replica in a different region.
E.
Enable Cloud Spanner integration.
How to approach this question
Understand the requirements for High Availability (HA) in Cloud SQL.
Full Answer
Select 'Regional' availability., Enable automatic backups.
To configure High Availability (HA) in Cloud SQL, you must select 'Regional' availability. This provisions a primary instance and a standby instance in a different zone with synchronous replication. Furthermore, Cloud SQL requires automatic backups to be enabled in order to support HA configurations.
Common mistakes
Confusing Read Replicas (which are asynchronous and manual failover) with Regional HA (which is synchronous and automatic failover).
Practice the full GCP Associate Cloud Engineer Practice Exam 3
50 questions · hints · full answers · grading
More questions from this exam
Q01You are starting a new project in Google Cloud and need to create a new GCP project and enable th...EasyQ02A new team member has joined your operations team. They need to be able to view all Compute Engin...MediumQ03Your company is migrating to Google Cloud. You currently manage all employee identities in an on-...MediumQ04Your development team is experimenting with new GCP services in a sandbox project. The finance te...MediumQ05Your company wants to perform complex, custom SQL analysis on their Google Cloud billing data to ...Easy