Correct Answer: Avoid using monotonically increasing primary keys (like timestamps or IDs)
Monotonically increasing keys cause all writes to hit a single 'split' (node) in Spanner, creating a hotspot. Using UUIDs or bit-reversing keys distributes writes evenly....
Correct Answer
Avoid using monotonically increasing primary keys (like timestamps or IDs)
Why This Answer Is Correct
Monotonically increasing keys cause all writes to hit a single 'split' (node) in Spanner, creating a hotspot. Using UUIDs or bit-reversing keys distributes writes evenly.
This question evaluates your knowledge of Cloud SQL — a core concept tested in Professional Cloud Architect. Understanding Cloud SQL is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
A financial application requires a relational database that supports high availability and automated backups. The database must be fully managed to reduce operational overhead. Which service fits these requirements?
Your company is deploying a global application that requires a relational database. The application must support multi-region writes with strong consistency and five-nines (99.999%) availability. Which database service should you recommend?
You need to migrate a 50 TB PostgreSQL database from on-premises to Cloud SQL. The business requires the cutover to have less than 1 hour of downtime. Which migration strategy is most effective?
A video game company needs to handle a massive influx of users during a tournament. They need a database that can handle millions of lightning-fast reads and writes with sub-10ms latency for player status updates. Which NoSQL service should they use?
What is the primary benefit of 'Regional Cloud SQL' (High Availability) over 'Standalone Cloud SQL'?