AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: Scenario: You work for a farming company and have gcp video

Question 1 Be Honest
« Back   Next data-engineer-pro Certification Question »
Answer

Full Certification Question

Scenario: You work for a farming company and have a BigQuery table named sensors (500 MB) containing 5,000 sensors with columns for id, name, and location. This table is updated every hour. Each sensor generates a metric every 30 seconds with a timestamp, which you want to store in BigQuery. You need to run analytical queries weekly for monitoring while minimizing costs. Question: What data model should you implement to store the metrics data efficiently and cost-effectively?