You use a dataset in BigQuery for analysis. You want to provide third-party companies with access to the same dataset. You need to keep the costs of data sharing low and ensure that the data is…

The correct answer is B. Implement clustering in BigQuery on the package-tracking ID column. Explanation/Reference: By creating an authorized view one assures that the data is current and avoids taking more storage space (and cost) in order to share a dataset. B and D are not cost optimal and C does not guarantee that the data is kept updated. partitioning. Over time…

Submitted by lukas.cz· Mar 30, 2026Designing data processing systems

Question

You use a dataset in BigQuery for analysis. You want to provide third-party companies with access to the same dataset. You need to keep the costs of data sharing low and ensure that the data is current. Which solution should you choose?

Options

AImplement clustering in BigQuery on the ingest date column.
BImplement clustering in BigQuery on the package-tracking ID column.
CTier older data onto Cloud Storage files, and leverage extended tables.
DRe-create the table using data partitioning on the package delivery date.

How the community answered

(39 responses)

A
13% (5)
B
79% (31)
C
5% (2)
D
3% (1)

Explanation

Explanation/Reference: By creating an authorized view one assures that the data is current and avoids taking more storage space (and cost) in order to share a dataset. B and D are not cost optimal and C does not guarantee that the data is kept updated. partitioning. Over time, the query processing time has increased. You need to implement a change that would improve query performance in BigQuery. What Explanation/Reference:

Topics

#BigQuery data sharing#clustering#cost optimization#third-party access

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-DATA-ENGINEER Practice