Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Data Engineer Exam - Topic 2 Question 1 Discussion

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 ageFROMbigquery-public-data.noaa_gsod.gsodWHEREage != 99AND_TABLE_SUFFIX = '1929'ORDER BYage DESCWhich table name will make the SQL statement work correctly?
D) 'bigquery-public-data.noaa_gsod.gsod*`
A) 'bigquery-public-data.noaa_gsod.gsod'
B) bigquery-public-data.noaa_gsod.gsod*
C) 'bigquery-public-data.noaa_gsod.gsod'*

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Micah
10 months ago
Not sure about this, seems like a tricky question!
upvoted 0 times
...
Corrie
10 months ago
Wait, isn't it supposed to be without quotes for the wildcard?
upvoted 0 times
...
Whitney
11 months ago
I think option B is the right choice.
upvoted 0 times
...
Milly
11 months ago
Definitely needs a wildcard in the table name!
upvoted 0 times
...
Lynette
11 months ago
The error is due to the incorrect syntax with AND_TABLE_SUFFIX.
upvoted 0 times
...
Mignon
11 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
11 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
11 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
11 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
11 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
11 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
11 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
...

Save Cancel