Storage and Database Solutions Flashcards
6 cards from real Google Cloud Certified - Professional Cloud Architect practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Storage and Database Solutions flashcards as text
Which GCP service provides a managed Redis or Memcached in-memory cache to reduce database load?
Answer: Memorystore
Memorystore is Google Cloud's fully managed Redis and Memcached service for low-latency in-memory caching.
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?
Answer: Cloud Spanner
Cloud Spanner provides global distribution with full ACID transactions and can handle millions of TPS, making it ideal for mission-critical financial apps.
What is the purpose of Cloud SQL Read Replicas?
Answer: Offload read traffic and improve read performance
Cloud SQL Read Replicas serve read queries, reducing load on the primary instance and improving overall read throughput.
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?
Answer: Bucket Lock with a Retention Policy
Bucket Lock with a retention policy enforces a non-deletable, immutable retention period that satisfies regulatory compliance requirements.
Which AlloyDB feature makes it significantly faster than standard Cloud SQL PostgreSQL for analytical queries?
Answer: Columnar engine for HTAP workloads
AlloyDB's columnar engine accelerates analytical queries by storing data in a column-oriented format in memory alongside the row store.
What is the recommended approach for loading large datasets into BigQuery most efficiently?
Answer: Using the BigQuery Storage Write API in batch mode or batch load jobs
BigQuery batch load jobs and the Storage Write API in batch mode are the most cost-effective and efficient ways to ingest large volumes of data.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- support.google.com — Retake fee, passing score, score release, score validity · verified Nov 2026
- cloud.google.com — Test delivery, eligibility, fees, exam format, renewal, time limit · verified Nov 2026