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 Microsoft SQL Server workload to Google Cloud. An initial infrastructure quote shows that raw virtual machine pricing on Compute Engine is lower than the hourly rate for Cloud SQL for SQL Server. However, the organization faces the following constraints:
Which recommendation accurately reflects the Total Cost of Ownership (TCO) and best meets the company's requirements?
Cloud SQL for SQL Server is a fully managed relational database service on Google Cloud that runs SQL Server on Google-managed virtual machines and persistent storage. Rather than exposing the underlying operating system and infrastructure for manual administration, it provides a ready-to-use database endpoint backed by built-in management agents.
Evaluating TCO requires looking beyond raw compute and storage rates to include operational labor, licensing fees, and reliability engineering. While self-hosting on Compute Engine appears cheaper on a bare VM price sheet, Cloud SQL delivers superior long-term economic value for lean teams running commercial databases without existing licenses.
Bring Your Own License (BYOL) allows organizations to import custom OS and software images onto Compute Engine so they can apply previously purchased third-party licenses instead of paying for pay-as-you-go premium images. Disabling simultaneous multithreading (SMT) reduces the number of vCPUs per physical core from two to one, which can lower core-based licensing counts.
The organization already owned transferable Microsoft SQL Server Enterprise or Standard licenses, required full OS-level control not permitted in a managed service, and had dedicated database administrators to handle patching and HA.
Cloud Spanner is a fully managed, globally distributed relational database service built for virtually unlimited horizontal scaling, synchronous multi-zone or multi-region replication, and external consistency. It uses disaggregated storage and compute to deliver zero-downtime maintenance and automatic failover.
The company was willing to re-architect the application away from SQL Server to achieve global multi-region active-active writes, horizontal scale beyond single-instance limits, and strict external consistency.
Spot VMs are excess Compute Engine capacity offered at heavily discounted rates (often significantly cheaper than regular VMs). In exchange for the lower price, Google Cloud can preemptively stop or delete Spot VMs at any time to reclaim compute capacity.
The workload consisted of fault-tolerant, stateless batch processing or ephemeral development and testing tasks that can safely restart after preemption without impacting business continuity or requiring high availability.
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