PROFESSIONAL-DATA-ENGINEER · Question #198
PROFESSIONAL-DATA-ENGINEER Question #198: Real Exam Question with Answer & Explanation
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, th
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.
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:
Community Discussion
No community discussion yet for this question.