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