Google Cloud Certified Storage and Database Solutions 2

Question 1

Which GCP service provides a managed Redis or Memcached in-memory cache to reduce database load?

Accepted Answer

Memorystore

Answer

Cloud SQL

Answer

Firestore

Answer

Cloud Bigtable

Question 2

A financial application requires full ACID compliance and the ability to scale to millions of transactions per second globally. Which database is the best fit?

Accepted Answer

Cloud Spanner

Answer

Cloud SQL

Answer

Firestore

Answer

BigQuery

Question 3

What is the purpose of Cloud SQL Read Replicas?

Accepted Answer

Offload read traffic and improve read performance

Answer

Provide multi-region writes

Answer

Replace the primary for writes automatically

Answer

Enable real-time sync to BigQuery

Question 4

A company must ensure Cloud Storage objects in a specific bucket cannot be deleted or modified for 7 years for compliance. What should they configure?

Accepted Answer

Bucket Lock with a Retention Policy

Answer

Object Versioning

Answer

IAM Deny policies

Answer

Object Lifecycle rules

Question 5

Which AlloyDB feature makes it significantly faster than standard Cloud SQL PostgreSQL for analytical queries?

Accepted Answer

Columnar engine for HTAP workloads

Answer

Automatic sharding

Answer

Multi-region synchronous writes

Answer

Built-in Redis cache

Question 6

What is the recommended approach for loading large datasets into BigQuery most efficiently?

Accepted Answer

Using the BigQuery Storage Write API in batch mode or batch load jobs

Answer

Streaming inserts row by row

Answer

Inserting via Cloud SQL replication

Answer

Using Dataflow for every batch