A Shipping Company Has Live Package-Tracking Data That Is Sent

question 207

Multiple Choice

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.

---

Definitions:

Advertising Outlets

The various channels or platforms through which advertisements are delivered to potential customers, such as television, radio, print media, and online platforms.

Niche Media

Channels that are focused and generally used to reach narrow segments, often with unique demographic characteristics or interests.

Mass Media

Diverse media technologies that reach a large audience via mass communication, including broadcasting, publishing, and the internet.

Direct Mail

A marketing strategy that involves sending promotional materials or products directly to potential customers through the mail.