professional-cloud-data-engineer
Prepare and test your skills
Prepare and test your skills
Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.
An analytics team at an enterprise company runs complex multi-stage aggregation queries on BigQuery during peak business hours. Recently, several critical ad-hoc and dashboard queries have started failing with the following error:
Resources exceeded: Your project or organization exceeded the maximum disk and memory limit available for shuffle operations.
You need to diagnose and resolve these query execution failures while maintaining performance and optimizing compute capacity.
Which approach should you implement to resolve the shuffle limit error?
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.
StudyCerts
StudyCerts