Your organization runs a mix of ad-hoc queries and scheduled ETL jobs in BigQuery. The scheduled jobs are critical and need predictable performance, but ad-hoc queries are causing contention. You want to ensure the scheduled jobs always have enough slots. What should you do?

Create a BigQuery reservation for the scheduled jobs and assign the appropriate project to it.

Increase the on-demand quota for BigQuery to allow more concurrent queries.

Use Cloud Scheduler to run the scheduled jobs at a different time when there is less contention.

Set up a Cloud Monitoring alert to notify you when slot usage is high, and then manually cancel ad-hoc queries.

A data engineer needs to ensure that a BigQuery project will have enough slots for an upcoming peak workload. Which approach is most appropriate to track and forecast slot consumption against the project's quota?

Review the BigQuery audit logs for all past queries

Monitor slot usage in Cloud Monitoring and compare it with the quota limit

Create a reservation with a fixed slot count

Enable the BigQuery Data Transfer Service

A batch job running on Dataproc is failing with an error that is not immediately clear. You need to find the exact error message and the stack trace to diagnose the issue. What should you do first?

Use Cloud Logging to search for logs from the Dataproc cluster, filtering by the job ID and severity to find the error and stack trace.

Rerun the job with the --debug flag to capture additional logging.

Check the Dataproc job details in the Cloud Console, which always shows the full stack trace for any failed job.

Open a support case with Google Cloud and provide the job ID.

Google CloudProfessional Data Engineer

Domain 5Objective 4

5.4 Monitoring and Troubleshooting Processes PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 1)

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 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

9concepts

~18%of the exam

Questions 1–5

1foundation · easy
Which Google Cloud feature allows exporting detailed billing data to BigQuery for custom cost analysis?
Select an answer first
2foundation · easy
A data engineer notices an unexpected charge on the monthly bill for a BigQuery project. Which tool should be used to analyze the cost breakdown by service and SKU?
Select an answer first
3application · medium
Your organization runs a mix of ad-hoc queries and scheduled ETL jobs in BigQuery. The scheduled jobs are critical and need predictable performance, but ad-hoc queries are causing contention. You want to ensure the scheduled jobs always have enough slots. What should you do?
Select an answer first
4foundation · easy
A data engineer needs to ensure that a BigQuery project will have enough slots for an upcoming peak workload. Which approach is most appropriate to track and forecast slot consumption against the project's quota?
Select an answer first
5application · medium
A batch job running on Dataproc is failing with an error that is not immediately clear. You need to find the exact error message and the stack trace to diagnose the issue. What should you do first?
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.4 Monitoring and Troubleshooting Processes PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 1)

Questions 1–5

Which Google Cloud feature allows exporting detailed billing data to BigQuery for custom cost analysis?

A data engineer notices an unexpected charge on the monthly bill for a BigQuery project. Which tool should be used to analyze the cost breakdown by service and SKU?

Your organization runs a mix of ad-hoc queries and scheduled ETL jobs in BigQuery. The scheduled jobs are critical and need predictable performance, but ad-hoc queries are causing contention. You want to ensure the scheduled jobs always have enough slots. What should you do?

A data engineer needs to ensure that a BigQuery project will have enough slots for an upcoming peak workload. Which approach is most appropriate to track and forecast slot consumption against the project's quota?

A batch job running on Dataproc is failing with an error that is not immediately clear. You need to find the exact error message and the stack trace to diagnose the issue. What should you do first?

Keep studying — Maintaining and automating data workloads