Which schema should you use?

MJTelco needs you to create a schema in Google Bigtable that will allow for the historical analysis of the last 2 years of records. Each record that comes in is sent every 15 minutes, and contains a unique identifier of the device and a data record. The most common query is for all the data for a given device for a given day.

Which schema should you use?
A . Rowkey: date#device_idColumn data: data_point
B . Rowkey: dateColumn data: device_id, data_point
C . Rowkey: device_idColumn data: date, data_point
D . Rowkey: data_pointColumn data: device_id, date
E . Rowkey: date#data_pointColumn data: device_id

Answer: D

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments