ExpertMedium1 markMultiple Choice
GCP PCA · Question 38 · Storage Systems
You are migrating a mission-critical MySQL database to Cloud SQL. The business requires that the database remains available even if an entire GCP zone goes offline, and they need the ability to recover the database to a specific point in time if a developer accidentally drops a table. Which TWO features must you enable? (Select TWO)
You are migrating a mission-critical MySQL database to Cloud SQL. The business requires that the database remains available even if an entire GCP zone goes offline, and they need the ability to recover the database to a specific point in time if a developer accidentally drops a table. Which TWO features must you enable? (Select TWO)
Answer options:
A.
Cross-region read replicas
B.
Regional High Availability (HA)
C.
Point-in-time recovery (PITR)
D.
Cloud Storage multi-region backups
E.
Database Migration Service (DMS)
How to approach this question
Match the requirement 'survive a zone outage' to HA, and 'recover to a specific time' to PITR.
Full Answer
Cloud SQL Regional HA provides synchronous replication to a standby instance in a different zone, ensuring automatic failover during a zonal outage. Point-in-time recovery (PITR) enables you to recover data from a specific point in time (down to a fraction of a second) using write-ahead logs, which is essential for recovering from human errors like dropping a table.
Common mistakes
Confusing Read Replicas (A) with HA. Read replicas are asynchronous and require manual failover; HA is synchronous and automatic.
Practice the full GCP Professional Cloud Architect Practice Exam 6
50 questions · hints · full answers · grading
More questions from this exam
Q01CASE STUDY: TechStream Gaming
Overview:
Industry: Gaming
Size: 500 employees, $100M revenue
Env...MediumQ02CASE STUDY: TechStream Gaming
Overview:
Industry: Gaming
Size: 500 employees, $100M revenue
Env...MediumQ03CASE STUDY: TechStream Gaming
Overview:
Industry: Gaming
Size: 500 employees, $100M revenue
Env...HardQ04CASE STUDY: TechStream Gaming
Overview:
Industry: Gaming
Size: 500 employees, $100M revenue
Env...MediumQ05CASE STUDY: TechStream Gaming
Overview:
Industry: Gaming
Size: 500 employees, $100M revenue
Env...Easy