Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
To optimize BigQuery usage and reduce costs for data analysts, which two practices should you recommend?
A
Utilize the bq --dry_run command to estimate query costs before execution
bq --dry_run
B
Implement clustered tables to minimize data scanned
C
Refrain from using SELECT * to avoid scanning unnecessary data
SELECT *
D
Limit the use of partitioned tables to reduce complexity
E
Apply LIMIT clauses exclusively to non-clustered tables for efficiency
LIMIT
