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 Practice Questions with 160 Q&As
Updated Study Material | Instant Download | Detailed Answers and Explanations
Subscribe
Login
0 Comments