
Explanation:
When designing a row key for Cloud Bigtable, it's crucial to consider the access patterns to ensure efficient data retrieval. The MySQL table's move to Cloud Bigtable suggests that queries will frequently access data by Account_id and possibly by Event_timestamp. Therefore, combining Account_id with Event_timestamp in the row key (Account_id_Event_timestamp) ensures that all events for a specific account are stored contiguously and sorted by time, facilitating efficient range scans. This design supports common query patterns and optimizes performance in Cloud Bigtable. Options A and D are too simplistic and do not account for the time-based ordering, while option C reverses the order, which could lead to less efficient queries for account-specific data.
Ultimate access to all questions.
No comments yet.
How should you design a row key in Cloud Bigtable for a table being migrated from MySQL with the following schema?
A
Set Account_id as a key.
B
Set Account_id_Event_timestamp as a key.
C
Set Event_timestamp_Account_id as a key.
D
Set Event_timestamp as a key.