PDE Storing the Data Practice Question
Which Google Cloud service is a fully managed relational database for MySQL, PostgreSQL, and SQL Server, offering automatic replication and backups?
⚠ Common exam trap
Many exam-takers confuse Cloud SQL with Cloud Spanner because both are relational databases, but Cloud Spanner is designed for global scale and does not support MySQL, PostgreSQL, or SQL Server compatibility.
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 the correct answer because it is Google Cloud's fully managed relational database service that supports MySQL, PostgreSQL, and SQL Server. It provides automatic replication across zones and automated backups, making it the ideal choice for traditional relational database workloads without the need for manual administration.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Cloud Spanner
Why it's wrong here
Cloud Spanner is a globally distributed, horizontally scalable database using its own SQL dialect, not a managed engine for MySQL, PostgreSQL or SQL Server. It suits globally consistent, high-throughput workloads. Cloud SQL is the service that provides managed MySQL, PostgreSQL and SQL Server with automatic replication and backups.
- ✗
AlloyDB
Why it's wrong here
AlloyDB is a fully managed PostgreSQL-compatible database, so it covers only one of the three engines named and excludes MySQL and SQL Server. It targets high-performance PostgreSQL workloads. Cloud SQL is the service offering managed MySQL, PostgreSQL and SQL Server together with automatic replication and backups.
- ✗
Bigtable
Why it's wrong here
Bigtable is a wide-column NoSQL store for large analytical and time-series workloads, not a relational engine supporting MySQL, PostgreSQL or SQL Server. It lacks SQL schemas and the automatic relational backups described. Cloud SQL is the managed relational service covering those three engines with replication and backups.
- ✓
Cloud SQL
Why this is correct
Cloud SQL is Google Cloud's fully managed relational service supporting MySQL, PostgreSQL and SQL Server, with automated replication and backups handled by the platform. This directly satisfies the stem's requirement for a managed engine covering all three database engines without manual administration.
Go deeper
Related to this question
About these practice questions
This PDE question is part of Courseiva's 747-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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 PDE 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 PDE exam.