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 B. Since the issue is related to the data in the BigQuery data warehouse, it is best to check the status of the nightly job that recalculates and overwrites the table. Reviewing the job in the BigQuery interface allows you to verify if it completed successfully and identify any errors that might have caused the Data Studio charts to break. Options A, C, and D are not directly applicable to troubleshooting issues related to data processing jobs in BigQuery.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
As a Google Associate Cloud Engineer, you are tasked with visualizing data using Data Studio which pulls its data from a table in your BigQuery-based data warehouse. During the day, new data is appended to this table, and each night, the entire table is overwritten with a recalculated daily summary. Recently, you discovered that the charts in Data Studio have stopped functioning correctly. How should you approach analyzing and resolving this issue?
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.