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/launchchecklist#architecture_design_and_development_checklist
Latest Professional Data Engineer Practice Questions with 160 Q&As
Updated Study Material | Instant Download | Detailed Answers and Explanations
Subscribe
Login
0 Comments