PCDE Deploy scalable and highly available databases in Google Cloud — All Questions With Answers

Question 1easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company needs to store petabytes of time-series IoT sensor data and query it with single-digit millisecond latency at millions of reads per second. The data has a simple key-value structure with timestamps. Which Google Cloud database is MOST appropriate?

Question 2hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A global financial services company requires a multi-region Spanner instance with an RPO of zero and an RTO of less than 5 seconds for a critical transactional workload. The application writes to a single region and reads from multiple regions. Which Spanner configuration should they choose?

Question 3mediummultiple choice

Review the full routing breakdown →

A healthcare company uses Cloud Bigtable for patient event logs. They need to ensure data is available in another region in case of a regional outage. They set up a second cluster in a different region with replication. What is the RPO characteristic of Bigtable replication, and what routing policy ensures reads continue if the primary cluster fails?

Question 4mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud Spanner and needs to back up a large database (several TB) for compliance reasons. They want to retain the backup for 400 days. What is the optimal approach to meet this requirement?

Question 5mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud Spanner with a multi-region configuration (nam6) for a global user database. They experience a regional outage affecting us-central1, where the leader region is located. What happens to write availability?

Question 6hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs a critical application on Cloud SQL for MySQL with an HA configuration. They want to test their disaster recovery plan without affecting production. They need to validate that a cross-region read replica can be promoted successfully in the event of a regional outage. Which approach should they take?

Question 7easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company needs to choose a Google Cloud database for a globally distributed application that requires strong consistency across continents and an SLA of 99.999% for availability. Which database service meets these requirements?

Question 8mediummulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs a Cloud Bigtable instance with two clusters in separate regions for disaster recovery. They want to ensure that read requests automatically use the secondary cluster if the primary cluster becomes unhealthy. Which two steps should they take? (Choose two.)

Question 9mediummulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company is designing a disaster recovery strategy for a Cloud SQL for PostgreSQL instance. They require an RPO of less than 5 minutes and an RTO of less than 2 minutes in the event of a regional outage. Which three components should they include in their solution? (Choose three.)

Question 10hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud Spanner with a single-region configuration in us-central1. They need to improve disaster recovery to meet an RPO of zero and an RTO of less than 5 seconds across regions. Which three actions should they take? (Choose three.)

Question 11mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company needs to store petabytes of time-series IoT sensor data and query it with single-digit millisecond latency at millions of reads per second. The data has a simple key-value structure with timestamps. Which Google Cloud database is MOST appropriate?

Question 12hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A global e-commerce platform uses Cloud Spanner in multi-region configuration. The application writes a significant portion of traffic from Europe and requires the lowest read latency in that region. Which configuration step should be taken to minimise read latency in Europe while maintaining write availability?

Question 13hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud Spanner multi-region with the nam-eur-asia1 configuration. They experience a regional outage that affects two of the three regions. What is the expected behavior regarding read and write availability?

Question 14mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company has a Cloud SQL for PostgreSQL instance with cross-region read replicas for disaster recovery. They want to test the failover process without affecting the primary instance. What is the recommended approach?

Question 15mediummultiple choice

Review the full routing breakdown →

A company uses Cloud Bigtable with replication across two regions. They want to ensure that read requests are automatically routed to the nearest available cluster with the lowest latency. Which routing policy should be configured?

Question 16easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

An application running on Compute Engine needs a relational database with high availability across zones within a single region. The application requires an RTO of less than 30 seconds and RPO of zero. Which database solution meets these requirements?

Question 17mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company needs to perform disaster recovery testing for their Cloud SQL for PostgreSQL instance. They want to validate that a cross-region failover works without affecting production. What is the BEST approach?

Question 18hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud Spanner in a multi-region configuration. They want to perform a non-destructive disaster recovery drill to validate their ability to recover from a regional failure. Which THREE steps should they include in the drill? (Choose three.)

Question 19mediummulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company needs to define backup retention policies for Cloud SQL, Spanner, and Bigtable to meet compliance requirements. Which THREE statements about backup retention are correct? (Choose three.)

Question 20mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A financial services company runs a global trading application on Cloud Spanner. They need the highest availability with 99.999% SLA and automatic failover with zero data loss. Which Spanner configuration should they choose?

Question 21mediummultiple choice

Read the full DNS explanation →

A media company uses Cloud Bigtable to serve user recommendations with low latency. They want to implement disaster recovery with a secondary cluster in a different region. They need automatic failover without manual DNS changes. Which routing policy should they configure?

Question 22mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A DevOps engineer wants to test disaster recovery for a Cloud SQL for MySQL instance by simulating a zone failure without impacting production traffic. They need to ensure minimal data loss. Which approach should they take?

Question 23mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company is designing a global user database that must support strong consistency and horizontal scaling with automatic failover. They have a 99.999% uptime requirement and need to serve writes from a single primary region with reads from multiple regions. Which Google Cloud database and configuration should they use?

Question 24hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A social media company uses Cloud Spanner with a multi-region configuration. During a regional outage, automatic failover occurred, but some transactions that were in-flight at the time of failure were lost. What is the most likely reason for this data loss?

Question 25easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A startup is building a mobile app and needs a fully managed database that scales automatically for unpredictable workloads. They expect moderate read/write traffic with occasional spikes. They want minimal operational overhead and do not need global distribution. Which Google Cloud database is MOST appropriate?

Question 26hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud SQL for PostgreSQL with cross-region read replicas for DR. They want to automate the failover process to reduce RTO. Which THREE components should they include in their automation? (Choose 3 correct answers.)

Question 27mediummulti select

Review the full routing breakdown →

A company is evaluating disaster recovery options for their production Bigtable instance. They need asynchronous replication with manual failover and the ability to route reads to the secondary cluster only when the primary is unhealthy. Which TWO settings should they configure? (Choose 2 correct answers.)

Question 28mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company needs to store petabytes of time-series IoT sensor data and query it with single-digit millisecond latency at millions of reads per second. The data has a simple key-value structure with timestamps. Which Google Cloud database is MOST appropriate?

Question 29hardmultiple choice

Read the full DNS explanation →

A gaming company uses Cloud Bigtable for player state data with two clusters in different regions (us-central1 and us-west1) for disaster recovery. They need to ensure that read traffic automatically fails over to the secondary cluster if the primary cluster becomes unhealthy. They currently have a weighted DNS routing policy. Which additional configuration is required?

Question 30easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs a critical application on AlloyDB with a primary instance and a read pool. They want to achieve the fastest possible automatic failover during a zone outage, with minimal data loss. What is the expected RTO and RPO for AlloyDB's automatic failover within the same region?

Question 31mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A healthcare company uses Cloud SQL for PostgreSQL and needs to meet a disaster recovery requirement of RPO = 1 hour and RTO = 2 hours for a cross-region failover. They currently have a cross-region read replica in another region. Which additional action should they take to meet the RPO consistently?

Question 32hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A financial services firm runs a multi-region Spanner instance with the nam-eur-asia1 configuration. They need to ensure that if the leader region (us-central1) becomes unavailable, failover to another region occurs automatically within 1 minute. What is the expected RPO and RTO for this scenario?

Question 33mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs an e-commerce platform on Cloud SQL for MySQL. They need to comply with a policy that requires database backups to be retained for 365 days. They also need to restore to any point within the last 30 days. How should they configure their backup settings?

Question 34hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A DevOps team is implementing chaos engineering for their Cloud SQL for PostgreSQL database. They want to simulate a zone failure that triggers automatic failover of their HA instance without causing data loss. Which approach should they use?

Question 35mediummulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company is designing a disaster recovery strategy for their Cloud Spanner database. They need an RPO of less than 30 seconds and an RTO of less than 1 minute. Which two configurations would meet these requirements? (Choose TWO)

Question 36mediummulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud Bigtable with two clusters in different regions for disaster recovery. They need to ensure that if the primary cluster becomes unavailable, read traffic is automatically redirected to the secondary cluster with minimal manual intervention. Which three actions should they take? (Choose THREE)

Question 37hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs a critical application on Cloud SQL for SQL Server and wants to implement a disaster recovery plan with RPO < 5 minutes and RTO < 1 hour. They are willing to accept some manual steps during failover. Which two strategies should they combine? (Choose TWO)

Question 38mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud Bigtable for a real-time analytics pipeline. They have configured replication with a primary cluster in us-central1 and a secondary cluster in us-west1. They want to minimize data loss during a failover to the secondary cluster. What is the best approach to achieve the lowest possible RPO?

Question 39hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

You are designing disaster recovery for a globally distributed application using Cloud Spanner with a multi-region configuration. The application requires an RPO of 0 and an RTO of less than 5 seconds in the event of a full region failure. Which Spanner configuration provides these guarantees?

Question 40mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud SQL for MySQL with a 1-hour RPO and 2-hour RTO. They currently rely on automated daily backups. To improve DR capabilities, they want to reduce RPO to 5 minutes while keeping costs low. Which action should they take?

Question 41mediummulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud Bigtable with replication across two regions. They want to implement a DR plan that minimizes RPO and RTO. Which TWO steps should they take? (Choose 2)

Question 42mediummulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

An organization needs to design a disaster recovery plan for Cloud SQL for PostgreSQL with an RPO of 10 seconds and an RTO of 5 minutes. Which TWO solutions meet these requirements? (Choose 2)

Question 43hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs a global application on Cloud Spanner with a multi-region configuration. They need to test their DR procedures without impacting production. Which THREE actions should they perform? (Choose 3)

Question 44easymulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud SQL for MySQL and wants to define backup retention policies for compliance. Which TWO statements about Cloud SQL backup retention are correct? (Choose 2)

Question 45mediummulti select

Read the full DNS explanation →

A company is planning disaster recovery for Bigtable. They have two clusters in different regions with replication enabled. They want to automate failover using Cloud DNS. Which THREE components are required for this automation? (Choose 3)

Question 46hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs a critical application on AlloyDB in a single zone. They want to improve resiliency with an RTO under 30 seconds and RPO near zero. Which THREE steps should they take? (Choose 3)

Question 47easymulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud Spanner and needs to design a backup strategy that meets a 24-hour RPO and 4-hour RTO. Which TWO statements are correct for achieving these goals? (Choose 2)

Question 48mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media company runs a Cloud Bigtable instance with a single cluster in europe-west1 and no replication. Their data science team needs to run large analytical scans during business hours without degrading the write throughput of the production application. They want to add read capacity with the least operational overhead and no risk to production write latency. What should they do?

Question 49hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A healthcare company runs a critical application on AlloyDB for PostgreSQL. They require a recovery point objective (RPO) of less than 1 minute and a recovery time objective (RTO) of less than 5 minutes in case of a regional failure. They want to minimize data loss and downtime. Which strategy should they implement?

Question 50mediummulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company is deploying a global application that uses Cloud Spanner. They need to ensure high availability and low latency for users in North America, Europe, and Asia. They also want to minimize write latency. Which two configurations should they choose? (Choose two.)

Question 51mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media analytics company runs a Cloud Bigtable instance with a single cluster in us-central1. Their data science team in Frankfurt reports 300 ms read latency per row, and the business requires reads to be served from within Europe to meet a data-residency policy. The team wants the lowest-latency reads in Frankfurt without changing application code. What should the database engineer do?

Question 52mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media company runs a Cloud SQL for PostgreSQL instance in us-central1 that serves a high-traffic content management system. Read traffic has grown to the point that the primary instance's CPU is saturated, but the application requires strong read-after-write consistency for a subset of queries while other queries only need read-only access to slightly stale data. The team wants to offload read-only traffic with minimal application changes and the lowest operational overhead. What should they do?

Question 53mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media analytics company runs a Cloud Bigtable instance for time-series ingestion. Their application reads with a row key that begins with a low-cardinality customer ID, and write throughput has plateaued even after adding nodes. They want to improve read and write distribution without changing the application schema. What should they do?

Question 54mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media analytics company runs a Cloud Bigtable instance with a single cluster in us-central1. The pipeline reads roughly 400,000 rows per second using KeyRegex-style prefix scans, and the team must add a second cluster in europe-west1 for read locality without changing application code or accepting stale reads. What should they configure?

Question 55easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A startup runs a Cloud SQL for PostgreSQL instance that supports an internal HR tool used only during business hours. The database administrator wants to reduce cost while keeping the instance available with minimal downtime during working hours. What should the database engineer recommend?

Question 56mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A retail company runs an e-commerce catalog on Cloud SQL for PostgreSQL in the us-central1 region. The application is read-heavy and the primary instance CPU is consistently above 85% during business hours. The team wants to offload read traffic without changing the application's write path and needs the lowest possible replication lag for reporting queries. What should they do?

Question 57hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A retail company runs Cloud SQL for PostgreSQL with a zonal primary instance in us-central1-a. They need cross-region read scaling for reporting and an automated failover target in us-east1. Which configuration should they implement?

Question 58mediummulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A healthcare analytics team stores longitudinal patient event data in AlloyDB for PostgreSQL. They need to scale read throughput for reporting queries while keeping the primary available for transactional writes, and they must minimize replication lag for near-real-time dashboards. Which TWO actions should they take? (Choose two.)

Question 59hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media analytics firm ingests hundreds of thousands of writes per second into Cloud Bigtable for time-series sensor data. They need to serve both real-time dashboards and large historical scans, and they want the cluster to scale read throughput without manual node management. They also require a single-row read latency in the low milliseconds. Which configuration should they choose?

Question 60hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A logistics company runs Cloud SQL for PostgreSQL with a primary in us-east1 and a cross-region replica in us-west1. During a regional outage in us-east1, the team wants the replica to become the new primary with the least data loss and the shortest possible interruption. Which action should they take?

Question 61hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A logistics company runs a Cloud Spanner instance with a regional configuration in europe-west1 for a shipment tracking service. A new requirement mandates that the database survive the loss of an entire Google Cloud region while keeping strong consistency and a recovery point objective of zero. What should you do?

Question 62hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A healthcare company runs Cloud SQL for SQL Server as the system of record for patient scheduling. Compliance requires that the database survive a full zonal outage with automatic failover and no data loss, and the team wants the failover target to be a synchronous standby in another zone. Which two configuration choices should the database engineer make? (Choose two.)

Question 63hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A retail company runs Cloud Spanner for its order management system. They need to deploy the database so that it can survive the loss of an entire Google Cloud region while continuing to serve writes, and they want the lowest possible write latency for users in North America and Europe. Which configuration should they choose?

Question 64hardmultiple choice

Review the full routing breakdown →

A logistics company runs Cloud Spanner for a shipment-tracking workload that must remain writable during a regional outage. The database currently uses a regional configuration in europe-west1. The team needs the highest availability option that keeps a single logical database and does not require application code changes for routing. Which configuration should they choose?

Question 65hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media company streams a recommendation service whose keys are user sessions and item IDs. The workload is read-heavy with a working set of about 40 TB and requires single-digit-millisecond reads at millions of operations per second, with strong consistency for each read. The team wants a fully managed, horizontally scalable database and plans to use Cloud Bigtable. Which TWO design choices are appropriate? (Choose two.)

Question 66mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs a Cloud SQL for PostgreSQL instance with a cross-region read replica in a different region for disaster recovery. The primary region experiences a complete outage. What is the expected RPO and RTO for promoting the read replica to become the new primary?

Question 67mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses AlloyDB for an e-commerce platform. They want to achieve the highest availability within a single region. What configuration should they use, and what is the expected failover RTO?

Question 68mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company has a Cloud SQL for MySQL instance with point-in-time recovery (PITR) enabled. They need to restore the database to a specific time exactly 2 hours ago to recover from an accidental data deletion. What is the minimum requirement for this operation?

Question 69hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs a Cloud Bigtable instance with a single cluster in us-central1. They want to implement a disaster recovery plan that meets an RPO of 5 minutes and an RTO of 10 minutes in case of a regional outage. Which actions should they take?

Question 70easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company needs to ensure that their Cloud SQL for PostgreSQL instance can recover from a zonal failure within 60 seconds with minimal data loss. Which feature should they enable?

Question 71easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A Cloud SQL for PostgreSQL instance needs to achieve a recovery point objective (RPO) of less than 1 minute and a recovery time objective (RTO) of less than 2 minutes in the event of a zone failure. Which disaster recovery strategy should be used?

Question 72mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud Bigtable for real-time analytics. They need to implement disaster recovery across regions with a recovery point objective (RPO) of no more than 5 minutes and recovery time objective (RTO) under 10 minutes. Which approach should they take?

Question 73mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

An engineer needs to create a backup of a Cloud SQL for MySQL instance that is retained for 400 days to meet compliance requirements. What is the correct approach?

Question 74easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

Which GCP database service automatically replicates data across multiple zones within a region and provides an SLA of 99.999% for multi-region configurations?

Question 75hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud Spanner in a multi-region configuration with the leader region in us-central1. They want to improve write latency for users in Europe. The application's writes are latency-sensitive and must be strongly consistent. Which action should the engineer take?

Question 76mediummulti select

Review the full routing breakdown →

A company is designing a disaster recovery plan for their Cloud Bigtable instance. They need to ensure that in the event of a regional outage, they can failover to a secondary region with minimal data loss and automatic re-routing of traffic. Which TWO actions should they take? (Choose two.)

Question 77easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

An organization requires a disaster recovery solution for Cloud SQL with a target RPO of less than 5 minutes and RTO of less than 2 hours. The primary region is us-central1, and the DR region is us-west1. Which approach should they use?

Question 78hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs a critical e-commerce platform on Cloud SQL for PostgreSQL with cross-region read replicas for DR. During a recent disaster drill, they promoted the read replica to a standalone instance. After the drill, they attempted to re-create the replica but found that point-in-time recovery (PITR) was not enabled on the promoted instance. What is the most likely cause?

Question 79easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

An organization needs to store backup copies of a Cloud Spanner database for a minimum of 365 days to comply with regulatory requirements. Which backup option should they use?

Question 80mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses AlloyDB for PostgreSQL for their operational database. They want to ensure automatic failover with the shortest possible RTO. Which configuration should they use?

Question 81hardmultiple choice

Review the full routing breakdown →

A company uses Cloud Bigtable for their analytics pipeline. They set up replication with a primary cluster in us-central1 and a secondary in us-west1. They notice that during normal operation, queries always hit the primary cluster even if the secondary is closer. What should they change to route queries to the nearest cluster automatically?

Question 82easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

An organization needs to define RTO and RPO for their database disaster recovery plan. They have a Cloud SQL for SQL Server instance with HA enabled. What are the typical RTO and RPO for an automatic HA failover?

Question 83mediummulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company is using Cloud Spanner and wants to perform disaster recovery testing. They need to validate that their backup and restore process works without impacting production. Which TWO actions should they take? (Choose 2 correct answers.)

Question 84easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A financial application requires zero data loss (RPO=0) and automatic failover within 60 seconds in the event of a zone failure. The database must support ACID transactions. Which Google Cloud service meets these requirements?

Question 85mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A global e-commerce platform uses Cloud Spanner multi-region configuration. The compliance team mandates that all write transactions must be committed in a specific geographic region to comply with data sovereignty laws. Which Spanner feature should be used to enforce this requirement?

Question 86mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

An organization uses Cloud SQL for MySQL and needs to perform disaster recovery testing by failing over to a cross-region read replica without impacting the primary instance. They want to validate the promotion process and measure the actual RTO. Which approach should be used?

Question 87mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media streaming company uses Cloud Bigtable to store user session data with a single cluster in us-east1. They want to add disaster recovery capability with an RPO of no more than 5 minutes and an RTO of under 10 minutes. Which action should they take?

Question 88easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company uses Cloud Spanner and needs to retain backups for 365 days for compliance. What is the maximum backup expiration period that can be set for a Spanner backup?

Question 89easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs a critical application on Cloud SQL for PostgreSQL with a 5-minute RPO and 30-minute RTO. They have a cross-region read replica for disaster recovery. During a planned failover test, what is the expected RPO and RTO when promoting the read replica?

Question 90mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

An organization needs a multi-region database deployment with strong consistency and an RPO of zero in normal operation. They expect a regional outage and require automatic failover within seconds. Which database service and configuration meets these requirements?

Question 91easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company wants to implement a disaster recovery plan for their AlloyDB database. They need automatic failover with minimal data loss and RTO under 30 seconds. Which configuration should they use?

Question 92easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

What is the maximum backup retention period for Cloud Spanner backups?

Question 93hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs an e-commerce platform on Cloud Spanner multi-region (nam6). They experience a regional failure affecting the leader region. After failover, they observe increased write latency. What is the most likely cause?

Question 94easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A retail company runs a customer-facing web application on a single Cloud SQL for MySQL instance in the us-central1 region. The application requires automatic failover to a standby instance in a different zone within the same region to minimize downtime if the primary zone fails. Which configuration should the company implement?

Question 95mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media company uses Cloud Bigtable for a time-series workload that ingests millions of writes per second. They need to ensure that the cluster can handle the write throughput and that data is highly available within a single region. They want to minimize latency for writes and reads. Which configuration should they choose?

Question 96hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A retail company runs Cloud SQL for SQL Server Enterprise edition in a single zone in us-east1. Their compliance team requires automatic failover to a standby in a different zone within the same region, no data loss for committed transactions, and minimal application changes. The application connects using a private IP address. Which configuration should the database engineer implement?

Question 97mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media analytics company runs a Cloud Bigtable instance with a single cluster in us-central1. The application performs sequential read-modify-write operations on individual rows, and latency spikes occur during peak ingest. You must reduce hot-spotting on individual tablet servers while keeping the row key design schema-free. What should you do?

Question 98easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A retail company runs Cloud SQL for MySQL in a single zone. The operations team requires automatic failover to a standby in a different zone within the same region if the primary zone becomes unavailable. What should you configure?

Question 99mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A logistics company runs its shipment-tracking API on Cloud SQL for PostgreSQL in the us-central1 region. During a recent zonal outage, the primary instance became unavailable and the application experienced 12 minutes of downtime before an operator manually promoted a replica. The team wants the database to recover automatically from a zonal failure with minimal application changes. What should they do?

Question 100easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A startup is deploying a new application on Google Cloud and needs a fully managed relational database that supports automatic failover and replication across zones within a region. They want to minimize operational overhead. Which Google Cloud service should they use?

Question 101hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A healthcare analytics team runs Cloud Bigtable to store time-series sensor data. They have a single cluster in us-east1 and want to add a second cluster in europe-west1 for lower-latency reads for European analysts while keeping a single logical table. The analysts run scan queries that read large contiguous key ranges. After enabling replication, the team notices that European read latency did not improve for these scans. What is the most likely cause?

Question 102hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media analytics company stores time-series event data in Cloud Bigtable. They need to keep the dataset highly available within a single region while tolerating a single-zone failure, and they want the lowest possible write latency for their ingest pipeline. Which configuration should they choose?

Question 103mediummulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A retail company runs a Cloud SQL for MySQL instance that supports a customer-facing ordering system. The database team wants to improve availability and reduce downtime during maintenance and zonal failures. They are evaluating High Availability configuration options. Which TWO statements accurately describe Cloud SQL for MySQL High Availability? (Choose two.)

Question 104mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A healthcare SaaS provider runs AlloyDB for PostgreSQL in europe-west1. They need a highly available primary that automatically fails over if the primary zone becomes unavailable, and they want to minimize recovery time. Which AlloyDB feature should they configure?

Question 105easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A startup is deploying a new internal tool on Google Cloud. The workload is a small PostgreSQL database with unpredictable, bursty traffic and they want to avoid managing servers or capacity planning. They want a fully managed service with automatic storage growth and minimal administrative overhead. Which Google Cloud service should they choose?

Question 106easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A healthcare startup runs an AlloyDB for PostgreSQL cluster and wants to offload read-only analytics queries from the primary instance. The queries are long-running and tolerate some replication lag. What should they do?

Question 107easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A startup runs a Cloud SQL for MySQL instance in asia-southeast1 and wants to improve read scalability for a growing mobile application. They want the simplest option that keeps the primary available for writes and does not require application schema changes. What should they implement?

Question 108mediummultiple choice

Read the full network assurance explanation →

An IoT company ingests telemetry into Cloud Bigtable and needs to design the row key so that writes spread evenly across all tablet servers while still supporting efficient range scans by device. Which row key design should they use?

Question 109hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A logistics company runs an AlloyDB for PostgreSQL cluster in us-central1 with a primary instance and a read pool. They want to improve availability so that a zonal failure of the primary does not cause a prolonged outage, and they want failover to be as fast as possible with minimal data loss. Which configuration should they implement?

Question 110mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A healthcare SaaS provider runs AlloyDB for PostgreSQL in a single region. They want to add read capacity for reporting workloads without affecting the primary instance's performance, and they need the read pool to stay within the same region for data residency. What should they do?

Question 111hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A logistics company runs Cloud SQL for PostgreSQL in a single region and wants to design for high availability and disaster recovery. They need automatic failover within the region for zone failures and a way to recover from a full regional outage. Which TWO configurations should they implement? (Choose two.)

Question 112hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A healthcare company runs AlloyDB for PostgreSQL and must deploy a configuration that keeps reads serving during a zonal failure while also offloading reporting queries from the primary instance. Which two components should they deploy? (Choose two.)

Question 113mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A retail company runs AlloyDB for PostgreSQL for its order service. The service experiences read-heavy spikes during flash sales, and the team wants to scale reads horizontally while keeping a single writer and minimizing replication lag to the read endpoints. Which AlloyDB capability should the database engineer use?

Question 114mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A logistics company runs Cloud Spanner for a shipment tracking system. They need to run analytical queries that scan large portions of the database without affecting transactional latency. Which approach should they use?

Question 115mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media company runs a Cloud SQL for PostgreSQL instance in us-central1 that serves a read-heavy reporting dashboard. The dashboard queries have grown to consume most of the CPU on the primary instance, degrading write performance for the transactional application. The team wants to offload reporting reads without changing the application's write connection string, and wants failover protection if the primary zone fails. Which configuration should they implement?

Question 116hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A gaming company runs Cloud SQL for PostgreSQL with a primary instance and several read replicas. During a regional event, the primary becomes unavailable and the team must promote a replica. They want to minimize data loss and ensure the promoted instance can accept writes with a consistent connection endpoint. What should they do first?

Question 117mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A retail company runs its order-processing service on a Cloud SQL for PostgreSQL Enterprise Plus instance in us-east1. The application team reports that during a recent zone-level outage the instance failed over, but the failover took several minutes and the connection string had to be changed manually. The company wants the database to fail over automatically to another zone without any application-side connection changes and to minimize the failover time. What should the database engineer configure?

Question 118easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A startup runs Cloud SQL for MySQL and wants a low-cost way to survive a zonal failure in the primary zone without manual intervention, while keeping a single primary for writes. Which configuration should they choose?

Question 119hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A logistics company runs Cloud Spanner for shipment tracking. Their SLA requires 99.999% availability, and they must survive the loss of an entire Google Cloud region while continuing to serve reads and writes. Which Spanner configuration should the database engineer choose?

Question 120mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A retail company runs its order-management service on Cloud SQL for PostgreSQL in the europe-west1 region. The database must remain writable during a zonal outage with minimal administrative overhead, and the application connects through a single stable endpoint. Which configuration should the database engineer choose?

Question 121hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs a Cloud SQL for SQL Server instance in a single zone and wants to improve availability and read scaling. They plan to add a cross-region read replica and enable high availability. Which TWO statements about this configuration are correct? (Choose two.)

Question 122easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A media company stores user activity events in Cloud Bigtable and wants the data to survive the loss of an entire zone. The team wants the lowest-latency reads for users concentrated in a single metropolitan area and does not need the data replicated to other continents. They want a configuration that provides zone-level fault tolerance with minimal write latency. What should the database engineer recommend?

Question 123hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A logistics company runs AlloyDB for PostgreSQL in a single region and has a primary instance plus a read pool for reporting. During testing, the team found that when the primary zone becomes unavailable, the read pool does not automatically take over. They want the database to automatically fail over to another zone within the same region with the shortest possible recovery time and no manual promotion. What should the database engineer do?

Question 124mediummulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A company runs Cloud SQL for MySQL and wants to improve the availability and durability of its production database. They are evaluating options for handling zone failures and data corruption. Which TWO actions should they take? (Choose two.)

Question 125mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A gaming company uses Cloud Bigtable for player session data. They have a single cluster in us-central1 and want to add a second cluster in us-east1 for disaster recovery. They need read requests from the us-east1 application tier to be served locally with the lowest possible latency, and they want writes to be replicated automatically. What should they do?

Question 126mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A healthcare analytics company runs Cloud Spanner for a patient records system that must remain available even if an entire region becomes unreachable. The team wants reads to be served from the region closest to each user while writes remain strongly consistent, and they want the configuration to tolerate regional failure without data loss. Which Spanner configuration should the database engineer choose?

Question 127easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A logistics company runs a regional Cloud Spanner instance in us-central1 with processing units sized for current traffic. The team needs the database to survive the loss of an entire zone within the region without any data loss and without manual intervention, and the application must keep writing. Which action should the database engineer take?

Question 128hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A gaming company is deploying Cloud Spanner for a new global leaderboard service. The database engineer must choose options that improve write availability and read latency without breaking strong consistency. The team plans to use a multi-region instance configuration. Which TWO design choices are appropriate? (Choose two.)

Question 129hardmulti select

Read the full Deploy scalable and highly available databases in Cloud explanation →

A healthcare company runs AlloyDB for PostgreSQL for a patient records application in a single region. They want to increase read scalability and improve availability. They plan to add a read pool and configure high availability. Which TWO statements are correct about this AlloyDB deployment? (Choose two.)

Question 130mediummultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A healthcare analytics team runs Cloud Bigtable with a single cluster in us-central1. They must add a second cluster in us-east1 so that reads can be served locally in both regions and the instance can continue serving traffic if one region becomes unavailable. Writes must be accepted in either region. Which replication configuration should the database engineer choose?

Question 131easymultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A retail company is deploying a new Cloud SQL for MySQL instance for an order management system. The database must survive a zonal failure with minimal downtime and no data loss for committed transactions. They want the simplest configuration that meets this requirement. What should they do?

Question 132hardmultiple choice

Read the full Deploy scalable and highly available databases in Cloud explanation →

A SaaS company runs AlloyDB for PostgreSQL with a primary instance and a read pool in the same region. They want the read pool to automatically take over as the new primary if the primary instance fails, with the shortest possible recovery time and no manual promotion. Which configuration should the database engineer use?