Which scenario is best suited for an interactive query job?

A data migration job that runs once

A dashboard that loads data when a user opens it

A scheduled report that runs every hour

A nightly ETL job that processes terabytes of data

What is a key characteristic of a batch query job in BigQuery?

It cannot be used with reservations

It has a lower priority and may wait for available slots

It runs immediately and returns results in seconds

It is only available with BigQuery Enterprise Plus

A company has a BigQuery reservation with 1000 slots. They have two departments: Sales runs interactive dashboards that need low latency, and Marketing runs large batch reports that can tolerate delays. The Sales team complains about slow queries during peak hours. The company wants to ensure Sales gets consistent performance without increasing overall slot capacity. What should they do?

Increase the slot capacity of the existing reservation to 1500 slots.

Use BigQuery BI Engine to accelerate Sales queries.

Create a separate reservation for Sales with a fixed slot allocation and assign the Marketing project to the original reservation.

Set all Marketing queries to batch priority.

A company wants to minimize BigQuery costs for a non-critical analytics workload that can tolerate slower query execution. Which slot capacity strategy is most appropriate?

Use on-demand pricing with no reservation

Create a small reservation with a low slot commitment

Use interactive queries to get faster results

Purchase a large slot commitment to ensure fast queries

Google CloudProfessional Data Engineer

Domain 5Objective 3

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

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 11–15

11foundation · easy
Which scenario is best suited for an interactive query job?
Select an answer first
12foundation · easy
A data engineer is selecting a BigQuery edition for a workload that requires the highest level of availability and the strongest performance guarantees, including automatic scaling of slots. Which BigQuery edition provides these capabilities?
Select an answer first
13foundation · easy
What is a key characteristic of a batch query job in BigQuery?
Select an answer first
14expert · hard
A company has a BigQuery reservation with 1000 slots. They have two departments: Sales runs interactive dashboards that need low latency, and Marketing runs large batch reports that can tolerate delays. The Sales team complains about slow queries during peak hours. The company wants to ensure Sales gets consistent performance without increasing overall slot capacity. What should they do?
Select an answer first
15foundation · easy
A company wants to minimize BigQuery costs for a non-critical analytics workload that can tolerate slower query execution. Which slot capacity strategy is most appropriate?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back 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 3)

Questions 11–15

Which scenario is best suited for an interactive query job?

A data engineer is selecting a BigQuery edition for a workload that requires the highest level of availability and the strongest performance guarantees, including automatic scaling of slots. Which BigQuery edition provides these capabilities?

What is a key characteristic of a batch query job in BigQuery?

A company wants to minimize BigQuery costs for a non-critical analytics workload that can tolerate slower query execution. Which slot capacity strategy is most appropriate?

Keep studying — Maintaining and automating data workloads