Free Cloud Database Engineer Practice Test

Your company is designing a globally distributed e-commerce application that requires strong consistency for inventory management and sub-10ms read latency for users worldwide. Which Google Cloud database solution best meets these requirements?

You need to migrate a 10TB MySQL database from on-premises to Cloud SQL with minimal downtime. The database is actively used 24/7, and you can tolerate up to 1 hour of downtime. What migration strategy should you implement?

Your application using Cloud Spanner is experiencing high CPU utilization and increased latency during peak hours. Query insights show that 80% of queries are scanning large portions of tables without using indexes. What is the most effective solution?

You are provisioning a Cloud SQL for PostgreSQL instance for a production workload that requires 99.95% availability. Which configuration should you implement?

A financial services company needs to implement column-level encryption for sensitive customer data in Cloud SQL. They want application-layer encryption with key management control. What approach should they use?

You are designing a real-time analytics solution that ingests IoT sensor data at 500,000 writes per second with time-series queries. The data has a natural time-based access pattern where recent data is queried frequently. Which database solution is most appropriate?

During a migration from Oracle to Cloud SQL for PostgreSQL using Database Migration Service, you notice that stored procedures are failing to migrate. What is the most likely cause and solution?

You need to provision a Cloud SQL instance that will be accessed only by applications running in a specific VPC with no public internet exposure. What configuration should you implement?

Your Cloud Spanner database is showing transaction abort rates of 15% during peak hours. Investigation reveals that multiple transactions are updating overlapping sets of rows. What is the best approach to reduce abort rates?

A retail company wants to migrate their on-premises MongoDB cluster to Google Cloud with minimal application changes. Which migration path should they choose?

You are designing a multi-tenant SaaS application where each tenant's data must be strictly isolated for compliance. The application will have 10,000+ tenants with varying data volumes. Which Cloud Spanner design pattern provides the best balance of isolation and resource efficiency?

You need to provision a development Cloud SQL instance that will be used intermittently and should minimize costs. Which configuration is most cost-effective?

During a database migration from on-premises SQL Server to Cloud SQL, you need to validate that data was migrated correctly. Which approach provides the most comprehensive validation?

Your application uses Cloud SQL for MySQL and experiences slow query performance. Cloud SQL Insights shows high disk I/O wait times. What is the most effective solution?

You are designing a database solution for a gaming application that requires storing player profiles with flexible schemas, real-time updates, and offline mobile support with automatic synchronization. Which solution best meets these requirements?

You need to configure automated backups for a Cloud SQL instance with a recovery point objective (RPO) of 5 minutes. Which backup strategy should you implement?

During a migration from Cassandra to Bigtable, you need to handle the difference in consistency models. Cassandra used tunable consistency with quorum reads/writes. How should you design the Bigtable implementation?

You need to monitor Cloud Spanner query performance and identify queries causing high CPU utilization. Which Google Cloud tool should you use?

Your organization requires that all database connections use SSL/TLS encryption and that client certificates be verified for authentication. How should you configure Cloud SQL to meet this requirement?

You are designing a Cloud Spanner schema for a social media application with users, posts, and comments. Comments are always accessed in the context of their parent post. How should you design the schema for optimal performance?