Google Cloud Professional Cloud Database Engineer — Question 132

You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?

Answer options

• A. Deploy the database using Cloud SQL.
• B. Use BigQuery, and load data in batches.
• C. Deploy the database using Bigtable.
• D. Deploy the database using Cloud Spanner.

Correct answer: C

Explanation

The correct choice is C because Bigtable is designed for large volumes of data with high write and read throughput, making it suitable for real-time analytics from numerous sensors. Option A (Cloud SQL) is not optimal for high-velocity data, B (BigQuery) is better for batch processing rather than real-time, and D (Cloud Spanner) is more complex and suited for horizontal scaling rather than the high ingestion rate required here.