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

Memorystore is Google Cloud's fully managed Redis and Memcached service for low-latency in-memory caching.

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 Spanner provides global distribution with full ACID transactions and can handle millions of TPS, making it ideal for mission-critical financial apps.

Question 3

What is the purpose of Cloud SQL Read Replicas?

Accepted Answer

Offload read traffic and improve read performance

Answer

Cloud SQL Read Replicas serve read queries, reducing load on the primary instance and improving overall read throughput.

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

Bucket Lock with a retention policy enforces a non-deletable, immutable retention period that satisfies regulatory compliance requirements.

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

AlloyDB's columnar engine accelerates analytical queries by storing data in a column-oriented format in memory alongside the row store.

Google Cloud Certified - Professional Cloud Architect Practice Test

Google Cloud Certified - Professional Cloud Architect Practice Test

Google Cloud Certified Storage and Database Solutions 2