Cloud Database Engineer Practice Exam 2025: Latest Questions

A startup is building a global user profile service that requires horizontally scalable reads/writes, automatic sharding, and strong consistency for single-row updates. They want minimal operational overhead. Which database should they choose?

You manage a Cloud SQL for MySQL instance used by a critical application. The company requires automatic failover with minimal downtime within a region. What configuration should you implement?

A team wants to migrate an on-premises PostgreSQL database to Cloud SQL for PostgreSQL with minimal downtime. They can accept a brief cutover window but need continuous replication during the migration. Which approach should you recommend?

You need to ensure all connections from GKE workloads to a Cloud SQL instance are encrypted in transit and authenticated using IAM without distributing long-lived database passwords. What should you use?

An application on Cloud SQL for PostgreSQL experiences intermittent slow queries. You need to identify the expensive queries and their execution characteristics with minimal overhead and without changing application code. What should you do?

A finance company needs a database for time-series events with very high write throughput and low-latency key-based lookups. They do not require SQL joins but need predictable performance at scale. Which Google Cloud database is the best fit?

You are designing a disaster recovery strategy for Cloud Spanner. The requirement is to recover from regional failure with the lowest RPO and RTO while keeping the system serving traffic during the failure. What should you implement?

You need to provision Cloud SQL instances for multiple environments (dev/test/prod) using consistent configuration and controlled change management. Security requires that only approved settings can be used. What is the best approach?

A company is migrating an on-premises Oracle database to Google Cloud and wants near-zero downtime. They also want to modernize to a PostgreSQL-compatible engine to reduce licensing complexity. The migration includes schema conversion and continuous replication until cutover. What should you recommend?

A Cloud SQL for PostgreSQL instance shows increasing storage usage and worsening query performance over weeks. Monitoring shows a growing number of dead tuples and frequent sequential scans on large tables. What is the most likely root cause and best corrective action?

Your team needs a PostgreSQL database on Google Cloud for a new internal application. The database must be created with minimal operational overhead, support automated backups, and allow you to quickly add a read replica later. Which solution should you choose?

A product team wants to enforce that database user passwords are not embedded in application code. The application runs on Cloud Run and connects to Cloud SQL. What is the recommended approach?

You need to migrate a 3 TB MySQL database from an on-premises data center to Cloud SQL for MySQL with minimal downtime. The on-premises server has binary logging enabled. Which migration approach is most appropriate?

A global application requires strongly consistent reads and writes across multiple regions, and it must remain available if an entire region fails. The workload is relational with high write throughput. Which database design is the best fit?

After migrating to Cloud SQL for PostgreSQL, you see periodic spikes in query latency. Cloud Monitoring shows high CPU utilization, and Cloud SQL Insights indicates many similar queries performing sequential scans. What is the most effective next step?

You operate a Cloud SQL instance with private IP. A new GKE cluster in the same project cannot connect to the database. The Cloud SQL instance uses a VPC network named "prod-vpc". The GKE cluster is attached to "default" VPC. What should you do to enable connectivity following best practices?

You need to move data from an on-premises Oracle database to Cloud SQL for PostgreSQL. The application will be refactored, but you want to assess schema conversion complexity and automatically generate as much of the PostgreSQL schema as possible. What should you use?

Your Cloud Spanner database has a hotspot on a single table that uses a monotonically increasing primary key. You observe uneven load and increased write latency. What is the best remediation?

A security review requires that Cloud SQL data be protected with customer-managed encryption keys (CMEK) and that key access is auditable and revocable. The database is already in production. What is the recommended approach to meet this requirement?

You are migrating a multi-terabyte PostgreSQL database to AlloyDB for PostgreSQL with very low downtime. Network bandwidth from on-premises is limited, and you must minimize the time spent in the final cutover. Which approach best meets the requirement?

You are designing a globally distributed application that needs a relational database with strong consistency and automatic failover across regions. The database must support PostgreSQL semantics and minimize operational overhead. Which Google Cloud database solution best fits these requirements?

A Cloud SQL for PostgreSQL instance is running out of storage during peak ingestion windows. The team wants to avoid failed writes and minimize on-call toil. What should you do?

You are migrating from an on-premises MySQL database to Cloud SQL for MySQL. The application must continue to run with minimal downtime, and you need to keep the target nearly in sync until a short cutover window. Which migration approach is most appropriate?

Your security team requires that no Google-managed service can access production database credentials directly. Applications run on GKE and must connect to Cloud SQL for PostgreSQL. You also need automated credential rotation without application redeploys. What is the best approach?

After moving to Cloud SQL for PostgreSQL, users report intermittent slow queries. You need to identify the highest-latency queries and understand whether missing indexes are contributing. What should you do first?