Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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_
B
Implement clustered tables to minimize data scanned
C
Refrain from using SELECT * to avoid scanning unnecessary data*
D
Limit the use of partitioned tables to reduce complexity
E
Apply LIMIT clauses exclusively to non-clustered tables for efficiency