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%

25 days ago

I think the delay is caused by data skew.

upvoted 0 times

...