Practice Test 3 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
What is the keyword in BigQuery standard SQL used when selecting from multiple tables with wildcard by their suffices?
A. _WILDCARD_SUFFIX
B. _TABLES_SUFFIX
C. _SUFFIX
D. _TABLE_SUFFIX
Answer: D.
Description:
To restrict the query so that it scans an arbitrary set of tables, use the _TABLE_SUFFIX pseudo column in the WHERE clause. The _TABLE_SUFFIX pseudo column contains the values matched by the table wildcard.
Answer D is the correct one. Other answers are incorrect because such keywords do not exist.
Source(s):
Bigquery – Querying wildcard tables: https://cloud.google.com/bigquery/docs/querying-wildcard-tables
Comments are closed, but trackbacks and pingbacks are open.