Exam4Training

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

Exit mobile version