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

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

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments