Exam4Training

Which of these statements about BigQuery caching is true?

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

Exit mobile version