Google Cloud Associate Cloud Engineer — Question 319

You are using Data Studio to visualize a table from your data warehouse that is built on top of BigQuery. Data is appended to the data warehouse during the day.
At night, the daily summary is recalculated by overwriting the table. You just noticed that the charts in Data Studio are broken, and you want to analyze the problem. What should you do?

Answer options

• A. Review the Error Reporting page in the Cloud Console to find any errors.
• B. Use the BigQuery interface to review the nightly job and look for any errors.
• C. Use Cloud Debugger to find out why the data was not refreshed correctly.
• D. In Cloud Logging, create a filter for your Data Studio report.

Correct answer: B

Explanation

The correct answer is B because reviewing the BigQuery interface will allow you to check the details of the nightly job that overwrites the table, making it the best option for identifying any issues. Option A is incorrect as it pertains to general errors rather than job-specific issues. Option C is not suitable since Cloud Debugger is not directly related to data refresh problems in Data Studio. Option D focuses on logging rather than investigating the job execution itself.