Professional Data Engineer Exam - Question 9

Question

Your company is using WILDCARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error:

Which table name will make the SQL statement work correctly?

Examice · Accepted Answer

D
Reference:https://cloud. google. com/bigquery/docs/wildcard-tables.

Ender_H · Answer

None, the actual `bigquery-public-data.noaa_gsod.gsod*`
with back ticks at the beginning and at the end.

ABKR1300 · Answer

Few might go with the Option B which will be a blunder because of the below reason.

While querying the tables or views with the name, it is optional to surround with the backticks. But while querying the list of tables with Wild card character, it is must to surround with the backticks.

We can get the Syntax error: Expected end of input but got "*" with the below query

SELECT * FROM bigquery-public-data.noaa_gsod.gsod*
WHERE _TABLE_SUFFIX = "2024"

So, option D might be the correct one, provided if there is a typo.

Pavaan · Answer

Answer is 'D'
Reference : https://cloud.google.com/bigquery/docs/wildcard-table-reference

Enclose table names with wildcards in backticks
The wildcard table name contains the special character (*), which means that you must enclose the wildcard table name in backtick (`) characters.

dsyouness · Answer

bigquery-public-data.noaa_gsod.gsod*  also works

AWSandeep · Answer

D. 'bigquery-public-data.noaa_gsod.gsod*`

priluft · Answer

D. 'bigquery-public-data.noaa_gsod.gsod*`

Melampos · Answer

bigquery-public-data.noaa_gsod.gsod* works

Zosby · Answer

D is correct

hkhnhan · Answer

should be B, the backtick at D answer is wrong ' instead of `

hkhnhan · Answer

should be B, the backtick at D answer is wrong ' instead of `

vaga1 · Answer

let's forget the fact that in BQ is used ` instead than ' which retrieves an error in any case. ` is called backquote, backtick, or left quote while ' is simply an apostrophe. Let's consider ' to be ` in every answer, since moderators could have not been aware of such when they had received the question.

rtcpost · Answer

Option D (assuming to have backticks)

Refer: https://cloud.google.com/bigquery/docs/querying-wildcard-tables
The following query is NOT valid because it isn't properly quoted with backticks:
```
#standardSQL
/* Syntax error: Expected end of statement but got "-" at [4:11] */
SELECT
  max
FROM
  # missing backticks
  bigquery-public-data.noaa_gsod.gsod*
WHERE
  max != 9999.9 # code for missing data
  AND _TABLE_SUFFIX = '1929'
ORDER BY
  max DESC
```

axantroff · Answer

D. 'bigquery-public-data.noaa_gsod.gsod*` is the right answer with 1 typo

RT_G · Answer

Agree with others - Option D

RT_G · Answer

Reference: https://cloud.google.com/bigquery/docs/querying-wildcard-tables
The wildcard table name contains the special character (*), which means that you must enclose the wildcard table name in backtick (`) characters. For example, the following query is valid because it uses backticks:

#standardSQL
/* Valid SQL query */
SELECT
  max
FROM
  `bigquery-public-data.noaa_gsod.gsod*`
WHERE
  max != 9999.9 # code for missing data
  AND _TABLE_SUFFIX = '1929'
ORDER BY
  max DESC

Chintu_573 · Answer

IN option D, there is differert ' ` on first and last. That's why right option is second.

Professional Data Engineer Exam - Question 9

Discussion