Examtopics

Professional Data Engineer

8
10

Topic 1 Question 9
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?
- 'bigquery-public-data.noaa_gsod.gsod'
- bigquery-public-data.noaa_gsod.gsod*
- 'bigquery-public-data.noaa_gsod.gsod'*
- 'bigquery-public-data.noaa_gsod.gsod*`
解説
Reference: https://cloud.google.com/bigquery/docs/wildcard-tables

ユーザの投票
コメント(9)
- None, the actual bigquery-public-data.noaa_gsod.gsod* with back ticks at the beginning and at the end.
  
  👍 19
  Ender_H2022/09/23
- 正解だと思う選択肢: D
  D. 'bigquery-public-data.noaa_gsod.gsod*`
  
  👍 2
  AWSandeep2022/09/02
- 正解だと思う選択肢: D
  D. 'bigquery-public-data.noaa_gsod.gsod*`
  
  👍 2
  priluft2022/09/06
シャッフルモード

8
10