Correct Answer: Prefix the row key with a hash of the customer ID
Hashing or salting the prefix of a row key ensures that consecutive writes (e.g., for different customers at the same time) are distributed across different nodes in the cluster, p...
Correct Answer
Prefix the row key with a hash of the customer ID
Why This Answer Is Correct
Hashing or salting the prefix of a row key ensures that consecutive writes (e.g., for different customers at the same time) are distributed across different nodes in the cluster, preventing hotspots.
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'?