PCDOE Design for Reliability, Scalability, and Disaster Recovery — All Questions With Answers

Question 1easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 2mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 3hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 4mediummultiple 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 5mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 6mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 7mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 8hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 9easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 10mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 11hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 12easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 13mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 14mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 15hardmulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 16mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 17easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 18hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 19mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 20mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 21hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 22easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 23mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 24mediummultiple 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 25easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 26hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 27mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 28mediummulti 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 29hardmulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 30mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 31easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 32mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 33mediummultiple 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 34hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 35easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 36mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 37mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 38hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 39easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 40mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 41hardmultiple 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 42easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 43mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 44hardmulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 45mediummulti 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 46mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 47easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 48mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 49mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 50hardmultiple 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 51easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 52mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 53hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 54mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 55mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 56easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 57hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 58mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 59mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 60hardmulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 61easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 62mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 63mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 64hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 65easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 66mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 67easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery explanation →

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

Question 68hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 69mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 70mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 71hardmulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 72easymulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 73mediummulti 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 74hardmulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 75easymulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 1easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 2mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 3hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 4mediummultiple 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 5mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 6mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 7mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 8hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 9easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 10mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 11hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 12easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 13mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 14mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 15hardmulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 16mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 17easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 18hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 19mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 20mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 21hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 22easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 23mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 24mediummultiple 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 25easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 26hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 27mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 28mediummulti 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 29hardmulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 30mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 31easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 32mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 33mediummultiple 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 34hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 35easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 36mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 37mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 38hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 39easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 40mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 41hardmultiple 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 42easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 43mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 44hardmulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 45mediummulti 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 46mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 47easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 48mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 49mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 50hardmultiple 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 51easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 52mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 53hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 54mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 55mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 56easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 57hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 58mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 59mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 60hardmulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 61easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 62mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 63mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 64hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 65easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 66mediummultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 67easymultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery explanation →

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

Question 68hardmultiple choice

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 69mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 70mediummulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 71hardmulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 72easymulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 73mediummulti 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 74hardmulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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 75easymulti select

Read the full Design for Reliability, Scalability, and Disaster Recovery 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)