Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Discussions
  3. Google
  4. Google Cloud Certified
  5. Professional-Data-Engineer Discussions
  6. Professional-Data-Engineer Exam Topic 3 Question 23 Discussion
 Google Discussions
Exam Professional-Data-Engineer All Questions
Exam Professional-Data-Engineer All Questions

View all questions & answers for the Professional-Data-Engineer exam

Go to Exam

Google Cloud Certified Professional-Data-Engineer Question # 23 Topic 3 Discussion

Professional-Data-Engineer Exam Topic 3 Question 23 Discussion:
Question #: 23
Topic #: 3

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:

Professional-Data-Engineer Question 23

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

Users are running too many concurrent queries in the system

B.

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

C.

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

NULL values

D.

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

Get Premium Professional-Data-Engineer Questions
Actual exam question for Google Professional-Data-Engineer exam by Quill62311 at May 1, 2026, 7:27:10 PM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit