Prepare and test your skills

Prepare and test your skills

Free sample question with answers and detailed explanation below. The Professional Cloud Database Engineer practice bank has an additional 769 practice questions.Try 10 free realistic questions: instant score, no credit card, and no account required.
A financial services company runs a mission-critical Cloud SQL for MySQL Enterprise Plus instance in production. You need to upgrade the database engine to a newer major version while meeting the following strict operational requirements:
Which upgrade strategy should you implement?
A Cloud SQL blue-green deployment is a managed change-management workflow that stages major database version upgrades or configuration changes in an isolated, temporary green environment alongside your active blue production environment. By keeping both environments synchronized via continuous logical replication, it lets you test changes thoroughly before promoting the new environment to production.
BLUE_INSTANCE_NAME-green-UNIQUE_ID) to verify query performance, schema behavior, and application compatibility.PROVISIONING, SWITCHOVER_READY (or SWITCHOVER_NOT_READY), and post-switchover cleanup.Unlike an in-place major version upgrade—which takes the production instance offline during the upgrade and offers no live staging validation—or a manual migration with Database Migration Service that requires reconfiguring application endpoints, a blue-green deployment uniquely combines live staging validation, automatic endpoint swapping, and sub-second switchover downtime on Enterprise Plus.
An in-place major version upgrade updates the database engine directly on your existing Cloud SQL instance using the gcloud sql instances patch --database-version command or the Google Cloud console. It preserves your instance name, IP address, user data, and explicitly configured flags without provisioning a separate target instance.
The organization could tolerate several minutes of planned downtime during a low-traffic window, wanted the simplest single-instance upgrade path without managing a temporary staging environment, and had already validated compatibility separately on a cloned test instance.
Self-service maintenance is a Cloud SQL feature that allows administrators to manually initiate a pending maintenance update ahead of the automatically scheduled maintenance window. On Cloud SQL Enterprise Plus edition, planned maintenance updates achieve near-zero downtime (typically less than one second of lost connectivity) by preparing an updated VM in parallel before switching over the persistent disk and static IP.
You only needed to apply an urgent minor database version patch or operating system security update on an Enterprise Plus instance sooner than the next scheduled maintenance window while keeping connectivity disruption under one second.
Database Migration Service (DMS) is a serverless migration tool that performs an initial data dump followed by continuous change data capture (CDC) replication from a source database to a newly provisioned destination instance. It is commonly used to migrate workloads from external databases, Amazon RDS, or between Cloud SQL configurations and editions.
You were migrating a database from an external cloud or on-premises server into Cloud SQL, upgrading across incompatible storage/network architectures where blue-green deployment is unavailable, or consolidating heterogeneous workloads.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated