Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
An enterprise company hosts a primary Cloud SQL database in us-central1. The company wants to accomplish two primary objectives:
europe-west1).us-central1 suffers an outage.Which replication strategy should the company choose, and which operational trade-off must they manage?
europe-west1, and monitor replication lag caused by asynchronous data replication.In Google Cloud SQL, a cross-region read replica is a separate database instance provisioned in a different geographic region from the primary instance. Data modifications on the primary instance are replicated asynchronously across Google's global network to the replica instance.
europe-west1 allows European analysts to direct analytical and reporting queries to a local database instance, significantly reducing network latency compared to querying the primary database across the Atlantic.
This approach uses automated or manual database exports (such as SQL dumps or CSV files) stored inside a Google Cloud Storage bucket, which can later be imported into a new database instance.
The organization needed an offline, low-cost long-term backup archive for compliance purposes where recovery time and recovery point objectives exceed 24 hours.
Automatic storage increase is a Cloud SQL management setting that automatically expands the disk capacity of an instance when available free disk space drops below a critical threshold, preventing the instance from running out of disk space.
us-central1 does nothing to reduce transatlantic network latency for analysts in Europe.The primary instance was failing because transaction logs and data growth were filling the available disk capacity, causing replication failures or instance downtime.
Cloud SQL high availability (HA) provides automatic failover within the same region by synchronously replicating data to a standby instance located in a different zone (e.g., us-central1-a to us-central1-f).
us-central1), an outage affecting the entire region would render both instances inaccessible.The requirement called for automatic, synchronous sub-minute failover between data center zones within the same region (us-central1) without needing to offload read queries or handle full regional disasters.
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