Answer-first summary for fast verification
Answer: Use a row key of the form <sensorid>#<timestamp>.
The correct answer is D. Using a row key of the form <sensorid>#<timestamp> helps in achieving better distribution of data across Bigtable tablets. This reduces the chances of hotspots and balances the workload. By placing the sensor ID first, we ensure better data distribution, and by following it with the timestamp, we can still perform efficient range scans within a specific time frame. According to Bigtable best practices, it is not recommended to use a timestamp alone or place it at the start of the row key.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company is currently streaming real-time sensor data from the factory floor into Google Cloud Bigtable. However, the system has exhibited extremely poor query performance, particularly when populating real-time dashboards. How should you redesign the row key structure to optimize Bigtable performance for these queries?
A
Use a row key of the form <timestamp>.
B
Use a row key of the form <sensorid>.
C
Use a row key of the form <timestamp>#<sensorid>.
D
Use a row key of the form <sensorid>#<timestamp>.
No comments yet.