Google Cloud Associate Cloud Engineer — Question 242

The core business of your company is to rent out construction equipment at large scale. All the equipment that is being rented out has been equipped with multiple sensors that send event information every few seconds. These signals can vary from engine status, distance traveled, fuel level, and more. Customers are billed based on the consumption monitored by these sensors. You expect high throughput – up to thousands of events per hour per device – and need to retrieve consistent data based on the time of the event. Storing and retrieving individual signals should be atomic. What should you do?

Answer options

• A. Create files in Cloud Storage as data comes in.
• B. Create a file in Filestore per device, and append new data to that file.
• C. Ingest the data into Cloud SQL. Use multiple read replicas to match the throughput.
• D. Ingest the data into Bigtable. Create a row key based on the event timestamp.

Correct answer: D

Explanation

The correct answer is D because Bigtable is designed for high throughput and can handle large volumes of writes and reads, making it suitable for storing event data. By using the event timestamp as a row key, you ensure that the data is organized chronologically, facilitating efficient retrieval. Options A and B do not provide the necessary atomicity and performance for high-volume event data, while option C, while capable of handling some throughput, may not be efficient or scalable enough for the expected event rates.