Google
PROFESSIONAL-DATA-ENGINEER · Question #63
Which SQL keyword can be used to reduce the number of columns processed by BigQuery?
The correct answer is C. SELECT. Explanation/Reference: 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.
Submitted by parkjh· Mar 30, 2026Designing data processing systems
Question
Which SQL keyword can be used to reduce the number of columns processed by BigQuery?
Options
- ABETWEEN
- BWHERE
- CSELECT
- DLIMIT
How the community answered
(30 responses)- A3% (1)
- B3% (1)
- C93% (28)
Explanation
Explanation/Reference: 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.
Topics
#query optimization#column pruning#BigQuery cost#SELECT clause
Community Discussion
No community discussion yet for this question.