Deploy Scalable and Highly Available Databases in Google Cloud

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?

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?

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?

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?

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?

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

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?

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?

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?

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?

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

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

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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.)

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.)

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.)

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?

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?

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?

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?

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?

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?

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?

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

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?

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?

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.)

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?

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.)

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.)

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.)

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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.)

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.)

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.)

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?

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?

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?

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?

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?

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?

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?

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?

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

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?

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?

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

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.)

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.)

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

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?

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?

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?

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.)

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.)

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.)

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.)

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.)

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.)

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.)