Google Exam Professional Data Engineer 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

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