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.
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), which provisions a primary instance and a synchronous standby replica in separate zones within the same regionRegional 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.
us-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.

ZONAL), which runs the database instance and its storage entirely within a single chosen zoneZonal availability (availability_type=ZONAL) provisions a Cloud SQL database instance and its underlying persistent disk within a single Google Cloud zone (e.g., us-central1-a). It has no standby instance in another zone.
The scenario required the lowest possible cost for non-critical development, sandbox testing, or batch workloads where downtime during zonal maintenance is acceptable.
Multi-regional, multi-master replication architectures are features of globally distributed databases like Cloud Spanner, which write synchronously across worldwide geographic zones and regions using distributed consensus algorithms.
The scenario required a globally distributed transactional database with external consistency and active read-write operations in multiple continents simultaneously.
A cross-region disaster recovery (DR) replica involves creating a read replica in a completely different geographic region from the primary instance. Cloud SQL asynchronously streams database updates to this secondary region for DR failover scenarios.
us-central1, which is solved natively by intra-region HA without cross-region deployments.The requirement mandated surviving an entire regional catastrophe or natural disaster that takes down the primary Google Cloud region completely.
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