Answer-first summary for fast verification
Answer: Retrieving query results from cache incurs no charges.
When query results are fetched from a cached results table, BigQuery does not charge for the query. The cache duration is actually 24 hours, not 48. Caching is bypassed if a destination table is specified. Generally, query results are cached unless specific conditions, like specifying a destination table, are met. For more details, refer to [BigQuery Querying Data Guide](https://cloud.google.com/bigquery/querying-data#query-caching).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which statement accurately describes BigQuery caching?
A
BigQuery does not cache query results by default.
B
Query results are cached for a duration of 48 hours in BigQuery.
C
Specifying a destination table prevents BigQuery from caching the query results.
D
Retrieving query results from cache incurs no charges.
No comments yet.