Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 58 Topic 6 Discussion

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 58 Topic 6 Discussion

Professional-Data-Engineer Exam Topic 6 Question 58 Discussion:
Question #: 58
Topic #: 6

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‘


B.

bigquery-public-data.noaa_gsod.gsod*


C.

‘bigquery-public-data.noaa_gsod.gsod’*


D.

‘bigquery-public-data.noaa_gsod.gsod*`


Get Premium Professional-Data-Engineer Questions

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.