PROFESSIONAL-DATA-ENGINEER · Question #164
PROFESSIONAL-DATA-ENGINEER Question #164: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #164. The question stem and answer options stay visible for context.
Question
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?
Options
- ACreate a table in BigQuery, and append the new samples for CPU and memory to the table
- BCreate 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
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.