Answer-first summary for fast verification
Answer: Use the BigQuery interface to review the nightly job and look for any errors.
The correct answer is D. Using the BigQuery interface to review the nightly job helps you directly identify any errors that occurred during the data recalculation process, which is crucial since the data appended during the day could impact the final summary table. This approach allows you to analyze the data pipeline and debug the issue effectively at its source.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are utilizing Looker Studio to create visualizations from a table stored in your data warehouse, which is powered by BigQuery. Throughout the day, new data is appended to this data warehouse. Each night, a process runs that recalculates the daily summary and overwrites the table with the updated summary. Recently, you observed that the charts in Looker Studio are no longer functioning correctly. How should you approach analyzing and resolving this issue?
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.