Google Cloud Professional Cloud Database Engineer — Question 27

You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?

Answer options

• A. Use Cloud SQL with read replicas for throughput.
• B. Use Firestore, and rely on automatic serverless scaling.
• C. Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
• D. Use Bigtable, and add nodes as necessary to achieve the required throughput.

Correct answer: D

Explanation

The correct choice is D, as Bigtable is designed for massive scalability and low latency, making it suitable for high-throughput applications like those handling IoT data. Options A and B do not provide the required performance and scalability for such workloads, while option C, although it offers scalability, is more suited for caching rather than persistent storage needed for historical data.