Crucial Exams

GCP Professional Data Engineer Practice Question

You are refactoring a Cloud Composer DAG that uses BigQueryOperator to run a 50-TB aggregation query every night. When the DAG occasionally back-fills, the task starts immediately and consumes many on-demand slots during daytime business hours. You want the same SQL to run only when idle slots are available so that it does not count toward the project's concurrent interactive-query limit. Which BigQueryOperator argument and value should you configure to meet this requirement?

  • Set the operator's priority argument to "INTERACTIVE".

  • Set the operator's priority argument to "BATCH".

  • Set write_disposition to "WRITE_TRUNCATE".

  • Set maximum_bytes_billed to 0.

GCP Professional Data Engineer
Maintaining and automating data workloads
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot