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 company is migrating a business-critical MySQL database to Google Cloud. With a small operations team, leadership wants to reduce manual lifecycle management while meeting these requirements:
SUPER privilege or OS-level customization.Which deployment model best meets these requirements?
A Managed Instance Group (MIG) manages a pool of Compute Engine VMs based on an instance template, supporting autohealing and rolling updates. Using custom OS images grouped into an image family lets administrators standardize VM configurations and roll out updated boot disks across instances.
The organization required strict OS-level customization, custom kernel parameters, or unsupported MySQL plugins and had dedicated infrastructure engineers to maintain custom image pipelines and failover scripts.
Google Cloud Marketplace provides preconfigured click-to-deploy templates that quickly provision software stacks—such as standalone MySQL, LAMP stacks, or Percona clusters—onto Compute Engine virtual machines. While it streamlines the initial installation, the resulting deployment is still a self-managed (unmanaged) database running on Infrastructure as a Service (IaaS).
SUPER privileges, which adds security and maintenance duties the team does not need.The team needed rapid deployment of a specific third-party stack or custom MySQL configuration—such as SUPER privileges or unsupported user-defined functions—and had the operational capacity to manage ongoing patching, backups, and high availability themselves.
Database Center provides a centralized fleet-wide dashboard that surfaces health issues and recommendations—including for self-managed MySQL, PostgreSQL, and SQL Server databases on Compute Engine VMs. Backup and DR Service provides centralized, policy-based backup and recovery for Compute Engine workloads and self-managed databases.
The company were forced to run a self-managed MySQL database on Compute Engine due to legacy licensing or OS dependencies, and needed centralized visibility into patch compliance alongside enterprise backup protection.
Cloud SQL for MySQL is a fully managed relational database service on Google Cloud. Under the shared responsibility model for managed databases, Google Cloud manages the underlying compute infrastructure, storage, operating system, and database engine administration, allowing teams to focus on schema design, queries, and application performance rather than infrastructure maintenance.
SUPER privilege or custom OS binaries, it fits cleanly within Cloud SQL's managed security boundaries.Compared to self-managing MySQL on Compute Engine (an IaaS model), Cloud SQL shifts routine lifecycle tasks—such as patching, backups, upgrades, and failover orchestration—to Google Cloud, delivering the lowest administrative burden for a small team.
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