Skip to content

Quiz: Storage and Database Services :Essential Google Cloud Infrastructure: Core Services (Preparing for Google Cloud Certification: Cloud Architect Professional Certificate) Answers 2025

Question 1

What data storage service might you select if you need to migrate a standard relational database running on a single machine to the cloud?

🟩 Cloud SQL
❌ Persistent Disk
❌ Cloud Storage
❌ BigQuery

Explanation:

Cloud SQL is a managed relational database service compatible with MySQL, PostgreSQL, and SQL Serverβ€”ideal for migrating a single-machine RDBMS.


Question 2

Which Google Cloud data storage service offers ACID transactions and can scale globally?

❌ Cloud Storage
❌ Cloud CDN
🟩 Spanner
❌ Cloud SQL

Explanation:

Spanner is the only Google Cloud database that provides global scale with strong ACID consistency, horizontal scaling, and high availability.


Question 3

Which service provides data warehouse storage and an interactive SQL interface?

🟩 BigQuery
❌ Cloud SQL
❌ Datalab
❌ Dataproc

Explanation:

BigQuery is a serverless data warehouse with an SQL interface optimized for huge datasets and analytical queries.


🧾 Summary Table

Q# Correct Answer Key Concept
1 Cloud SQL Best for RDBMS migration
2 Spanner Global ACID + distributed SQL
3 BigQuery Cloud data warehouse with SQL