Google
PROFESSIONAL-DATA-ENGINEER · Question #9
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 statem
The correct answer is D. `bigquery-public-data.noaa_gsod.gsod*`. Explanation/Reference: It follows the correct wildcard syntax of enclosing the table name in backticks and including the * wildcard character.
Submitted by omar99· Mar 30, 2026Building and operationalizing data processing systems
Question
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?
Options
- 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*
How the community answered
(50 responses)- A2% (1)
- B2% (1)
- C4% (2)
- D92% (46)
Explanation
Explanation/Reference: It follows the correct wildcard syntax of enclosing the table name in backticks and including the * wildcard character.
Topics
#BigQuery wildcard tables#_TABLE_SUFFIX#SQL syntax#backtick notation
Community Discussion
No community discussion yet for this question.