You need to choose a database to store time series CPU and memory usage for millions of computers. You need to store this data in one-second interval samples. Analysts will be performing real-time, ad hoc analytics against the database. You want to avoid being charged for every query executed and ensure that the schema design will allow for future growth of the dataset. Which database and data model should you choose?
A) Create a table in BigQuery, and append the new samples for CPU and memory to the table
B) Create a wide table in BigQuery, create a column for the sample value at each second, and update the row with the interval for each second
C) Create a narrow table in Cloud Bigtable with a row key that combines the Computer Engine computer identifier with the sample time at each second
D) Create a wide table in Cloud Bigtable with a row key that combines the computer identifier with the sample time at each minute, and combine the values for each second as column data.
Correct Answer:
Verified
Q148: After migrating ETL jobs to run on
Q149: You are analyzing the price of a
Q150: You need to deploy additional dependencies to
Q151: You work for a large bank that
Q152: You are building new real-time data warehouse
Q154: A shipping company has live package-tracking data
Q155: You work for a financial institution that
Q156: You are designing a pipeline that publishes
Q157: You work for a mid-sized enterprise that
Q158: MJTelco Case Study Company Overview MJTelco is
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents