Answer-first summary for fast verification
Answer: Use BigQuery as the data warehouse. Connect all vehicles to the network and stream data into BigQuery using Cloud Pub/Sub and Cloud Dataflow. Use Google Data Studio for analysis and reporting.
Option A is the correct answer. By using BigQuery as the data warehouse and connecting all vehicles to the network, data can be streamed into BigQuery using Cloud Pub/Sub and Cloud Dataflow. This approach allows for real-time data ingestion, which significantly reduces data latency compared to the existing FTP-based solution that results in 3-week-old data. Google Data Studio can then be used for analysis and reporting, providing up-to-date insights that help in reducing unplanned vehicle downtime and improving customer service.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
TerramEarth manufactures heavy equipment for the mining and agricultural industries. They have 20 million vehicles in operation that collect 120 fields of data per second, resulting in about 9 TB/day from connected vehicles. They aim to decrease unplanned vehicle downtime to less than 1 week, support the dealer network with usage data, and partner with other companies for joint offerings. Considering these requirements, how should you reduce the unplanned vehicle downtime in GCP?
A
Use BigQuery as the data warehouse. Connect all vehicles to the network and stream data into BigQuery using Cloud Pub/Sub and Cloud Dataflow. Use Google Data Studio for analysis and reporting.
B
Use BigQuery as the data warehouse. Connect all vehicles to the network and upload gzip files to a Multi-Regional Cloud Storage bucket using gcloud. Use Google Data Studio for analysis and reporting.
C
Use Cloud Dataproc Hive as the data warehouse. Upload gzip files to a Multi-Regional Cloud Storage bucket. Upload this data into BigQuery using gcloud. Use Google Data Studio for analysis and reporting.
D
Use Cloud Dataproc Hive as the data warehouse. Directly stream data into partitioned Hive tables. Use Pig scripts to analyze data.
No comments yet.