Practice Test 4 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
Which of the syntax/statement for wildcard tables is true?
A. Wildcard tables are available only in standard sql.
B. Wildcard tables WHERE clause supports _TABLE_PREFIX and
_TABLE_SUFFIX pseudo column.
C. Below wildcard table syntax is correct –
‘bigquery-public-data.noaa_gsod.gsod*’
D. TABLE_DATE_RANGE() function can be used as a table wildcard to query multiple tables in legacy SQL
Correct answer is A, D.
Refer GCP documentation – https://cloud.google.com/bigquery/docs/reference/standard-sql/wildcard-table-reference
Option A is correct. Wildcard tables feature is only available in standard SQL. Users can query multiple tables using the wildcard character “*” which represents one or more tables.
Option B is incorrect. Wildcard table WHERE clause only supports _TABLE_SUFFIX pseudo column. Users can use this column in WHERE clause to filter the query.
Option C is incorrect. As the wildcard table name contains “*” character, the table name should be enclosed only with backticks(`). In the option above table, the name is enclosed with a single quote (‘) which will give an error.
Option D is correct. User can query multiple table in legacy SQL using TABLE_DATE_RANGE() and TABLE_DATE_RANGE_STRICT() function.
Comments are closed, but trackbacks and pingbacks are open.