Topic 2 Question 10
Which SQL keyword can be used to reduce the number of columns processed by BigQuery?
BETWEEN
WHERE
SELECT
LIMIT
解説
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
コメント(4)
Answer : C
👍 7[Removed]2020/03/21Answer: C Description: Select can be used to only select few columns which will reduce query time and cost
👍 5[Removed]2020/03/28Obviously C
👍 2DivakarSes2020/09/01
シャッフルモード