Google Cloud Professional Data Engineer PDE — Topic 1 Question 333

Question

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?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Leverage BigQuery's Query History view and analyze the execution graph. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage.

Google Cloud Professional Data Engineer PDE — Question 333