Practice Test 2 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
You are using BigQuery as the data warehouse. Different departments are using BigQuery to read data. Upon checking the billing costs, you notice that there is a spike in running queries on BigQuery despite caching is enabled. You started scanning through the queries run on BigQuery trying to find out if some queries are not cached.
Which of the following can be reasons for queries not cached? (Choose 2)
A.
SELECT queries without asterisk (*).
B. Queries select from authorized views on archive tables.
C. Queries multiple tables use wildcard.
D. Jobs use destination tables.
Answers: C & D
Currently, cached results are not supported for queries against multiple tables using a wildcard even if the “Use Cached Results” option is checked. If you run the same wildcard query multiple times, you are billed for each query.
Query results are not cached when a destination table is specified in the job configuration, the GCP Console, the classic web UI, the command line, or the API.
Source(s):
BigQuery – Wildcards: https://cloud.google.com/bigquery/docs/querying-wildcard-tables BigQuery – Cached Results: https://cloud.google.com/bigquery/docs/cached-results
Comments are closed, but trackbacks and pingbacks are open.