Quiz :Exploring Data Transformation with Google Cloud (Google Cloud Digital Leader Training Professional Certificate) Answers 2025
Question 1
Data in the form of video, pictures, and audio recordings is well suited to object storage. Which product is best?
✔️ Cloud Storage
❌ Cloud SQL
❌ BigQuery
❌ Firestore
Explanation:
Cloud Storage is Google’s object storage service ideal for media files like video, images, and audio.
Question 2
Sales report needed every 90 days. Which storage class?
✔️ Nearline
❌ Coldline
❌ Standard
❌ Archive
Explanation:
Nearline is optimized for data accessed once per month or once every 30–90 days.
Question 3
Which characteristic is true for all Cloud Storage classes?
✔️ Geo-redundancy if stored in multi-region or dual-region
❌ Single-region only
❌ Maximum storage limits
❌ High latency and low durability
Explanation:
All Cloud Storage classes support multi-region/dual-region for geo-redundancy and have 11 nines durability.
Question 4
Best SQL-based option for transactional workload needing local/regional scalability?
✔️ Cloud SQL
❌ Spanner
❌ Bigtable
❌ Cloud Storage
Explanation:
Cloud SQL is ideal for relational OLTP workloads with regional scalability.
Question 5
What two services does BigQuery provide?
✔️ Storage and analytics
❌ Networking and storage
❌ Migration and analytics
❌ Compute and analytics
Explanation:
BigQuery separates storage and compute, providing analytics and warehousing.
Question 6
How does BigQuery multicloud help organizations?
✔️ Allows analysis across multiple cloud providers → removes data silos
❌ Reduces costs by reducing clouds
❌ More secure on-prem
❌ Only for disaster recovery
Explanation:
BigQuery Omni lets you query data across AWS, Azure, and Google Cloud without moving data.
Question 7
Google’s big data database powering Search, Analytics, Gmail, etc.
✔️ Bigtable
❌ Cloud SQL
❌ Spanner
❌ Cloud Storage
Explanation:
Bigtable is Google’s foundational NoSQL wide-column database for massive scale.
Question 8
Best SQL-based option for global transactional scalability?
✔️ Spanner
❌ Cloud SQL
❌ Bigtable
❌ Firestore
Explanation:
Spanner = globally distributed, strongly consistent SQL database.
Question 9
Migrating on-prem databases to same type on the cloud describes:
✔️ Lift and shift
❌ Refactoring
❌ Managed database migration
❌ Remain on-premises
Explanation:
Lift-and-shift moves databases as-is into managed cloud equivalents.
Question 10
Google Cloud product to synchronize data across databases/storage/apps:
✔️ Datastream
❌ Dataprep
❌ Pub/Sub
❌ Dataproc
Explanation:
Datastream provides change data capture (CDC) replication between databases and storage systems.
🧾 Summary Table
| Q# | Correct Answer | Key Concept |
|---|---|---|
| 1 | Cloud Storage | Best for images, audio, video |
| 2 | Nearline | Access every 30–90 days |
| 3 | Geo-redundancy optional | Cloud Storage durability features |
| 4 | Cloud SQL | Regional transactional SQL |
| 5 | Storage + Analytics | BigQuery’s core functions |
| 6 | Removes data silos | BigQuery multicloud |
| 7 | Bigtable | Google’s large-scale NoSQL |
| 8 | Spanner | Global SQL scalability |
| 9 | Lift and shift | Move same DB to cloud |
| 10 | Datastream | Data synchronization (CDC) |