Trang chủ Professional Data Engineer 341 / 343
Quay lại bộ đề
Question #341 Topic 1
You monitor and optimize the BigQuery instance for your team. You notice that a particular daily report that uses a large JOIN operation is consistently slow. You want to examine the query's execution plan to identify potential performance bottlenecks within the JOIN as quickly as possible. What should you do?
A
Use the bg query --dry_run command to review the estimated number of bytes read and review query syntax.
B
Run a query on the INFORMATION_SCHEMA.JOBS_BY_PROJECT view filtering by the job_ID and analyze total_bytes_processed.
C
Review the BigQuery audit logs in Cloud Logging.
D
Leverage BigQuery's Query History view and analyze the execution graph.