professional-cloud-database-engineer Free Sample Questions

A financial services firm is migrating its on-premises PostgreSQL database to Google Cloud. A key regulatory requirement is that all database administrator actions must be logged, including the exact SQL text of queries executed against administrative views. You have configured Cloud Audit Logs for the Cloud SQL for PostgreSQL instance, but the CISO reports that Data Access audit logs are not capturing the full text of `SELECT` statements run by DBAs. Which action is required to meet this compliance mandate?

A global media company uses a multi-region Cloud Spanner instance for its content metadata catalog. To optimize costs, the development team has been instructed to use stale reads (`exact_staleness` or `max_staleness`) for non-critical user-facing queries. However, they report that some stale reads are unexpectedly slow, occasionally taking almost as long as strong reads. You need to diagnose the underlying cause of this performance anomaly. What is the most likely reason for this behavior?

You are designing a database migration strategy for a large retail company moving from a self-managed Oracle RAC environment on-premises to Google Cloud. The primary goals are to minimize downtime and provide a safety net for rollback if issues arise post-migration. The target database will be Cloud SQL for PostgreSQL. You will use the Database Migration Service (DMS) for the migration. Which TWO actions should you incorporate into your migration plan to meet the requirements? (Select TWO)

A social media company is launching a new feature that generates a personalized, chronological feed of events for each user. The projected workload is extremely write-heavy, with billions of events ingested daily. The most common query pattern is retrieving the last N events for a specific user. The data must be durable, but eventual consistency is acceptable for the feed generation. The company wants a solution that offers predictable low latency for writes and scales linearly without manual sharding. Which database solution and schema design should you recommend?

True or False: When a Cloud SQL for MySQL instance is configured for high availability (HA), read requests are automatically load-balanced between the primary and standby instances to improve read throughput.

Your company runs a critical order processing system on a regional Cloud SQL for PostgreSQL instance. The business has defined a Recovery Point Objective (RPO) of zero and a Recovery Time Objective (RTO) of less than 5 minutes for regional failures. You have already configured the instance for high availability (HA). What additional step is required to meet these business requirements?

You are a database administrator for an online retailer. During a performance audit of your Cloud SQL for MySQL database, you discover several long-running queries that are causing CPU contention. The Query Insights dashboard shows that these queries are performing full table scans on a large `products` table. The queries typically filter products by `category` and `is_active` status. What is the most effective and efficient way to resolve this performance issue?

A gaming company uses Firestore in Native Mode to store player profiles and inventory. They are designing a new feature that requires retrieving all players who possess a specific rare item and have a skill level greater than 90. The `players` collection contains millions of documents. The development team is concerned about query performance and cost. Which Firestore feature should they use to implement this query efficiently?

You are migrating a 10 TB on-premises MySQL 5.7 database to Cloud SQL for MySQL 8.0. The business requires the migration to have near-zero downtime. You plan to use the Database Migration Service (DMS). During the planning phase, you need to identify the correct sequence of steps to perform the migration and cutover. What is the correct order of operations?