Google Cloud Associate Data Practitioner — Question 61

Your organization uses scheduled queries to perform transformations on data stored in BigQuery. You discover that one of your scheduled queries has failed. You need to troubleshoot the issue as quickly as possible. What should you do?

Answer options

• A. Navigate to the Logs Explorer page in Cloud Logging. Use filters to find the failed job, and analyze the error details.
• B. Set up a log sink using the gcloud CLI to export BigQuery audit logs to BigQuery. Query those logs to identify the error associated with the failed job ID.
• C. Request access from your admin to the BigQuery information_schema. Query the jobs view with the failed job ID, and analyze error details.
• D. Navigate to the Scheduled queries page in the Google Cloud console. Select the failed job, and analyze the error details.

Correct answer: D

Explanation

The correct answer is D because it allows you to directly access the Scheduled queries page, where you can easily find and examine the error details of the failed job. Option A, while useful, requires additional steps and may not directly lead to the specific scheduled query error. Options B and C involve querying logs and accessing information_schema, which are more complex and not as fast as checking the Scheduled queries page.