PCDE Manage a solution that can span multiple database technologies — All Questions With Answers

Question 1hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

Your Cloud Bigtable instance uses HDD storage. You need to change to SSD to improve read performance. What is the correct procedure?

Question 2hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A development team uses Cloud Spanner and needs to add a new index to a table with 10 TB of data. They require that the operation does not block writes or cause downtime. Which approach should they take?

Question 3easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company is using Cloud Firestore to store user profiles. They need to query users by both their 'age' and 'city' fields. What must they configure to perform this query efficiently?

Question 4mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

An engineer is managing a Cloud Spanner database and needs to add a new column to an existing table without downtime. Which approach should be used?

Question 5mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You are using Memorystore for Redis with persistence disabled. Your application requires that no data is lost in the event of a node failure. What should you do to achieve this requirement?

Question 6mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

You are designing a disaster recovery strategy for a Cloud SQL for MySQL instance that hosts a critical OLTP application. The instance is in us-central1. You need to ensure that you can recover the database to a different region within 1 hour of a regional outage, with minimal data loss. Which TWO actions should you take? (Choose TWO.)

Question 7mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud Spanner and wants to export a database for long-term archival. The export must include the schema in a portable format. Which export option should they choose?

Question 8hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud Spanner and needs to export a full database to Cloud Storage in a format that preserves both the schema and data for long-term archival. The export must be restorable into a new Spanner database later. Which export method should they use?

Question 9mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Bigtable and wants to change the storage type from HDD to SSD to improve read performance. What must the engineer do to implement this change?

Question 10mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud SQL for MySQL with automated backups enabled. They want to ensure they can recover their database in the event of a regional outage. Which TWO actions should they take? (Choose two.)

Question 11mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Memorystore for Redis instance is running out of memory and evicting keys. The application requires critical keys to be retained. The team wants to implement an eviction policy that removes less recently used keys first. Which eviction policy should they configure?

Question 12mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Spanner database needs a new index added to support a new query pattern. The database is serving live traffic. Which approach should be taken?

Question 13easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A team needs to monitor CPU utilization on Cloud SQL databases and receive an alert when it exceeds 80% for more than 5 minutes. Which Google Cloud service should they use?

Question 14hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Firestore database in Native mode has a collection with a composite index on fields (city, age). A new query filters on 'city == 'London' AND 'age > 30' ORDER BY 'name'. The query is slow and reads many documents. What should the engineer do?

Question 15mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is migrating on-premises MySQL databases to Cloud SQL. They need to ensure high availability and disaster recovery with minimal data loss. Which TWO configurations should they implement?

Question 16mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud Spanner for a global inventory system. They need to add a new index on an existing table to support a new query pattern without downtime. What is the correct approach to create the index?

Question 17easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company is using Memorystore for Redis and needs to persist data across restarts. Which option should they use?

Question 18hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is using Memorystore for Redis as a session store. They need to scale horizontally to handle increasing traffic and ensure high availability with automatic failover. Which TWO actions should they take?

Question 19mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

An engineer needs to restore a Cloud Spanner database from a backup that was taken 2 hours ago. The backup is stored in Cloud Storage. What steps are required?

Question 20hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Bigtable instance is experiencing high latency and uneven load distribution. The operations team suspects a hot spot. Which tool should they use to identify the hot spot, and what action can they take to mitigate it?

Question 21mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for PostgreSQL read replica is experiencing replication lag of several minutes. You need to reduce the lag. What is the most effective solution?

Question 22mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

Your team manages a Cloud SQL for MySQL instance used by a critical application. You need to ensure the instance is recoverable to any point within the last 4 days, with a Recovery Point Objective (RPO) of under 5 minutes. What configuration steps are required?

Question 23hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You are responsible for a Cloud Spanner instance that serves a global user base. A new feature requires adding an index on a column of an existing table that contains millions of rows. The table is actively used by production traffic. What is the recommended approach to add the index with minimal impact?

Question 24easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

Your Cloud Bigtable instance is experiencing high latency for certain row key ranges. You suspect a hotspot is developing. Which Google Cloud tool should you use to visualize and diagnose the hotspot?

Question 25mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You manage a Memorystore for Redis instance that is regularly hitting its maximum memory limit. The application can tolerate some data loss and prefers to keep the most recently used data. Which eviction policy should you configure?

Question 26mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

Your Firestore database in Native mode is used by a mobile app. You need to query a collection where documents are filtered by two fields: 'status' (string) and 'createdAt' (timestamp). The query is not performing as expected. What action is required?

Question 27hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You need to set up disaster recovery for a Cloud SQL for PostgreSQL instance. The primary instance is in us-central1, and you want a standby in us-west1 that can be promoted to a standalone instance during a regional outage. The solution must minimize data loss and recovery time. Which approach should you take?

Question 28easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for MySQL instance is running low on disk space. You have enabled automatic storage increase, but you also want to be proactively alerted when disk usage exceeds 80%. Which steps should you take?

Question 29mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

Your Memorystore for Redis instance is used as a session store for a web application. You need to ensure that session data is not lost during a node failure. What should you do?

Question 30mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You have a Cloud Spanner database that needs to be migrated from one region to another. You want to ensure no data loss and minimal downtime. Which approach should you use?

Question 31easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You need to monitor the replication lag between a Cloud SQL for MySQL primary instance and its read replica. Which metric should you use to set up an alert?

Question 32mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

Your Firestore database in Native mode contains a collection with millions of documents. You need to query documents where the 'tags' field (an array) contains the string 'urgent'. What must you ensure in your index configuration?

Question 33hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

Your company runs a global e-commerce platform on Cloud Spanner. You need to capture real-time changes to a table (e.g., orders) and stream them to a downstream analytics pipeline in near real-time. Which TWO Google Cloud features or services should you combine to achieve this? (Choose two.)

Question 34mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

You have a Memorystore for Redis instance used as a cache. You need to scale it to handle increased load. The current instance is Basic Tier with 2 GB memory. Which TWO actions can you take to scale the instance? (Choose two.)

Question 35mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

You are designing a disaster recovery plan for a Cloud Bigtable instance. The instance has a single cluster in us-east1. You need to ensure that if the cluster becomes unavailable, the database can still serve read and write requests with minimal downtime. Which THREE steps should you take? (Choose three.)

Question 36mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud SQL for MySQL to run an e-commerce application. They need to ensure that they can recover the database to any point within the last 4 days. They also want to minimize storage costs. Which configuration should they use?

Question 37mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for PostgreSQL instance is experiencing high read traffic. You need to offload read queries and ensure the solution can survive a regional outage. What should you do?

Question 38mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for MySQL instance is running out of storage. The team wants to increase storage automatically without manual intervention. However, they also want to control costs and avoid a sudden increase in storage beyond 1 TB. What should they do?

Question 39hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A financial application uses Cloud Spanner and requires daily full backups stored in another region for compliance. The backups must be restorable without exporting/importing. Which backup method should they use?

Question 40mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Bigtable instance is experiencing high read latency. The team suspects hot spotting on a single node. Which tool should they use to identify the hotspot?

Question 41easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Memorystore for Redis instance needs to ensure data is not lost during a maintenance event. The team decides to enable persistence. However, Memorystore does not support Redis persistence. What is the recommended alternative?

Question 42mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for PostgreSQL instance has a read replica lagging behind the primary. The team needs to monitor the replica lag and set up an alert if it exceeds 60 seconds. Which metric should they use?

Question 43easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Memorystore for Redis instance is running out of memory. The team wants to automatically remove the least recently used keys when memory is full. Which eviction policy should they configure?

Question 44hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company has a Cloud Bigtable cluster using HDD storage. They are migrating to a workload that requires lower latency, so they need to switch to SSD storage. How should they accomplish this?

Question 45mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

An application uses Cloud Firestore. The team notices that queries on a collection with an array field are slow. They want to create an index on the array field. What should they do?

Question 46mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud Spanner and needs to implement change data capture (CDC) to stream changes to a downstream analytics pipeline. Which two features can they use? (Choose TWO.)

Question 47hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Bigtable instance is configured with asynchronous replication across two regions for disaster recovery. The team needs to ensure that read-after-write consistency is maintained within a region. Which three strategies should they implement? (Choose THREE.)

Question 48mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for MySQL instance is being used for a production application. The team wants to implement a disaster recovery plan that can recover from a regional outage with minimal data loss and automatic failover. Which three steps should they take? (Choose THREE.)

Question 49easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company has a Cloud SQL for PostgreSQL instance and wants to enable point-in-time recovery (PITR) with a recovery window of 5 days. Which configuration step is required?

Question 50mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Memorystore for Redis and wants to ensure data is preserved in case of a node failure. They cannot afford any data loss. What should they do?

Question 51hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Bigtable instance experiences a sudden increase in read latency and request errors. The operations team notices that one node is handling disproportionately more traffic. Which tool should they use to diagnose the issue?

Question 52mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

An e-commerce application uses Firestore in Native mode. The team needs to run a query that filters on two fields and orders by a third field. What is the correct approach to ensure this query runs efficiently?

Question 53hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company has a Cloud SQL for MySQL instance with automated backups enabled. They need to restore the database to a specific timestamp from 2 days ago. The backup retention is set to 7 days. How should they perform this restore?

Question 54mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company runs a Cloud Bigtable instance with SSD storage and wants to switch to HDD storage to reduce costs. The instance cannot tolerate downtime for data migration. What is the correct approach?

Question 55easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for MySQL instance is experiencing high CPU utilisation (>80%) and slow query performance. The instance has auto-storage increase enabled. Which step should the engineer take to immediately reduce CPU load?

Question 56mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Memorystore for Redis with the 'volatile-lru' eviction policy. They notice that recently added keys with TTL are being evicted even though there is still memory available. What is the most likely cause?

Question 57hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Spanner database has a table with a primary key and a secondary index. The application frequently queries using a filter on the secondary index column and orders by the primary key. The queries are slow. What should the database administrator do to improve query performance?

Question 58mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Firestore in Native mode and has a collection with many documents containing array fields. They want to index the array values to support queries like 'array-contains'. What is the correct approach?

Question 59easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A team is using Cloud SQL for PostgreSQL and wants to monitor replication lag on their read replicas. Which metric should they use?

Question 60mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company wants to use Cloud SQL for MySQL to serve a read-heavy application. They need to ensure high availability and offload read traffic. Which TWO steps should they take? (Choose two.)

Question 61hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

An organisation wants to back up their Cloud Spanner database and store the backup in a different region for disaster recovery. They require the backup to be in a format that can be restored into Spanner with minimal effort. Which THREE actions should they take? (Choose three.)

Question 62mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is using Cloud SQL for PostgreSQL and needs to perform a disaster recovery drill by promoting a read replica to a standalone instance. They also need to ensure the replica is as current as possible before promotion. Which TWO steps should they take? (Choose two.)

Question 63mediummultiple choice

Read the full Manage a solution that can span multiple database technologies 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 64hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You are managing a Cloud SQL for PostgreSQL instance with point-in-time recovery (PITR) enabled. The retention period is set to 7 days. A developer accidentally dropped a critical table 3 days ago. You need to restore the database to the state just before the table was dropped, without affecting the current production instance. What should you do?

Question 65mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You have a Memorystore for Redis instance that serves as a session store for a web application. The instance is running low on memory and is approaching the maxmemory limit. You want to ensure that the least recently used keys are evicted first when memory is full. Which eviction policy should you configure?

Question 66easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A developer wants to add a composite index in Firestore to support a query that filters on two fields: 'status' (equality) and 'createdAt' (range). How should the index be configured?

Question 67mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You are using Cloud Spanner and need to add a new column to an existing table. The table has millions of rows and must remain fully available for reads and writes during the schema change. What is the correct approach?

Question 68hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You notice that your Cloud SQL for MySQL instance's storage is filling up quickly. You have enabled automatic storage increase, but you want to manually increase the storage size by 50 GB to avoid any risk of reaching the limit. The current disk size is 200 GB. What is the correct gcloud command to resize the disk?

Question 69easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You need to monitor the disk usage of your Cloud SQL instances and receive an alert when disk usage exceeds 80%. Which GCP service should you use to set up this alert?

Question 70mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You have a Cloud Bigtable instance with a single cluster. To improve availability and durability, you want to enable replication across two regions. After configuring replication, you notice that reads from the replica cluster show data that is not yet consistent with the primary. What is the expected consistency model for Bigtable replication?

Question 71easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You need to create a read replica of a Cloud SQL for PostgreSQL instance in a different region for disaster recovery. What must be true about the primary instance to support cross-region replicas?

Question 72mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You are troubleshooting a Cloud SQL read replica that is experiencing high replication lag. You check the 'replication_lag' metric and see it is consistently above 60 seconds. What is the most likely cause of this lag?

Question 73hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

Your Cloud Bigtable instance is experiencing hot spots, causing performance degradation. You want to identify the specific row keys causing the hot spots. Which tool should you use?

Question 74mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

Your organisation uses Cloud Spanner for a globally distributed application. You need to set up a backup strategy that allows restoring the database to a specific point in time within the last 7 days, with minimal impact on performance. Which THREE actions should you take? (Choose THREE.)

Question 75hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

You are managing a Memorystore for Redis instance that is part of a high-traffic e-commerce application. The instance uses the volatile-lru eviction policy and has persistence disabled. You need to improve data durability without losing the ability to evict keys with TTL. You also want to ensure that the instance can automatically recover from a zonal failure. Which TWO actions should you take? (Choose TWO.)

Question 76mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company is using Cloud SQL for PostgreSQL and needs to perform point-in-time recovery (PITR) to recover from a logical error that occurred 30 minutes ago. They have already configured automated backups. What additional configuration is required?

Question 77easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

An organization needs to run a disaster recovery drill for its Cloud SQL for MySQL instance by promoting a read replica to a standalone instance. The replica is in the same region as the primary. After the drill, they want the original primary to resume serving writes. What should they do?

Question 78hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Spanner database is experiencing high CPU utilization (above 80%). The team wants to add an index to optimize a frequently used query. The schema change must not cause downtime. How should they proceed?

Question 79mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Bigtable for real-time analytics. They notice that writes to a specific row range are significantly slower. The Key Visualizer shows a hotspot. What is the most likely cause and recommended action?

Question 80easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A developer needs to connect to a Memorystore for Redis instance from a Compute Engine VM in the same VPC network. The Redis instance has AUTH enabled. What must the developer provide in the connection string?

Question 81mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Firestore database in Native mode is used for a mobile app. The app queries a collection with a composite filter on two fields. Queries are slow and the app shows an error that an index is required. What should the developer do?

Question 82hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

An organization is using Cloud SQL for MySQL with automated backups enabled. They need to restore a backup to a new instance in a different region for testing. The backup is stored in the same region as the source. How can they achieve this with minimal operational overhead?

Question 83easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for PostgreSQL instance is running low on disk space. The database size is 500 GB and the current storage is 600 GB. The engineer needs to increase storage to 800 GB without downtime. What should they do?

Question 84hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Bigtable cluster is configured with SSD storage. The team needs to reduce costs by switching to HDD storage while maintaining the same cluster ID and node count. What is the correct approach?

Question 85mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Memorystore for Redis instance is experiencing out-of-memory errors, causing keys to be evicted. The application relies on all keys being present. The current maxmemory-policy is allkeys-lru. What should the engineer do to prevent evictions?

Question 86mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Firestore in Datastore mode. They need to create a composite index for a query that filters on two properties. The query is already running and returning an error that an index is required. What is the correct way to create this index?

Question 87mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for MySQL instance has a read replica in a different region. The team wants to monitor replication lag and receive alerts if lag exceeds 60 seconds. Which two steps should they take? (Choose TWO.)

Question 88hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is migrating its on-premises PostgreSQL database to Cloud SQL. The database is 2 TB and the migration must have minimal downtime. The source database supports continuous archiving. Which three steps should they take? (Choose THREE.)

Question 89easymulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A development team is using Firestore in Native mode. They want to ensure that queries on array fields return correct results. Which two actions should they take? (Choose TWO.)

Question 90mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A retail company uses Cloud SQL for MySQL with point-in-time recovery (PITR) enabled. They need to recover the database to a specific second from 2 days ago. The backup retention is set to 7 days. Which action should the engineer take to perform the recovery?

Question 91easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A game development company wants to use Memorystore for Redis as a session store. They need to ensure that when memory is full, the least recently used keys are evicted first. Which eviction policy should they configure?

Question 92hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A financial services company uses Cloud Spanner for a globally distributed application. They need to add a new column to an existing table that contains billions of rows. The change must not cause any downtime or performance degradation. How should the engineer implement this schema change?

Question 93mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud SQL for PostgreSQL and wants to create a cross-region read replica for disaster recovery (DR) purposes. They also want the option to promote the replica to a standalone instance in the event of a regional outage. What should the engineer do?

Question 94mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A data analytics company uses Bigtable for high-throughput writes. They notice that some rows are receiving a disproportionate number of reads and writes, causing performance degradation. Which tool should they use to identify and resolve this hot spotting issue?

Question 95easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A startup is building a mobile application and needs a real-time database that automatically scales to handle sudden spikes in user traffic. They want to minimise operational overhead and only pay for the resources they use. Which Google Cloud database should they choose?

Question 96hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Memorystore for Redis with Standard Tier (replication) and needs to ensure data durability in case of a zone failure. They also need to scale read throughput beyond a single instance. What should they do?

Question 97easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for PostgreSQL instance is running out of storage. The engineer wants to configure automatic storage increase to avoid manual intervention. What should they do?

Question 98mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Firestore in Native mode for their application. They need to query a collection where documents must match a specific field value and be sorted by a different field. The query filters on 'status' and orders by 'timestamp'. What should the engineer do to ensure the query performs optimally?

Question 99easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

An engineer needs to monitor the replication lag of a Cloud SQL read replica. Which metric should they use in Cloud Monitoring?

Question 100mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Memorystore for Redis and wants to achieve high availability with automatic failover. They also need to periodically back up the data to Cloud Storage for disaster recovery. Which TWO features should they use? (Choose two.)

Question 101hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud Spanner and needs to capture real-time changes from a table for downstream processing. They want to avoid writing custom application code to track changes. Which THREE components should they use? (Choose three.)

Question 102mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company is running a Cloud SQL for PostgreSQL instance for an e-commerce application. They need to enable point-in-time recovery (PITR) with a 7-day retention period. What configuration steps must be taken?

Question 103easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A team wants to create a Cloud Spanner database backup and store it in a Cloud Storage bucket for long-term archival. Which method should they use?

Question 104hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Bigtable instance is experiencing high read latency due to hot spots. The operations team uses the Key Visualizer tool and identifies that a small set of row keys are being read disproportionately. Which action should they take to mitigate the hot spotting?

Question 105mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

An application uses Firestore in Native mode. The query filters on two fields: 'status' (string) and 'created_date' (timestamp). The query returns results but the billing shows high document reads. What is the most likely cause?

Question 106easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for MySQL instance is running low on disk space. You need to increase the storage without downtime. What is the correct approach?

Question 107hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You are running a Memorystore for Redis instance with persistence disabled. The application requires high availability and data durability after a zone failure. What is the most cost-effective approach?

Question 108mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud Bigtable to store session data. They need to monitor replication lag between clusters in different zones. Which metric should they use?

Question 109mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company has a Cloud SQL for PostgreSQL instance with a read replica in another region. They want to perform disaster recovery testing without affecting the primary. What should they do?

Question 110mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A gaming company uses Cloud Spanner for a global leaderboard. They need to add a column to an existing table and create a secondary index on that column. The database must remain fully available during these changes. Which THREE statements are true?

Question 111hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company runs Memorystore for Redis with a Standard tier instance. They want to scale to higher throughput and memory capacity beyond the current tier limits. Which TWO actions should they take?

Question 112easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A database administrator needs to restore a Cloud SQL for PostgreSQL instance to a specific point in time within the last 3 hours. Which configurations must be enabled to perform a point-in-time recovery (PITR)?

Question 113mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

An organization runs a Cloud SQL for MySQL instance for its e-commerce platform. During a load test, they notice the CPU utilization consistently exceeds 80% and queries are slowing down. The instance is using 2 vCPUs. The team needs to improve performance with minimal downtime. What should they do?

Question 114hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A financial services company uses Cloud Bigtable for real-time fraud detection. They have a cluster with 10 nodes using HDD storage and are experiencing high latency due to disk throughput bottlenecks. They need to improve performance with minimal downtime. What should they do?

Question 115mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A startup uses Memorystore for Redis as a session store. They are concerned about losing session data if the instance fails. Which option provides the best durability for session data without significant application changes?

Question 116mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Spanner instance is backing up a 2 TB database daily to Cloud Storage using the built-in backup feature. The compliance team requires the backup to be stored in a specific regional bucket with a retention policy of 14 days. How should the database administrator configure this?

Question 117hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A gaming company uses Firestore in Native mode to store player profiles and game state. They need to query the data by both 'playerId' and 'lastLoginTimestamp' sorted descending. The current index configuration is automatic. How should they configure indexing to support this query efficiently?

Question 118easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A DevOps engineer needs to monitor Cloud SQL for MySQL replication lag on a read replica to ensure data freshness. Which Cloud Monitoring metric should they create an alert on?

Question 119mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company runs a Cloud SQL for PostgreSQL instance that is nearing its storage limit of 500 GB. The database administrator needs to increase storage capacity online without any downtime. What should they do?

Question 120hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A large enterprise uses Cloud Bigtable for analytics. They notice that some nodes are handling significantly more traffic than others, causing hot spots and performance degradation. Which tool should they use to identify the specific row keys causing the issue?

Question 121easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A developer is setting up a Memorystore for Redis instance and needs to restrict access to only a specific Compute Engine VM in the same VPC network. Which configuration should they use?

Question 122mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company has a Cloud SQL for MySQL instance with a cross-region read replica for disaster recovery. During a regional outage, they need to promote the read replica to a standalone instance as quickly as possible. What is the correct procedure?

Question 123mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud Spanner for a global application. They need to capture real-time changes to certain tables for downstream processing. Which two services or features can be used together to achieve this? (Choose TWO.)

Question 124hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company runs a Memorystore for Redis cluster with standard tier (for replication). They need to ensure high durability of session data and be able to recover from a complete zone failure. Which three actions should they take? (Choose THREE.)

Question 125mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company wants to migrate from an on-premises MySQL database to Cloud SQL. They need to minimize downtime and ensure data consistency. Which two steps should they include in the migration plan? (Choose TWO.)

Question 126mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company runs an e-commerce application on Cloud SQL for MySQL. They need to recover the database to a specific point in time 15 minutes ago after an accidental data deletion. What must be configured beforehand?

Question 127easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for PostgreSQL instance is experiencing a surge in read traffic. The team wants to offload read queries without affecting write latency. What should they do?

Question 128hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud SQL for MySQL instance's storage utilization has reached 95%. The database is 5 TB and needs to grow. The operations team tries to increase storage via gcloud but receives an error. What is the likely cause?

Question 129mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud Spanner for a global inventory application. They need to add a new index to a large table without downtime. What is the recommended approach?

Question 130easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Bigtable instance has a hot spot causing performance degradation. Which tool helps identify the hot spot?

Question 131mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Memorystore for Redis instance is running out of memory. The application uses a mix of cache and session data. Which eviction policy should be chosen to minimize cache misses while ensuring session data is not evicted?

Question 132hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Firestore in Native mode. They have a collection with 1 million documents and frequently run queries that filter on two fields: status and createdAt. The queries are slow. What should the team do?

Question 133mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company wants to monitor Cloud SQL database latency for read replicas and set up an alert if the replica lag exceeds 30 seconds. Which metric should be used?

Question 134mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

An e-commerce platform uses Cloud Bigtable for session data. They need to ensure that if one zone fails, the data is still available with eventual consistency. What should they configure?

Question 135hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A gaming company uses Cloud Spanner to store player profiles and game state. They need to run a one-time analytic query on historical data that would take minutes and cannot impact production performance. What is the best approach?

Question 136easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company runs Cloud SQL for PostgreSQL and wants to automatically increase storage when usage reaches a threshold. What should they enable?

Question 137mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is designing a disaster recovery plan for Cloud SQL for MySQL. They need to ensure the database can be recovered with minimal data loss (RPO of minutes) in case of a regional outage. Which TWO actions should they take?

Question 138mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A financial services company uses Cloud Spanner for transaction processing. They need to capture real-time changes from the database to stream to a downstream analytics system. Which THREE services or features can achieve this?

Question 139mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud SQL for PostgreSQL and needs to enable point-in-time recovery (PITR) with a retention period of 14 days. Currently, automated backups are configured with a 7-day retention. What should the engineer do to meet this requirement?

Question 140hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Spanner database has a table 'Orders' with a column 'status'. The development team needs to add a new column 'priority INT64' to the table without downtime. Which statement should the database administrator execute?

Question 141easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company is using Memorystore for Redis and wants to ensure data persistence in case of a failure. What is the recommended approach?

Question 142mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Bigtable instance is experiencing high latency on reads. The operations team suspects a hot spot. Which tool should they use to identify the hot spot?

Question 143mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

An engineer needs to create a cross-region read replica for a Cloud SQL for MySQL instance to improve read scalability and provide disaster recovery. What must be configured on the primary instance to support cross-region replication?

Question 144hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A team is using Firestore in Native mode. They have a collection 'users' with an array field 'roles'. They need to query all users where roles contains 'admin'. What index configuration is required?

Question 145easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company is using Cloud SQL and wants to automatically increase storage when disk usage reaches a threshold. What should they configure?

Question 146mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Bigtable cluster is currently using HDD storage. The team wants to switch to SSD for better performance. What is the correct approach?

Question 147hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Memorystore for Redis instance is running out of memory. The application can tolerate some data loss but not crashes. The team wants to ensure the instance remains available without manual intervention. Which eviction policy should they configure?

Question 148mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company uses Cloud SQL for PostgreSQL. They need to monitor the replication lag on a read replica. Which metric should they use in Cloud Monitoring?

Question 149easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company is designing a mobile application backend that requires real-time synchronization across users and offline support. Which Google Cloud database service is most suitable?

Question 150mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is using Cloud SQL for MySQL and wants to perform disaster recovery testing by promoting a read replica to a standalone instance. Which TWO actions are required? (Choose 2)

Question 151hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is migrating on-premises PostgreSQL databases to Cloud SQL. They need to minimize downtime and ensure data consistency. Which THREE steps should they follow? (Choose 3)

Question 152mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is using Cloud Bigtable and wants to set up monitoring and alerting for replication lag between clusters. Which TWO metrics should they use? (Choose 2)

Question 153mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company runs an e-commerce platform on Cloud SQL for PostgreSQL. They need to perform point-in-time recovery (PITR) to recover from a user error that occurred 30 minutes ago. Which configuration is required to enable PITR?

Question 154mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Cloud Spanner database is experiencing increased read traffic. You need to add an index to improve query performance without downtime. What is the correct approach?

Question 155easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You are monitoring Cloud Bigtable replication lag. Which metric should you use to determine if replicas are up to date, and what consistency level is typical for Bigtable replication?

Question 156mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A Memorystore for Redis instance is running out of memory. The application uses Redis as a cache with key expiration. You want to prevent data loss for keys that have not reached their TTL. Which eviction policy should you configure?

Question 157hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A company has a Firestore database in Native mode. They need to run a query that filters on two fields (status and date) and orders by date. The query is slow and returns an error that a matching index is missing. What must the engineer do to resolve this?

Question 158easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

Your Cloud SQL for MySQL instance is running low on storage. You need to increase the storage size without downtime. What should you do?

Question 159mediummultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

A team is designing a disaster recovery strategy for Cloud SQL. They need to be able to recover the database in a different region with a Recovery Point Objective (RPO) of less than 30 minutes. What should they configure?

Question 160easymultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

Your Memorystore for Redis instance needs to survive a zonal failure with minimal data loss. Which feature should you use?

Question 161hardmultiple choice

Read the full Manage a solution that can span multiple database technologies explanation →

You are building a global application that requires strong consistency across regions. The application needs to support SQL queries and horizontal scaling. Which database service should you choose?

Question 162mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

Which TWO actions are required to set up point-in-time recovery (PITR) for Cloud SQL for MySQL? (Choose 2)

Question 163mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

Which TWO statements about Cloud Spanner schema changes are correct? (Choose 2)

Question 164hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

Which THREE metrics should you set up alerts for to proactively monitor the health of a Cloud SQL for MySQL instance? (Choose 3)

Question 165mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A Memorystore for Redis instance needs to be scaled to handle increased traffic. Which TWO methods can you use? (Choose 2)

Question 166mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is running a production Cloud SQL for PostgreSQL instance and wants to implement point-in-time recovery (PITR) with a 7-day retention window. They also need to ensure that automated backups are taken daily. Which two configurations must be enabled? (Choose TWO.)

Question 167hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A team manages a Cloud Spanner database and needs to perform a schema change to add a new column to an existing table and create a secondary index. They want to avoid downtime and ensure the changes are applied without blocking reads or writes. Which two statements are correct about making these changes in Spanner? (Choose TWO.)

Question 168mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

An organization is using Memorystore for Redis and needs to ensure that when memory usage reaches the maximum, the cache evicts keys based on the least recently used (LRU) algorithm among keys with an expiry set. They also want to require password authentication for client connections. Which two configurations should be applied? (Choose TWO.)

Question 169hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is using Bigtable for real-time analytics and notices that some queries are experiencing high latency. They suspect a hot spot due to a row key design that uses a monotonically increasing value. Which two actions should they take to diagnose and mitigate the hot spottedness? (Choose TWO.)

Question 170mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A developer is building an application that uses Firestore (in Datastore mode). The application needs to query data across two properties: 'status' and 'timestamp', with an equality filter on 'status' and a range filter on 'timestamp'. Which three steps are required to support this query efficiently? (Choose THREE.)

Question 171easymulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A database administrator wants to set up monitoring and alerting for Cloud SQL instances. They need to be notified when CPU utilisation exceeds 80% for more than 5 minutes and when replication lag on a read replica exceeds 30 seconds. Which two metrics should they create alerting policies for? (Choose TWO.)

Question 172mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is running a Cloud SQL for MySQL instance and needs to create a read replica in a different region for disaster recovery. They also want to be able to promote the replica to a standalone instance if needed. Which three steps should they take? (Choose THREE.)

Question 173easymulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is using Cloud Spanner and wants to back up a database to Cloud Storage for long-term retention. They also need to restore the database to a specific point in time within the last 7 days. Which two features should they use? (Choose TWO.)

Question 174hardmulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A team is managing a Memorystore for Redis instance that needs to scale to handle increased traffic. They want to ensure high availability and the ability to distribute data across multiple nodes. Which three actions should they take? (Choose THREE.)

Question 175mediummulti select

Read the full Manage a solution that can span multiple database technologies explanation →

A company is using Bigtable for a high-throughput write workload. They need to monitor replication lag between clusters in a replicated setup and ensure that reads are eventually consistent. Which two configurations should they check? (Choose TWO.)