Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
What is the optimal database and data model for storing one-second interval samples of time series CPU and memory usage for millions of computers, enabling real-time, ad hoc analytics, ensuring scalability, and avoiding per-query charges?
A
Design a wide table in Bigtable with a row key that merges the computer identifier with the sample time at each minute, and aggregate the values for each second as column data.
B
Construct a narrow table in Bigtable with a row key that combines the Computer Engine computer identifier with the sample time at each second.
C
Develop a wide table in BigQuery with a column for each sample value at each second and update the row with the interval for each second.
D
Establish a table in BigQuery, and append the new samples for CPU and memory to the table.