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 retail company hosts its relational database on a single Cloud SQL instance. During peak shopping events, write operations succeed normally, but customer-facing product searches and analytical reports experience significant query latency because they compete for compute resources on the primary instance.
Which replication configuration should the database administrator implement to reduce query latency for these read-heavy workloads?
Cloud Storage dual-region buckets store object data across two distinct geographical regions, providing automatic geo-redundancy and high durability for unstructured data and file backups.
The requirement was to store database export artifacts in a durable, geo-redundant storage location to protect against regional outages.
Cloud SQL High Availability (HA) provisions a primary instance in one zone and a standby instance in a secondary zone within the same region, utilizing synchronous storage replication to keep data synchronized.
The scenario required minimizing application downtime and preventing service disruption during unexpected zonal outages or routine maintenance windows.
Cloud SQL read replicas are dedicated, read-only copies of a primary database instance. Data written to the primary instance is asynchronously replicated to one or more read replicas within the same region or across different regions.
SELECT queries frees up CPU, memory, and I/O resources on the primary instance, allowing critical write transactions to execute without performance degradation.While High Availability (HA) configurations protect against infrastructure downtime and automated backups safeguard against data loss, only read replicas are purpose-built to scale read throughput and lower query latency under heavy read load.
Automated backups capture periodic snapshots of a Cloud SQL instance, while point-in-time recovery (PITR) uses write-ahead transaction logs to allow restoring the database to an exact second in time.
The business objective was to recover from an accidental table drop or restore historical database states after data corruption.
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