Crucial Exams

GCP Professional Data Engineer Practice Question

A financial services company runs a mission-critical PostgreSQL database on Cloud SQL in us-central1. Compliance mandates zero data loss (RPO = 0) if the zone hosting the primary instance becomes unavailable, and the application must reconnect automatically within seconds. The team wants to minimize operational overhead and does not require cross-region disaster recovery. Which deployment best meets these requirements while controlling costs?

  • Provision the database as a Cloud SQL regional instance (high availability), which keeps a standby in another zone with synchronous replication and automatic failover.

  • Place the Cloud SQL instance behind a global TCP proxy load balancer and enable zonal persistent-disk replication; rely on the load balancer to route traffic after a zonal outage.

  • Create a cross-region read replica in another region and configure the application to promote it manually if the primary becomes unavailable.

  • Keep a single-zone Cloud SQL instance but schedule frequent automated backups and rely on point-in-time recovery if the zone fails.

GCP Professional Data Engineer
Maintaining and automating data workloads
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot