Prepare and test your skills

Prepare and test your skills

Free sample question with answers and detailed explanation below. The Associate Cloud Engineer practice bank has an additional 2,014 practice questions.Try 10 free realistic questions: instant score, no credit card, and no account required.
An enterprise runs a critical application using a Cloud SQL instance configured with High Availability (HA) in the us-central1 region. The architecture team needs to enhance the deployment to meet two specific requirements:
europe-west1)us-central1 region experiences an outageWhich replication and disaster recovery strategy should you implement?
Point-in-time recovery (PITR) utilizes automatic database backups and write-ahead transaction logs (such as binary logs in MySQL or WAL in PostgreSQL) to restore a database to a specific second in the past.
europe-west1.SELECT queries.The goal was to recover from an accidental administrative error (such as an unintended DROP TABLE command) by restoring the database state to a timestamp immediately prior to the incident.

europe-west1, significantly lowering latency and offloading read traffic from the primary database in us-central1.Cloud SQL HA provides intra-region zone resilience, but only cross-region read replicas provide both distributed geographical read access and cross-region failover capabilities during full regional disruptions.
Exporting database dumps involves executing manual or scheduled SQL export tasks or Cloud Storage backups to persist database snapshots in object storage.
The workload was non-critical, had relaxed recovery targets of several hours or days, and only required low-cost cold archival storage rather than active global read capability.
Cloud SQL High Availability (HA) is a regional service configuration that provisions a primary instance and a standby instance across two separate zones within the same Google Cloud region.
europe-west1.The requirement were strictly to provide automated failover across zones within us-central1 during localized data center outages without requiring cross-region disaster recovery or global read offloading.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated