Google Professional Data Engineer Exam - Topic 2 Question 1 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 1
Topic #: 2

[All Professional Data Engineer Questions]

Your company is using WHILECARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error:

# Syntax error : Expected end of statement but got ''-'' at [4:11]

SELECT age

FROM

bigquery-public-data.noaa_gsod.gsod

WHERE

age != 99

AND_TABLE_SUFFIX = '1929'

ORDER BY

age DESC

Which table name will make the SQL statement work correctly?

A'bigquery-public-data.noaa_gsod.gsod'

Bbigquery-public-data.noaa_gsod.gsod*

C'bigquery-public-data.noaa_gsod.gsod'*

D'bigquery-public-data.noaa_gsod.gsod*`

Show Suggested Answer

Suggested Answer: D

by Nobuko at May 07, 2022, 03:39 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Micah

5 months ago

Not sure about this, seems like a tricky question!

upvoted 0 times

...

Corrie

6 months ago

Wait, isn't it supposed to be without quotes for the wildcard?

upvoted 0 times

...

Whitney

6 months ago

I think option B is the right choice.

upvoted 0 times

...

Milly

6 months ago

Definitely needs a wildcard in the table name!

upvoted 0 times

...

Lynette

6 months ago

The error is due to the incorrect syntax with AND_TABLE_SUFFIX.

upvoted 0 times

...

Mignon

6 months ago

I vaguely remember that using quotes can sometimes lead to issues in SQL. I wonder if option A could be the right choice since it doesn't have a wildcard.

upvoted 0 times

...

James

6 months ago

I think I saw a similar question where the wildcard was used correctly, but I can't recall if it was with or without the quotes.

upvoted 0 times

...

Shoshana

6 months ago

I remember practicing with wildcard tables, but I'm not sure if the table name should have quotes or not.

upvoted 0 times

...

Rupert

6 months ago

The error message mentions a syntax issue, which makes me think the wildcard needs to be formatted correctly. I feel like it's option B, but I'm not completely confident.

upvoted 0 times

...

Shakira

6 months ago

Hmm, this one seems a bit tricky. I'm not totally sure about the differences between the roles listed, so I'll need to think it through carefully.

upvoted 0 times

...

Ernie

6 months ago

Hmm, this seems like a tricky one. I'll need to think through the role of the load balancer and how it relates to the firewall requirements.

upvoted 0 times

...

Nada

6 months ago

This seems like a straightforward question about validity. I'll need to think carefully about the differences between reliability and validity to answer this correctly.

upvoted 0 times

...