Google Exam Professional Data Engineer Topic 4 Question 64 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 64
Topic #: 4

[All Professional Data Engineer Questions]

You are using Google BigQuery as your data warehouse. Your users report that the following simple query is running very slowly, no matter when they run the query:

SELECT country, state, city FROM [myproject:mydataset.mytable] GROUP BY country

You check the query plan for the query and see the following output in the Read section of Stage:1:

What is the most likely cause of the delay for this query?

AUsers are running too many concurrent queries in the system

BThe [myproject:mydataset.mytable] table has too many partitions

CEither the state or the city columns in the [myproject:mydataset.mytable] table have too many
NULL values

DMost rows in the [myproject:mydataset.mytable] table have the same value in the country column, causing data skew

Show Suggested Answer

Suggested Answer: C

by Dalene at Jan 09, 2023, 01:26 PM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Marvel

10 hours ago

The query is slow because there are too many partitions in the table. The data is not distributed evenly, causing the system to work harder to process all the partitions.

upvoted 0 times

...