Question

Which of the following operations in BigQuery reduce the total cost of ownership (TCO) for customers? (Choose 3 answers)

1. Queries retrieving results from the cache
2. Batch loading data into BigQuery from local files
3. Running a query on an external data source from BigQuery
4. Deleting a table, view, individual table partitions, and user-defined functions

Answer 1

The operations in BigQuery that reduce the total cost of ownership (TCO) for customers are:

Queries retrieving results from the cache.

Batch loading data into BigQuery from local files.

Deleting a table, view, individual table partitions, and user-defined functions.

Step-by-step explanation:

Queries retrieving results from the cache: When queries can be satisfied using cached results, it reduces the need to process the same data again, thereby saving on processing costs.

Batch loading data into BigQuery from local files: Loading data in batches is a cost-effective way as it optimizes the use of resources and minimizes processing overhead.

Deleting a table, view, individual table partitions, and user-defined functions: Cleaning up unnecessary or obsolete data and objects helps in efficient resource utilization and cost management.

Options 1, 2, and 4 contribute to reducing TCO in BigQuery.