Which scenario is most appropriate for using a batch query job?

A real-time fraud detection system that needs immediate alerts

A dashboard that loads data when a user opens it

A nightly data transformation job that processes large volumes of data

A user running an ad-hoc query in the BigQuery console and waiting for results

A retail company runs a nightly ETL process that aggregates sales data from the previous day into a BigQuery reporting table. The process must complete by 6:00 AM before the business opens. The data volume is large, but the team has flexible deadlines during the night. Currently, the process runs as interactive queries, causing contention with daytime workloads. The team wants to reduce cost and minimize impact on interactive users. What should they do?

Keep the queries as interactive but increase the slot capacity of the reservation.

Change the queries to batch priority and run them during the night shift.

Use BigQuery Omni to run the queries on another cloud provider.

Set the queries to batch priority and run them during the day when the reservation is idle.

Google CloudProfessional Data Engineer

Domain 5Objective 3

5.3 Organizing Workloads Based on Business Requirements PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 4)

Part of the Maintaining and automating data workloads domain, which accounts for ~18% of the PROFESSIONAL-DATA-ENGINEER exam. Google Cloud does not publish an official question count, but from its 120-minute exam (~50–80 total, ~9–14 in this domain), expect 2–3 from this objective — we provide 17 practice questions to prepare you well beyond it. (estimate)

17questions here

4free pages

6concepts

~18%of the exam

Questions 16–17

16foundation · easy
Which scenario is most appropriate for using a batch query job?
Select an answer first
17application · medium
A retail company runs a nightly ETL process that aggregates sales data from the previous day into a BigQuery reporting table. The process must complete by 6:00 AM before the business opens. The data volume is large, but the team has flexible deadlines during the night. Currently, the process runs as interactive queries, causing contention with daytime workloads. The team wants to reduce cost and minimize impact on interactive users. What should they do?
Select an answer first

Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to PROFESSIONAL-DATA-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-DATA-ENGINEER” is a trademark of its owner, used for identification only.

5.3 Organizing Workloads Based on Business Requirements PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 4)

Questions 16–17

Which scenario is most appropriate for using a batch query job?

Keep studying — Maintaining and automating data workloads