Winter Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 8w52ceb345

A shipping company has live package-tracking data that is sent to an Apache Kafka stream...

Google Professional-Data-Engineer Full Course Access
Google Professional-Data-Engineer View All Questions

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 implement a change that would improve query performance in BigQuery. What should you do?

A.

Implement clustering in BigQuery on the ingest date column.

B.

Implement clustering in BigQuery on the package-tracking ID column.

C.

Tier older data onto Cloud Storage files, and leverage extended tables.

D.

Re-create the table using data partitioning on the package delivery date.

Professional-Data-Engineer PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now Professional-Data-Engineer pdf
Get 60% Discount on All Products, Use Coupon: "8w52ceb345"
Next
You want to encrypt the customer data stored in BigQuery.
You work for a car manufacturer and have set up a data pipeline using Google...
Previous