Google Cloud Professional Data Engineer PDE — Topic 1 Question 302

Question

You work for a farming company. You have one BigQuery table named sensors, which is about 500 MB and contains the list of your 5000 sensors, with columns for id, name, and location. This table is updated every hour. Each sensor generates one metric every 30 seconds along with a timestamp, which you want to store in BigQuery. You want to run an analytical query on the data once a week for monitoring purposes. You also want to minimize costs. What data model should you use?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: 1. Create a metrics table partitioned by timestamp.2. Create a sensorId column in the metrics table, that points to the id column in the sensors table.3. Use an INSERT statement every 30 seconds to append new metrics... This option delivers the requirement at the lowest cost.

Google Cloud Professional Data Engineer PDE — Question 302