Unlock the power of your data in the cloud! Get hands-on with Google Cloud's core data services like BigQuery and Looker to validate your practical skills in data ingestion, analysis, and management, and earn your Associate Data Practitioner certification!
Prepare and test your skills
Prepare and test your skills
Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.
A data analytics team is configuring a new Cloud SQL instance in the us-central1 region to support business intelligence dashboards. The team needs to ensure the database automatically fails over if a single data center zone experiences an outage, while keeping compute resources within the same geographic region to minimize network latency and cross-region egress costs.
Which storage location availability configuration should the team select for the Cloud SQL instance?
Regional availability (availability_type=REGIONAL) is Cloud SQL's built-in High Availability (HA) configuration. In a regional deployment, Cloud SQL provisions a primary instance in one zone and a standby instance in another zone within the same geographic region. Data is synchronously replicated across the persistent storage of both zones.
StudyCerts
StudyCertsus-central1), intra-region network communication maintains low latency.Compared to single-zone setups, regional availability provides automated fault tolerance against zonal disasters. Compared to cross-region topologies, it provides lower write latency and significantly reduced network costs.
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.