PCD Deploy Scalable and Highly Available Databases in Google Cloud — All Questions With Answers

Question 1easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to create a Cloud SQL MySQL instance that can automatically failover to a standby in a different zone within the same region. Which configuration should be used?

Question 2mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company runs a critical PostgreSQL database on Cloud SQL. They want to enforce that all client connections use SSL/TLS encryption. Which step is necessary to ensure this?

Question 3hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company uses Cloud Spanner with an instance configured with 1000 processing units. They notice that high-priority CPU utilization consistently exceeds 65% during peak hours, causing increased latency. They want to auto-scale based on this metric. Which scaling configuration should they use?

Question 4mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is migrating an on-premises Oracle database to Cloud SQL for PostgreSQL. They require a deployment that supports up to 30,000 transactions per second (TPS) and provides automatic storage scaling. Which instance configuration should they choose?

Question 5hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is using Firestore Security Rules for a mobile app. They want to ensure that a user can only read their own documents, where each document has a field 'userId' matching the user's authenticated UID. Which rule is correct?

Question 6easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A development team wants to test their application locally with Cloud Bigtable without incurring costs. Which instance type should they create?

Question 7mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying AlloyDB for PostgreSQL in multiple regions to support disaster recovery. They need the secondary region to be able to serve reads and automatically scale read capacity. Which configuration should they use?

Question 8mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A Cloud Spanner instance has been running with 2 nodes. The team wants to migrate to processing units for more granular scaling. What is the equivalent number of processing units for 2 nodes?

Question 9mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is monitoring Cloud Bigtable performance and notices high read latency. They suspect a hot spot issue. Which tool should they use to identify the hot spot?

Question 10hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company wants to connect to Cloud SQL from a Compute Engine VM without exposing the database to the public internet. They also need to avoid IP allowlisting. Which connection method should they use?

Question 11easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs a fully managed, globally distributed relational database that supports ACID transactions across regions. Which Google Cloud service should they choose?

Question 12mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to create a cross-region read replica for a Cloud SQL for MySQL instance for disaster recovery. Which step is required?

Question 13mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying a production Cloud Bigtable instance for time-series data. They want high availability across zones and the ability to serve reads from a secondary location. Which TWO configurations should they implement?

Question 14mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is designing a Cloud Spanner instance for a global e-commerce application. They need strong consistency across continents and the ability to automatically scale compute capacity. Which THREE configurations should they choose?

Question 15hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company uses Firestore for a mobile app. They want to implement security rules that allow users to create documents only if they are authenticated and the document's 'owner' field matches their UID. Additionally, they want to allow reads of any document where the 'visibility' field is 'public'. Which TWO conditions should the rules include?

Question 16mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is migrating a PostgreSQL application to Cloud SQL. They require automatic failover in under 60 seconds if the primary instance fails, and they want to minimize write latency. Which configuration should they choose?

Question 17mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A financial services company needs a globally distributed, strongly consistent database that can handle OLTP workloads with high throughput and automatic scaling. Which Google Cloud database should they use?

Question 18hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineering team is designing an AlloyDB cluster for an e-commerce platform. They anticipate variable read traffic and want to automatically add or remove read-only compute capacity based on CPU utilization. Which feature should they enable?

Question 19easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A developer needs to connect a Cloud SQL MySQL instance from an application running on Compute Engine without whitelisting IP addresses. Which method should they use?

Question 20mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company uses Cloud Bigtable for time-series data. They notice uneven load distribution across nodes causing hot spots. Which tool should they use to identify the hot spots?

Question 21mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs to run AlloyDB on-premises to maintain data sovereignty while leveraging the same management APIs as in Google Cloud. Which AlloyDB offering should they use?

Question 22hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A Cloud Spanner instance is configured with 1000 processing units. The workload has unpredictable traffic spikes. To ensure consistent performance, the team wants to automatically adjust capacity based on a high-priority CPU target of 60%. What should they configure?

Question 23easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A startup wants to use Firestore for a mobile app. They need to restrict access so that users can only read and write their own data. Which Firestore security rule feature should they use?

Question 24mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud SQL for PostgreSQL and wants to ensure that all connections to the database use SSL/TLS. They have set the `require_ssl` flag but still see some connections using non-SSL. What is the most likely reason?

Question 25hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A manufacturing company collects sensor data from thousands of devices. They need a database that can handle a write throughput of 100,000 rows per second and read latency under 10ms. Data is keyed by device ID and timestamp. Which Google Cloud database should they choose?

Question 26mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs a database for an e-commerce application that requires strong consistency and the ability to scale horizontally across multiple regions. They expect high write throughput and need to support SQL queries. Which database should they choose?

Question 27easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to create a Cloud SQL instance for a development environment with minimal cost. The instance will have low traffic, and storage growth is expected to be gradual. Which storage configuration should they choose?

Question 28mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company has a Cloud SQL for MySQL instance in the us-central1 region. They want to improve read performance for a report generation tool that runs in us-west1, and also provide disaster recovery in case the primary fails. Which TWO actions should they take?

Question 29hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying a Cloud Spanner database for a global application. They need to minimize write latency for users in North America and Europe while ensuring strong consistency. They also want to control costs by only paying for the capacity they use. Which THREE features should they use?

Question 30mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud Bigtable for real-time analytics. They want to ensure high availability and the ability to perform maintenance without downtime. They also want to reduce read latency for users in Asia. Which TWO actions should they take?

Question 31easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An organization runs a MySQL database on Cloud SQL. They want to ensure that all connections to the database are encrypted. Which action should they take?

Question 32mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A financial services company needs a globally distributed relational database with strong ACID transactions and high availability across regions. They anticipate unpredictable traffic spikes and need to pay only for the resources they use. Which Google Cloud database and scaling approach is most suitable?

Question 33hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud Bigtable to serve real-time analytics. They notice that some queries are slow, and the Key Visualizer shows a narrow row key range receiving the majority of reads and writes. What is the most likely cause and recommended action?

Question 34easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A developer needs to connect a Cloud Run service to a Cloud SQL instance securely without managing SSL certificates or configuring IP allowlists. Which connection method should they use?

Question 35mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company wants to deploy a database for a global application that requires strong consistency across continents, with the ability to handle millions of reads and writes per second. Which Google Cloud database should they choose?

Question 36hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

You are configuring a Cloud SQL for PostgreSQL instance for high availability. The instance must have automatic failover in under 60 seconds and avoid any data loss. Which configuration meets these requirements?

Question 37mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A startup is building a mobile app with Firestore. They need to ensure that only authenticated users can read and write their own data. Which Firestore security rule pattern should they use?

Question 38easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company wants to deploy a non-relational database for a real-time bidding application that requires low latency (under 10ms) and high throughput (millions of requests per second). The data model is key-value with a timestamp component. Which Google Cloud database is most appropriate?

Question 39mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

You are migrating a PostgreSQL database to Cloud SQL. The database currently uses custom functions and PostGIS extensions. The target must support these extensions. Which database version and tier should you choose?

Question 40mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company runs a Cloud Spanner instance with 2000 processing units. They notice that the high-priority CPU utilization is consistently above 80% during peak hours. Which action should they take to improve performance?

Question 41hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud Bigtable for a time-series application. They need to ensure that if one zone fails, the database remains available for reads and writes with minimal downtime. Which configuration should they use?

Question 42mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs to secure their Cloud SQL for MySQL instance. They want to ensure that only applications running within their VPC can connect, and that all connections are encrypted. Which two steps should they take? (Choose two.)

Question 43mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company uses AlloyDB for PostgreSQL and needs to scale read traffic automatically. They also want to ensure the database remains available if the primary zone fails. Which two features should they use? (Choose two.)

Question 44hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An organization uses Cloud Spanner in a multi-region configuration. They want to monitor performance and identify potential bottlenecks. Which three metrics should they review? (Choose three.)

Question 45mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying a new financial application on Google Cloud that requires strong consistency, global scale, and the ability to handle millions of transactions per second across multiple regions. The application data has a relational structure. Which database service should they choose?

Question 46easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to create a Cloud SQL for PostgreSQL instance with high availability. Which configuration ensures automatic failover in less than 60 seconds if the primary zone fails?

Question 47mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud SQL for MySQL and wants to offload read traffic to a replica for better performance. They also need the replica to be available for disaster recovery in a different region. What should they do?

Question 48hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to deploy Cloud Spanner with the ability to scale compute capacity automatically between 1000 and 6000 processing units based on load, with a target high-priority CPU utilization of 65%. Which configuration achieves this?

Question 49easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A developer wants to connect to a Cloud SQL instance from a Compute Engine VM without whitelisting IP addresses and with automatic encryption. What should they use?

Question 50mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company wants to deploy a Bigtable instance for a production workload that requires high availability across zones. They also need to ensure consistent single-digit millisecond latency for reads. Which configuration should they choose?

Question 51mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer notices high CPU utilization on a Cloud Spanner instance and wants to identify the queries consuming the most resources. Which tool should they use?

Question 52easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

Which Cloud SQL setting ensures that all client connections to the database use SSL?

Question 53mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is migrating an on-premises PostgreSQL database to Cloud SQL. They need to ensure minimal downtime and continuous replication during the migration. Which approach should they use?

Question 54hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to configure Firestore security rules for a mobile app where users can only read and write their own data. The user's UID is stored in the document field 'owner'. Which rule correctly restricts access?

Question 55mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is evaluating Cloud Bigtable for a high-throughput write workload. They need to monitor disk usage and request latency. Which metrics should they monitor? (Select the best combination.)

Question 56hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is deploying AlloyDB for PostgreSQL and needs to support read scaling with automatic scaling of read replicas based on load. They also want to ensure minimal operational overhead. What should they use?

Question 57mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is designing a disaster recovery strategy for a Cloud SQL for SQL Server instance. They need to be able to fail over to a different region with minimal data loss. Which TWO actions should they take? (Choose two.)

Question 58easymulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs to store and analyze large amounts of log data with flexible schema and support for real-time analytics. They want to use a fully managed, serverless solution. Which THREE Google Cloud services could meet their needs? (Choose three.)

Question 59hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to secure a Cloud SQL for MySQL instance that contains sensitive data. They want to ensure that only specific Compute Engine VMs in the same VPC can connect, and that all connections are encrypted. Which THREE steps should they take? (Choose three.)

Question 60easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying a new web application on Google Cloud and needs a managed relational database with PostgreSQL compatibility. The database must support automatic failover within 60 seconds in case of a zone outage. Which database deployment option should they choose?

Question 61mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An organization has a Cloud SQL for MySQL instance with 500 GB of data. They want to offload reporting queries that scan large portions of the database without impacting the primary instance's performance. Which solution should they implement?

Question 62hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company's Cloud Bigtable instance is experiencing high latency and increased error rates for write requests. The Key Visualiser shows that a single row key prefix receives the majority of writes, creating a hotspot. What is the BEST long-term solution to distribute writes more evenly?

Question 63mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A development team wants to connect their Cloud SQL for PostgreSQL instance from a Compute Engine VM without exposing it to the public internet. They also want to avoid managing IP allowlists. Which method should they use?

Question 64easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A startup is building a mobile application with real-time synchronization across user devices. They expect millions of users and need a NoSQL database with offline support and real-time listeners. Which database should they choose?

Question 65mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An e-commerce platform uses Cloud Spanner for its inventory system. They notice that the processing units utilization is consistently above 90% during peak hours, causing increased read latency. They want to automatically scale capacity based on load. What should they configure?

Question 66hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A financial services company requires a globally distributed database with strong consistency and sub-10 millisecond write latency across three continents. They anticipate 50 TB of transactional data. Which Google Cloud database should they deploy?

Question 67easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A team is deploying a Cloud SQL for PostgreSQL instance and needs to enforce that all connections use SSL/TLS. Which flag must they enable on the Cloud SQL instance?

Question 68mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A manufacturing company collects time-series data from thousands of sensors and wants to store it in Cloud Bigtable. They need to design a row key that avoids hotspots and ensures even distribution of writes across tablets. Which row key design strategy is BEST?

Question 69hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company has an AlloyDB cluster in us-central1. They want to replicate data to a secondary region for disaster recovery with a recovery point objective (RPO) of less than 1 second. Which AlloyDB feature should they use?

Question 70mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company's Firestore security rules are too permissive, allowing all users to read and write any document. They need to restrict access so that only authenticated users can read and write their own data. Which rule structure should they use?

Question 71mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs to monitor the disk usage of their Cloud SQL instance to proactively increase storage before it runs out. They want to set an alert when disk usage exceeds 80%. Which metric should they use in Cloud Monitoring?

Question 72mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying a Cloud Spanner instance for a global application. They need to minimize write latency for users in Asia, Europe, and North America while maintaining strong consistency. Which two configurations should they choose? (Choose two.)

Question 73hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is migrating an on-premises PostgreSQL database to Cloud SQL. They need to ensure high availability and minimize downtime during maintenance. They also want to enable IAM database authentication for enhanced security. Which three actions should they take? (Choose three.)

Question 74mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud Bigtable for a high-throughput write workload. They notice periodic latency spikes. Which two metrics should they monitor to diagnose the issue? (Choose two.)

Question 75mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company uses Cloud SQL for MySQL with a single zone. They need high availability with automatic failover in under 60 seconds. What configuration should they use?

Question 76easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A developer needs to connect to a Cloud SQL for PostgreSQL instance from a Compute Engine VM without adding the VM's IP to an authorized networks list. Which method should they use?

Question 77mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An organization needs a globally distributed relational database with strong consistency across regions and the ability to scale horizontally without manual sharding. Which Google Cloud database should they choose?

Question 78hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A Cloud Bigtable instance has a single cluster. To improve availability and read throughput, the team decides to add a second cluster in a different zone. What is the effect on write performance?

Question 79mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company wants to use Firestore security rules to allow users to read documents only if they are the owner (user ID matches the 'owner' field in the document). Which rule is correct?

Question 80easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is deploying a Cloud SQL for SQL Server instance and wants to automatically increase storage when the disk usage reaches a threshold. Which flag should they set?

Question 81hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A Cloud Spanner instance is experiencing high read latency. The instance has a single regional configuration. Monitoring shows high-priority CPU utilization is above 90%. What should the engineer do to reduce latency?

Question 82mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs to run AlloyDB for PostgreSQL with a read pool that can automatically scale based on load. They also need to run a local instance on-premises for disaster recovery. Which features should they use?

Question 83easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

To monitor Cloud SQL query performance, which metric should an engineer examine to see the rate of queries being executed?

Question 84hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Bigtable for real-time analytics and notices that certain row keys are causing hot spots. Which tool should they use to identify the hot spot patterns?

Question 85mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A developer wants to enable IAM database authentication for Cloud SQL for PostgreSQL. Which IAM role must be granted to a user or service account to allow login?

Question 86easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to create a Cloud SQL instance with SSD storage. Which storage type should they select for best performance?

Question 87mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying a three-node Bigtable cluster for production. They anticipate growth in read throughput and want to plan for scaling. Which two actions can they take to increase read throughput? (Choose TWO.)

Question 88hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company has a Cloud Spanner instance with 1000 processing units and wants to enable auto-scaling. Which three parameters must be configured? (Choose THREE.)

Question 89mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An organization needs to secure Cloud SQL for MySQL instances. Which two measures should they implement to restrict network access? (Choose TWO.)

Question 90mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is migrating an on-premises PostgreSQL database to Cloud SQL for PostgreSQL. They require automatic failover within 60 seconds in case of a zonal failure. The database must be available in the same region for low latency. Which configuration should they choose?

Question 91hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is deploying a Cloud Spanner instance for a global application that requires strong consistency across continents. The workload is moderate, and they want to minimize costs while meeting latency requirements. Which instance configuration should they choose?

Question 92easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A developer needs to connect a Cloud Run application to a Cloud SQL for MySQL database securely without managing IP allowlists or SSL certificates. Which method should they use?

Question 93mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying Cloud Bigtable for a high-throughput write-heavy workload. They need high availability and read scalability across two GCP regions. Which TWO actions should they take? (Choose 2.)

Question 94hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is designing a disaster recovery plan for a production AlloyDB cluster. The primary cluster is in us-central1. They need a cross-region replica that can be promoted to primary in the event of a regional failure. The replica should also be able to handle read traffic in the secondary region. Which THREE steps should they take? (Choose 3.)

Question 95easymulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud SQL for PostgreSQL and wants to offload read traffic and improve performance. They also want a disaster recovery option in a different region. Which TWO configurations should they implement? (Choose 2.)

Question 96mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An organization needs to secure their Cloud SQL for MySQL instance. They require that all connections use IAM for authentication and that the database is not accessible from the public internet. Which THREE actions should they take? (Choose 3.)

Question 97hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is running a Cloud Spanner instance with 1000 processing units. They notice high-priority CPU utilization exceeding 90% during peak hours, causing increased latency. They want to automatically scale capacity to handle the load while staying cost-effective. Which TWO actions should they take? (Choose 2.)

Question 98mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A team is using Firestore for a mobile application. They need to write security rules that allow users to read and write only their own documents. The documents have a field 'ownerId' that matches the user's UID. Which THREE rule components should they use? (Choose 3.)

Question 99easymulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud Bigtable for a time-series workload. They want to monitor performance and identify hot spots. Which TWO Google Cloud tools or features should they use? (Choose 2.)

Question 1easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to create a Cloud SQL MySQL instance that can automatically failover to a standby in a different zone within the same region. Which configuration should be used?

Question 2mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company runs a critical PostgreSQL database on Cloud SQL. They want to enforce that all client connections use SSL/TLS encryption. Which step is necessary to ensure this?

Question 3hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company uses Cloud Spanner with an instance configured with 1000 processing units. They notice that high-priority CPU utilization consistently exceeds 65% during peak hours, causing increased latency. They want to auto-scale based on this metric. Which scaling configuration should they use?

Question 4mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is migrating an on-premises Oracle database to Cloud SQL for PostgreSQL. They require a deployment that supports up to 30,000 transactions per second (TPS) and provides automatic storage scaling. Which instance configuration should they choose?

Question 5hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is using Firestore Security Rules for a mobile app. They want to ensure that a user can only read their own documents, where each document has a field 'userId' matching the user's authenticated UID. Which rule is correct?

Question 6easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A development team wants to test their application locally with Cloud Bigtable without incurring costs. Which instance type should they create?

Question 7mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying AlloyDB for PostgreSQL in multiple regions to support disaster recovery. They need the secondary region to be able to serve reads and automatically scale read capacity. Which configuration should they use?

Question 8mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A Cloud Spanner instance has been running with 2 nodes. The team wants to migrate to processing units for more granular scaling. What is the equivalent number of processing units for 2 nodes?

Question 9mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is monitoring Cloud Bigtable performance and notices high read latency. They suspect a hot spot issue. Which tool should they use to identify the hot spot?

Question 10hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company wants to connect to Cloud SQL from a Compute Engine VM without exposing the database to the public internet. They also need to avoid IP allowlisting. Which connection method should they use?

Question 11easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs a fully managed, globally distributed relational database that supports ACID transactions across regions. Which Google Cloud service should they choose?

Question 12mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to create a cross-region read replica for a Cloud SQL for MySQL instance for disaster recovery. Which step is required?

Question 13mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying a production Cloud Bigtable instance for time-series data. They want high availability across zones and the ability to serve reads from a secondary location. Which TWO configurations should they implement?

Question 14mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is designing a Cloud Spanner instance for a global e-commerce application. They need strong consistency across continents and the ability to automatically scale compute capacity. Which THREE configurations should they choose?

Question 15hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company uses Firestore for a mobile app. They want to implement security rules that allow users to create documents only if they are authenticated and the document's 'owner' field matches their UID. Additionally, they want to allow reads of any document where the 'visibility' field is 'public'. Which TWO conditions should the rules include?

Question 16mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is migrating a PostgreSQL application to Cloud SQL. They require automatic failover in under 60 seconds if the primary instance fails, and they want to minimize write latency. Which configuration should they choose?

Question 17mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A financial services company needs a globally distributed, strongly consistent database that can handle OLTP workloads with high throughput and automatic scaling. Which Google Cloud database should they use?

Question 18hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineering team is designing an AlloyDB cluster for an e-commerce platform. They anticipate variable read traffic and want to automatically add or remove read-only compute capacity based on CPU utilization. Which feature should they enable?

Question 19easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A developer needs to connect a Cloud SQL MySQL instance from an application running on Compute Engine without whitelisting IP addresses. Which method should they use?

Question 20mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company uses Cloud Bigtable for time-series data. They notice uneven load distribution across nodes causing hot spots. Which tool should they use to identify the hot spots?

Question 21mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs to run AlloyDB on-premises to maintain data sovereignty while leveraging the same management APIs as in Google Cloud. Which AlloyDB offering should they use?

Question 22hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A Cloud Spanner instance is configured with 1000 processing units. The workload has unpredictable traffic spikes. To ensure consistent performance, the team wants to automatically adjust capacity based on a high-priority CPU target of 60%. What should they configure?

Question 23easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A startup wants to use Firestore for a mobile app. They need to restrict access so that users can only read and write their own data. Which Firestore security rule feature should they use?

Question 24mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud SQL for PostgreSQL and wants to ensure that all connections to the database use SSL/TLS. They have set the `require_ssl` flag but still see some connections using non-SSL. What is the most likely reason?

Question 25hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A manufacturing company collects sensor data from thousands of devices. They need a database that can handle a write throughput of 100,000 rows per second and read latency under 10ms. Data is keyed by device ID and timestamp. Which Google Cloud database should they choose?

Question 26mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs a database for an e-commerce application that requires strong consistency and the ability to scale horizontally across multiple regions. They expect high write throughput and need to support SQL queries. Which database should they choose?

Question 27easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to create a Cloud SQL instance for a development environment with minimal cost. The instance will have low traffic, and storage growth is expected to be gradual. Which storage configuration should they choose?

Question 28mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company has a Cloud SQL for MySQL instance in the us-central1 region. They want to improve read performance for a report generation tool that runs in us-west1, and also provide disaster recovery in case the primary fails. Which TWO actions should they take?

Question 29hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying a Cloud Spanner database for a global application. They need to minimize write latency for users in North America and Europe while ensuring strong consistency. They also want to control costs by only paying for the capacity they use. Which THREE features should they use?

Question 30mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud Bigtable for real-time analytics. They want to ensure high availability and the ability to perform maintenance without downtime. They also want to reduce read latency for users in Asia. Which TWO actions should they take?

Question 31easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An organization runs a MySQL database on Cloud SQL. They want to ensure that all connections to the database are encrypted. Which action should they take?

Question 32mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A financial services company needs a globally distributed relational database with strong ACID transactions and high availability across regions. They anticipate unpredictable traffic spikes and need to pay only for the resources they use. Which Google Cloud database and scaling approach is most suitable?

Question 33hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud Bigtable to serve real-time analytics. They notice that some queries are slow, and the Key Visualizer shows a narrow row key range receiving the majority of reads and writes. What is the most likely cause and recommended action?

Question 34easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A developer needs to connect a Cloud Run service to a Cloud SQL instance securely without managing SSL certificates or configuring IP allowlists. Which connection method should they use?

Question 35mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company wants to deploy a database for a global application that requires strong consistency across continents, with the ability to handle millions of reads and writes per second. Which Google Cloud database should they choose?

Question 36hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

You are configuring a Cloud SQL for PostgreSQL instance for high availability. The instance must have automatic failover in under 60 seconds and avoid any data loss. Which configuration meets these requirements?

Question 37mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A startup is building a mobile app with Firestore. They need to ensure that only authenticated users can read and write their own data. Which Firestore security rule pattern should they use?

Question 38easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company wants to deploy a non-relational database for a real-time bidding application that requires low latency (under 10ms) and high throughput (millions of requests per second). The data model is key-value with a timestamp component. Which Google Cloud database is most appropriate?

Question 39mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

You are migrating a PostgreSQL database to Cloud SQL. The database currently uses custom functions and PostGIS extensions. The target must support these extensions. Which database version and tier should you choose?

Question 40mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company runs a Cloud Spanner instance with 2000 processing units. They notice that the high-priority CPU utilization is consistently above 80% during peak hours. Which action should they take to improve performance?

Question 41hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud Bigtable for a time-series application. They need to ensure that if one zone fails, the database remains available for reads and writes with minimal downtime. Which configuration should they use?

Question 42mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs to secure their Cloud SQL for MySQL instance. They want to ensure that only applications running within their VPC can connect, and that all connections are encrypted. Which two steps should they take? (Choose two.)

Question 43mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company uses AlloyDB for PostgreSQL and needs to scale read traffic automatically. They also want to ensure the database remains available if the primary zone fails. Which two features should they use? (Choose two.)

Question 44hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An organization uses Cloud Spanner in a multi-region configuration. They want to monitor performance and identify potential bottlenecks. Which three metrics should they review? (Choose three.)

Question 45mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying a new financial application on Google Cloud that requires strong consistency, global scale, and the ability to handle millions of transactions per second across multiple regions. The application data has a relational structure. Which database service should they choose?

Question 46easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to create a Cloud SQL for PostgreSQL instance with high availability. Which configuration ensures automatic failover in less than 60 seconds if the primary zone fails?

Question 47mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud SQL for MySQL and wants to offload read traffic to a replica for better performance. They also need the replica to be available for disaster recovery in a different region. What should they do?

Question 48hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to deploy Cloud Spanner with the ability to scale compute capacity automatically between 1000 and 6000 processing units based on load, with a target high-priority CPU utilization of 65%. Which configuration achieves this?

Question 49easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A developer wants to connect to a Cloud SQL instance from a Compute Engine VM without whitelisting IP addresses and with automatic encryption. What should they use?

Question 50mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company wants to deploy a Bigtable instance for a production workload that requires high availability across zones. They also need to ensure consistent single-digit millisecond latency for reads. Which configuration should they choose?

Question 51mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer notices high CPU utilization on a Cloud Spanner instance and wants to identify the queries consuming the most resources. Which tool should they use?

Question 52easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

Which Cloud SQL setting ensures that all client connections to the database use SSL?

Question 53mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is migrating an on-premises PostgreSQL database to Cloud SQL. They need to ensure minimal downtime and continuous replication during the migration. Which approach should they use?

Question 54hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to configure Firestore security rules for a mobile app where users can only read and write their own data. The user's UID is stored in the document field 'owner'. Which rule correctly restricts access?

Question 55mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is evaluating Cloud Bigtable for a high-throughput write workload. They need to monitor disk usage and request latency. Which metrics should they monitor? (Select the best combination.)

Question 56hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is deploying AlloyDB for PostgreSQL and needs to support read scaling with automatic scaling of read replicas based on load. They also want to ensure minimal operational overhead. What should they use?

Question 57mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is designing a disaster recovery strategy for a Cloud SQL for SQL Server instance. They need to be able to fail over to a different region with minimal data loss. Which TWO actions should they take? (Choose two.)

Question 58easymulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs to store and analyze large amounts of log data with flexible schema and support for real-time analytics. They want to use a fully managed, serverless solution. Which THREE Google Cloud services could meet their needs? (Choose three.)

Question 59hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to secure a Cloud SQL for MySQL instance that contains sensitive data. They want to ensure that only specific Compute Engine VMs in the same VPC can connect, and that all connections are encrypted. Which THREE steps should they take? (Choose three.)

Question 60easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying a new web application on Google Cloud and needs a managed relational database with PostgreSQL compatibility. The database must support automatic failover within 60 seconds in case of a zone outage. Which database deployment option should they choose?

Question 61mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An organization has a Cloud SQL for MySQL instance with 500 GB of data. They want to offload reporting queries that scan large portions of the database without impacting the primary instance's performance. Which solution should they implement?

Question 62hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company's Cloud Bigtable instance is experiencing high latency and increased error rates for write requests. The Key Visualiser shows that a single row key prefix receives the majority of writes, creating a hotspot. What is the BEST long-term solution to distribute writes more evenly?

Question 63mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A development team wants to connect their Cloud SQL for PostgreSQL instance from a Compute Engine VM without exposing it to the public internet. They also want to avoid managing IP allowlists. Which method should they use?

Question 64easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A startup is building a mobile application with real-time synchronization across user devices. They expect millions of users and need a NoSQL database with offline support and real-time listeners. Which database should they choose?

Question 65mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An e-commerce platform uses Cloud Spanner for its inventory system. They notice that the processing units utilization is consistently above 90% during peak hours, causing increased read latency. They want to automatically scale capacity based on load. What should they configure?

Question 66hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A financial services company requires a globally distributed database with strong consistency and sub-10 millisecond write latency across three continents. They anticipate 50 TB of transactional data. Which Google Cloud database should they deploy?

Question 67easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A team is deploying a Cloud SQL for PostgreSQL instance and needs to enforce that all connections use SSL/TLS. Which flag must they enable on the Cloud SQL instance?

Question 68mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A manufacturing company collects time-series data from thousands of sensors and wants to store it in Cloud Bigtable. They need to design a row key that avoids hotspots and ensures even distribution of writes across tablets. Which row key design strategy is BEST?

Question 69hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company has an AlloyDB cluster in us-central1. They want to replicate data to a secondary region for disaster recovery with a recovery point objective (RPO) of less than 1 second. Which AlloyDB feature should they use?

Question 70mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company's Firestore security rules are too permissive, allowing all users to read and write any document. They need to restrict access so that only authenticated users can read and write their own data. Which rule structure should they use?

Question 71mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs to monitor the disk usage of their Cloud SQL instance to proactively increase storage before it runs out. They want to set an alert when disk usage exceeds 80%. Which metric should they use in Cloud Monitoring?

Question 72mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying a Cloud Spanner instance for a global application. They need to minimize write latency for users in Asia, Europe, and North America while maintaining strong consistency. Which two configurations should they choose? (Choose two.)

Question 73hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is migrating an on-premises PostgreSQL database to Cloud SQL. They need to ensure high availability and minimize downtime during maintenance. They also want to enable IAM database authentication for enhanced security. Which three actions should they take? (Choose three.)

Question 74mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud Bigtable for a high-throughput write workload. They notice periodic latency spikes. Which two metrics should they monitor to diagnose the issue? (Choose two.)

Question 75mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company uses Cloud SQL for MySQL with a single zone. They need high availability with automatic failover in under 60 seconds. What configuration should they use?

Question 76easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A developer needs to connect to a Cloud SQL for PostgreSQL instance from a Compute Engine VM without adding the VM's IP to an authorized networks list. Which method should they use?

Question 77mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An organization needs a globally distributed relational database with strong consistency across regions and the ability to scale horizontally without manual sharding. Which Google Cloud database should they choose?

Question 78hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A Cloud Bigtable instance has a single cluster. To improve availability and read throughput, the team decides to add a second cluster in a different zone. What is the effect on write performance?

Question 79mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company wants to use Firestore security rules to allow users to read documents only if they are the owner (user ID matches the 'owner' field in the document). Which rule is correct?

Question 80easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is deploying a Cloud SQL for SQL Server instance and wants to automatically increase storage when the disk usage reaches a threshold. Which flag should they set?

Question 81hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A Cloud Spanner instance is experiencing high read latency. The instance has a single regional configuration. Monitoring shows high-priority CPU utilization is above 90%. What should the engineer do to reduce latency?

Question 82mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company needs to run AlloyDB for PostgreSQL with a read pool that can automatically scale based on load. They also need to run a local instance on-premises for disaster recovery. Which features should they use?

Question 83easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

To monitor Cloud SQL query performance, which metric should an engineer examine to see the rate of queries being executed?

Question 84hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Bigtable for real-time analytics and notices that certain row keys are causing hot spots. Which tool should they use to identify the hot spot patterns?

Question 85mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A developer wants to enable IAM database authentication for Cloud SQL for PostgreSQL. Which IAM role must be granted to a user or service account to allow login?

Question 86easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer needs to create a Cloud SQL instance with SSD storage. Which storage type should they select for best performance?

Question 87mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying a three-node Bigtable cluster for production. They anticipate growth in read throughput and want to plan for scaling. Which two actions can they take to increase read throughput? (Choose TWO.)

Question 88hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company has a Cloud Spanner instance with 1000 processing units and wants to enable auto-scaling. Which three parameters must be configured? (Choose THREE.)

Question 89mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An organization needs to secure Cloud SQL for MySQL instances. Which two measures should they implement to restrict network access? (Choose TWO.)

Question 90mediummultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is migrating an on-premises PostgreSQL database to Cloud SQL for PostgreSQL. They require automatic failover within 60 seconds in case of a zonal failure. The database must be available in the same region for low latency. Which configuration should they choose?

Question 91hardmultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is deploying a Cloud Spanner instance for a global application that requires strong consistency across continents. The workload is moderate, and they want to minimize costs while meeting latency requirements. Which instance configuration should they choose?

Question 92easymultiple choice

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A developer needs to connect a Cloud Run application to a Cloud SQL for MySQL database securely without managing IP allowlists or SSL certificates. Which method should they use?

Question 93mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is deploying Cloud Bigtable for a high-throughput write-heavy workload. They need high availability and read scalability across two GCP regions. Which TWO actions should they take? (Choose 2.)

Question 94hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An engineer is designing a disaster recovery plan for a production AlloyDB cluster. The primary cluster is in us-central1. They need a cross-region replica that can be promoted to primary in the event of a regional failure. The replica should also be able to handle read traffic in the secondary region. Which THREE steps should they take? (Choose 3.)

Question 95easymulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud SQL for PostgreSQL and wants to offload read traffic and improve performance. They also want a disaster recovery option in a different region. Which TWO configurations should they implement? (Choose 2.)

Question 96mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

An organization needs to secure their Cloud SQL for MySQL instance. They require that all connections use IAM for authentication and that the database is not accessible from the public internet. Which THREE actions should they take? (Choose 3.)

Question 97hardmulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is running a Cloud Spanner instance with 1000 processing units. They notice high-priority CPU utilization exceeding 90% during peak hours, causing increased latency. They want to automatically scale capacity to handle the load while staying cost-effective. Which TWO actions should they take? (Choose 2.)

Question 98mediummulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A team is using Firestore for a mobile application. They need to write security rules that allow users to read and write only their own documents. The documents have a field 'ownerId' that matches the user's UID. Which THREE rule components should they use? (Choose 3.)

Question 99easymulti select

Read the full Deploy Scalable and Highly Available Databases in Cloud explanation →

A company is using Cloud Bigtable for a time-series workload. They want to monitor performance and identify hot spots. Which TWO Google Cloud tools or features should they use? (Choose 2.)