Cloud Digital Leader Practice Question: Google Cloud products, services, and solutions
A development team needs a managed relational database (MySQL or PostgreSQL) for their web application. They want automatic backups, patching, and high availability without managing a database server. Which Google Cloud service provides this?
⚠ Common exam trap
Google Cloud often tests the distinction between managed and unmanaged services, and the trap here is that candidates may confuse Cloud SQL with Compute Engine self-managed setups, overlooking the 'without managing a database server' requirement.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Cloud SQL
Cloud SQL is a fully managed relational database service for MySQL, PostgreSQL, and SQL Server. It handles automated backups, patching, and high availability (via regional failover replicas) without requiring the user to manage the underlying database server, directly matching the team's requirements.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Compute Engine with a self-managed MySQL installation.
Why it's wrong here
Compute Engine with a self-managed MySQL installation gives the team full control but shifts all operational burden onto them. They would need to configure and maintain replication, perform OS and database patching, manage backup schedules and retention, set up failover and health checks, and monitor metrics and alerts—precisely the tasks the team wants to avoid. While this option could technically meet the requirements, it contradicts the stated goal of leveraging Google-managed services and introduces significant operational overhead and risk.
- ✓
Cloud SQL
Why this is correct
Cloud SQL is a fully managed relational database service that supports MySQL, PostgreSQL, and SQL Server. Google Cloud handles the undifferentiated heavy lifting: automated patching, built-in high availability with synchronous replication and automatic failover, managed backups with point-in-time recovery, and integrated monitoring. Because it exposes standard MySQL connections and SQL semantics, existing applications can migrate without rewriting queries, and the team gains a operational SLA without managing any infrastructure.
- ✗
Cloud Bigtable
Why it's wrong here
Cloud Bigtable is a wide-column NoSQL database optimized for low-latency, high-throughput read/write operations on massive datasets, not for relational workloads. It does not support SQL (only HBase API), lacks ACID transactions across rows, and does not enforce foreign keys or joins. A team needing managed MySQL with full relational capabilities would find Bigtable's schema flexibility and key-value access model fundamentally incompatible with their SQL-based application.
- ✗
Cloud Storage
Why it's wrong here
Cloud Storage is an object storage service designed for immutable blobs such as images, videos, and backups. It offers no SQL query engine, no relational schema, no transactions, and no JDBC/ODBC connectivity, so it cannot function as a relational database for transactional applications. Even with features like Cloud Storage FUSE, it only provides file-like access, not the query semantics or consistency guarantees required by a MySQL-compatible workload.
Go deeper
Related to this question
Learn chapter
Cloud Digital Transformation
Key term
Service
A service is a software component or system that performs a specific function and is available to be used by other programs or users over a network.
Key term
Failover
Failover is the automatic switching to a backup system when the primary system fails, ensuring continuous operation and minimal downtime.
About these practice questions
Courseiva writes every GCDL question from scratch — 829 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This GCDL practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the GCDL exam.