Cloud Database Engineer Intermediate Practice Exam: Medium Difficulty 2025

A global e-commerce platform needs a relational database for orders with strong consistency, automatic scaling for peak events, and high availability across multiple zones in a region. Operations wants minimal capacity planning. Which Google Cloud database solution best meets these requirements?

A SaaS application uses Firestore in Native mode to store user profiles. Traffic is spiky and global, and the app reads user profiles far more often than it writes them. You need low-latency reads worldwide and automatic multi-region resilience. Which design is most appropriate?

You are designing a data ingestion platform that writes time-series events at high throughput. The data will be queried later for trend analysis and aggregations over time windows. You need serverless scaling and separation of storage and compute. Which solution is the best fit?

A team is provisioning Cloud SQL for PostgreSQL for a production workload. Requirements include automatic failover within the region, encrypted connections from applications, and controlled maintenance timing. What is the best combination of configuration steps?

You manage a Cloud Spanner instance that supports several microservices. A new microservice needs its own database but must share the same Spanner instance for centralized operations and quota management. What should you do?

A company needs to restrict Cloud SQL access to only workloads running in a specific VPC, and they want to avoid public IP exposure. They also need to authenticate users with IAM where possible. What is the most appropriate setup?

You need to migrate a 2 TB PostgreSQL database from on-premises to Cloud SQL for PostgreSQL with minimal downtime. The source database continues to receive writes during the migration. Which approach best meets the requirement?

A team is moving from self-managed MySQL on Compute Engine to Cloud SQL for MySQL. They want to validate performance and schema compatibility before cutover and ensure they can roll back quickly if needed. What is the best migration plan?

You are migrating an on-prem data warehouse to BigQuery. The source system produces daily incremental files in Cloud Storage. Analysts frequently filter by date and customer_id, and query costs and performance need to be optimized. What is the best table design approach in BigQuery?

A Cloud SQL for PostgreSQL instance shows periodic high CPU and increased query latency. You need to identify the top slow queries and correlate them with application releases. What is the best approach using Google Cloud managed capabilities?