Storage and Database Solutions Flashcards

A development team needs a relational database with PostgreSQL compatibility and superior performance and availability over Cloud SQL. Which service should they choose?

Answer: AlloyDB for PostgreSQL

AlloyDB for PostgreSQL offers 4x faster transactional performance than standard Cloud SQL PostgreSQL with enhanced high availability.

Which feature in Cloud Storage allows automatic transition of objects to cheaper storage classes over time?

Answer: Object Lifecycle Management

Object Lifecycle Management applies rules to automatically transition or delete objects based on age, storage class, or other conditions.

What consistency model does Firestore use for its document reads?

Answer: Strong consistency

Firestore provides strong consistency for all document reads, ensuring you always read the latest committed data.

A company needs to replicate their Cloud SQL primary instance to another region for disaster recovery. What feature enables this?

Answer: Cross-region Read Replica

Cloud SQL supports cross-region read replicas, which can be promoted to a standalone primary in the event of a regional disaster.

When using Cloud Bigtable, what is the best practice for row key design to avoid hotspotting?

Answer: Use high-cardinality, evenly distributed keys such as salted or reversed strings

Hotspotting occurs when many reads/writes hit the same tablet; using salted or reversed keys distributes load evenly across nodes.

Which storage class should be used for data that is accessed approximately once per month?

Answer: Nearline

Nearline storage is designed for data accessed less than once a month, offering lower storage costs with a 30-day minimum storage duration.