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

question 85

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 Google Cloud Storage files and create a BigQuery table using GCS as an external data source.
• D) Re-create the table using data partitioning on the package delivery date.

---

Definitions:

Epigenetics

The study of changes in organisms caused by modification of gene expression rather than alteration of the genetic code itself.

Maturation

The process of becoming mature, encompassing physical, mental, and emotional growth over time.

Authoritative Parents

A parenting style characterized by high demand and high responsiveness, where parents have expectations of maturity and responsibility from their children but also provide them with love and support.

Authoritarian Parents

Parents who impose strict rules, expect absolute obedience, and often use punishment to control behavior, with little to no negotiation or discussion.