Google Professional-Data-Engineer Question Answer
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?
Google Professional-Data-Engineer Summary
- Vendor: Google
- Product: Professional-Data-Engineer
- Update on: Jul 26, 2025
- Questions: 376
