Practice Test 1 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
You are using BigQuery as the data warehouse. Data analysts & scientists run queries to get data from BigQuery. When you checked the billing costs for the previous month, you noticed a spike in running queries on BigQuery despite caching is enabled. You tried to find out the reason for the spike by reading some of the queries data analysts and scientists are running on BigQuery.
Which of the following can be reasons for queries not cached? (Choose 2)
A. Queries use current_timestamp function.
B. SELECT queries with asterisk (*).
C. Queries select from authorized views on archive tables.
D. Querying multiple tables using a wildcard.
Answers: A & 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.
If the query uses non-deterministic functions; for example, date and time functions such as CURRENT_TIMESTAMP() and NOW(), and other functions such as CURRENT_USER() return different values depending on when a query is executed
URL: Please refer to
https://cloud.google.com/bigquery/docs/cached-results#cache-exceptions
Comments are closed, but trackbacks and pingbacks are open.