Google Cloud Professional Data Engineer PDE — Topic 1 Question 209

Question

A shipping company has live package-tracking data that is sent to an Apache Kafka stream in real time. This is then loaded into BigQuery. Analysts in your company want to query the tracking data in BigQuery to analyze geospatial trends in the lifecycle of a package. The table was originally created with ingest-date partitioning. Over time, the query processing time has increased. You need to copy all the data to a new clustered table. What should you do?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Implement clustering in BigQuery on the package-tracking ID column. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. This option meets the real-time / low-latency performance requirement.

Google Cloud Professional Data Engineer PDE — Question 209