Which of these statements about BigQuery caching is true?

The correct answer is D. There is no charge for a query that retrieves its results from cache. Explanation/Reference: 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…

Submitted by akirajp· Mar 30, 2026Building and operationalizing data processing systems

Question

Which of these statements about BigQuery caching is true?

Options

ABy default, a query's results are not cached.
BBigQuery caches query results for 48 hours.
CQuery results are cached even if you specify a destination table.
DThere is no charge for a query that retrieves its results from cache.

How the community answered

(26 responses)

B
4% (1)
C
4% (1)
D
92% (24)

Explanation

Explanation/Reference: 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

Topics

#BigQuery caching#query cache#cost optimization

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-DATA-ENGINEER Practice