Google Cloud Certified Storage and Database Solutions 1 — Questions and Answers
Question 1: Which Google Cloud database service is best suited for a globally distributed, strongly consistent, relational workload?
- Cloud SQL
- Cloud Spanner (Correct answer)
- Firestore
- BigQuery
Correct answer: Cloud Spanner
Cloud Spanner provides horizontal scaling with strong consistency and a relational data model, ideal for globally distributed OLTP workloads.
Question 2: A startup needs a fully managed, serverless NoSQL document database for a mobile app with real-time sync. Which service fits best?
- Cloud Bigtable
- Cloud Spanner
- Firestore (Correct answer)
- Memorystore
Correct answer: Firestore
Firestore is a serverless, NoSQL document database with real-time synchronization, ideal for mobile and web applications.
Question 3: What Cloud Storage class is most cost-effective for data accessed less than once per year?
- Standard
- Nearline
- Coldline
- Archive (Correct answer)
Correct answer: Archive
Archive storage has the lowest storage cost but highest retrieval cost, making it ideal for data accessed less than once a year.
Question 4: Which GCP service is optimized for petabyte-scale, low-latency reads/writes for time-series or wide-column workloads like IoT data?
- BigQuery
- Cloud Spanner
- Cloud Bigtable (Correct answer)
- Cloud SQL
Correct answer: Cloud Bigtable
Cloud Bigtable is a managed wide-column NoSQL database designed for petabyte-scale time-series and analytical workloads with low latency.
Question 5: A team needs to migrate an existing MySQL database to GCP with minimal changes. Which managed service should they use?
- Cloud Bigtable
- Cloud SQL for MySQL (Correct answer)
- AlloyDB
- Cloud Spanner
Correct answer: Cloud SQL for MySQL
Cloud SQL for MySQL is a fully managed relational database that supports MySQL, enabling lift-and-shift migrations with minimal modification.
Question 6: Which Cloud Storage feature helps protect against accidental deletion by retaining deleted objects for a configurable period?
- Bucket Lock
- Object Versioning (Correct answer)
- Retention Policies
- Object Lifecycle Management
Correct answer: Object Versioning
Object Versioning in Cloud Storage keeps a history of object versions, allowing recovery of accidentally deleted or overwritten objects.
Google Cloud Certified Storage and Database Solutions 1
Which Google Cloud database service is best suited for a globally distributed, strongly consistent, relational workload?