LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Google Professional Data Engineer

Google Professional Data Engineer

Get started today

Ultimate access to all questions.


Comments

Loading comments...

As a data engineer at a farming company, you manage a BigQuery table named "sensors," which is approximately 500 MB in size. This table includes 5000 sensors with columns for id, name, and location and is updated every hour. Each sensor produces a metric every 30 seconds, accompanied by a timestamp, and you need to store these metrics in BigQuery for analysis. You plan to run an analytical query on the collected data once a week for monitoring purposes. Given these requirements and the goal of minimizing costs, what data model should you implement?

Exam-Like



Powered ByGPT-5