PROFESSIONAL-DATA-ENGINEER · Question #291
PROFESSIONAL-DATA-ENGINEER Question #291: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #291. The question stem and answer options stay visible for context.
Question
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 copy all the data to a new clustered table. What should you do?
Options
- ARe-create the table using data partitioning on the package delivery date.
- BImplement clustering in BigQuery on the package-tracking ID column.
- CImplement clustering in BigQuery on the ingest date column.
- DTier older data onto Cloud Storage files and create a BigQuery table using Cloud Storage as an external data source.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.