Which SQL keyword can be used to reduce the number of columns processed by BigQuery?

Which SQL keyword can be used to reduce the number of columns processed by BigQuery?
A . BETWEEN
B . WHERE
C . SELECT
D . LIMIT

View Answer

Answer: C

Explanation:

SELECT allows you to query specific columns rather than the whole table. LIMIT, BETWEEN, and WHERE clauses will not reduce the number of columns processed by BigQuery.

Reference: https://cloud.google.com/bigquery/launch­checklist#architecture_design_and_development_checklist