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

Google Exam Professional-Data-Engineer Topic 2 Question 1 Discussion

Actual exam question for Google's Google Cloud Certified Professional Data Engineer exam
Question #: 1
Topic #: 2
[All Google Cloud Certified 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

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel