
Answer-first summary for fast verification
Answer: Replace the existing data warehouse with BigQuery. Use table partitioning.
The correct answer is A. Replacing the existing data warehouse with BigQuery and using table partitioning addresses several key requirements. BigQuery is a scalable and fully managed data warehouse that can handle the large volume of data TerramEarth collects. It supports table partitioning, which improves query performance and manages large datasets efficiently. This solution reduces latency, supports real-time analytics, and can decrease the unplanned vehicle downtime by enabling more timely insights and actions. In contrast, federated data sources would not be as reliable due to potential performance implications and the need for external data maintenance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
TerramEarth manufactures heavy equipment for the mining (80%) and agricultural (20%) industries, with over 500 dealers and service centers in 100 countries. They have 20 million vehicles in operation that collect 120 fields of data per second. About 200,000 vehicles are connected to a cellular network, collectively generating approximately 9 TB/day. This data is currently stored locally on the vehicles and transferred via FTP to a data warehouse (PostgreSQL) in a single U.S. west coast data center. Due to this centralized setup, aggregated reports are based on data that is 3 weeks old, leading to delays in stocking replacement parts and causing some customers to face up to 4 weeks of downtime. The business requirements include decreasing unplanned vehicle downtime to less than 1 week, supporting the dealer network with better data, and partnering with other companies for joint offerings. Technically, the company needs to expand beyond a single data center, create a backup strategy, increase data transfer security, and improve the data warehouse to anticipate customer needs. Given this context, you need to implement a reliable, scalable GCP solution for the data warehouse. What should you do?
A
Replace the existing data warehouse with BigQuery. Use table partitioning.
B
Replace the existing data warehouse with a Compute Engine instance with 96 CPUs.
C
Replace the existing data warehouse with BigQuery. Use federated data sources.
D
Replace the existing data warehouse with a Compute Engine instance with 96 CPUs. Add an additional Compute Engine preemptible instance with 32 CPUs.
No comments yet.