Users are complaining that BigQuery queries are running slower than usual. You suspect that the issue is related to slot contention. Where should you look to confirm this?

Open the BigQuery admin panel and review the slot usage and job history for the project.

Look at the Cloud Logging logs for BigQuery query errors.

Review the VPC flow logs for traffic to the BigQuery API.

Check the Cloud Monitoring dashboard for the BigQuery API latency metrics.

A user has submitted a long-running BigQuery query that is consuming many slots and slowing down other queries. You need to stop this query immediately to restore performance. What should you do?

Cancel the query from the BigQuery admin panel by selecting the job and clicking 'Cancel'.

Kill the user's session by revoking their IAM permissions.

Wait for the query to finish, as it will eventually release the slots.

Restart the BigQuery service to clear all running queries.

A data engineer receives a 'Quota exceeded' error when trying to run a BigQuery load job. What is the recommended first step to resolve this issue?

Request a quota increase from the Quotas page

Delete all tables in the dataset

Change the project's billing account

A Cloud Data Fusion pipeline is failing with a 'NullPointerException' in a Wrangler transform. You need to find the exact line of code or transformation that is causing the issue. What should you do?

Search Cloud Logging for logs from the Data Fusion instance, filtering by the pipeline name and the error type.

Review the source data to see if there are any null values that could cause the exception.

Check the Data Fusion UI for the pipeline's execution history, which shows the error but not the stack trace.

Rerun the pipeline with debug logging enabled to capture more details.

Your Dataflow pipeline is hitting the 'Cloud Dataproc' quota for 'Total CPU cores' during peak hours. You need to ensure the pipeline can run successfully during peak times without waiting for a quota increase. What should you do?

Schedule the pipeline to run at off-peak hours to avoid the quota limit.

Optimize the Dataflow pipeline to use fewer resources by adjusting the worker configuration and autoscaling settings.

Request a quota increase for 'Total CPU cores' in the IAM & Admin Quotas page.

Run the pipeline in a different region that has a higher quota.

Google CloudProfessional Data Engineer

Domain 5Objective 4

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

31questions here

7free pages

9concepts

~18%of the exam

Questions 11–15

11application · medium
Users are complaining that BigQuery queries are running slower than usual. You suspect that the issue is related to slot contention. Where should you look to confirm this?
Select an answer first
12application · medium
A user has submitted a long-running BigQuery query that is consuming many slots and slowing down other queries. You need to stop this query immediately to restore performance. What should you do?
Select an answer first
13foundation · easy
A data engineer receives a 'Quota exceeded' error when trying to run a BigQuery load job. What is the recommended first step to resolve this issue?
Select an answer first
14application · medium
A Cloud Data Fusion pipeline is failing with a 'NullPointerException' in a Wrangler transform. You need to find the exact line of code or transformation that is causing the issue. What should you do?
Select an answer first
15expert · hard
Your Dataflow pipeline is hitting the 'Cloud Dataproc' quota for 'Total CPU cores' during peak hours. You need to ensure the pipeline can run successfully during peak times without waiting for a quota increase. What should you do?
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.