Google Cloud Associate Cloud Engineer — Question 221

You are using Looker 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 Looker Studio are broken, and you want to analyze the problem. What should you do?

Answer options

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

Correct answer: D

Explanation

The correct answer is D because reviewing the BigQuery interface allows you to directly assess the nightly job's execution and identify any issues that may have occurred during the table overwrite process. Option A does not provide insights into the data refresh issue, while option B involves a tool that may not be necessary for this specific problem. Option C, while useful for error tracking, does not specifically relate to the nightly job that affects the charts in Looker Studio.