nerdexam
GoogleGoogle

PROFESSIONAL-DATA-ENGINEER · Question #63

PROFESSIONAL-DATA-ENGINEER Question #63: Real Exam Question with Answer & Explanation

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, 2026

Question

Which SQL keyword can be used to reduce the number of columns processed by BigQuery?

Options

  • ABETWEEN
  • BWHERE
  • CSELECT
  • DLIMIT

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.

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-DATA-ENGINEER PracticeBrowse All PROFESSIONAL-DATA-ENGINEER Questions