Which of these statements about BigQuery caching is true?
A . By default, a query’s results are not cached.
B . BigQuery caches query results for 48 hours.
C . Query results are cached even if you specify a destination table.
D . There is no charge for a query that retrieves its results from cache.
Answer: D
Explanation:
When query results are retrieved from a cached results table, you are not charged for the query.
BigQuery caches query results for 24 hours, not 48 hours.
Query results are not cached if you specify a destination table.
A query’s results are always cached except under certain conditions, such as if you specify a destination table.
Reference: https://cloud.google.com/bigquery/querying-data#query-caching
Latest Professional Data Engineer Dumps Valid Version with 160 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund