Which table name will make the SQL statement work correctly?
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*`
Answer: D
Latest Professional Data Engineer Dumps Valid Version with 160 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments