Ultimate access to all questions.
You've observed that some charts in your Data Studio dashboard are not displaying correctly. This dashboard is connected to a BigQuery table, which is updated throughout the day with new data. A nightly job then recalculates the daily summary and overwrites the table. What steps should you take to identify and resolve the issue?
Explanation:
Option B is the correct approach because the issue likely stems from the data refresh process in BigQuery. Reviewing the nightly job in BigQuery allows you to directly identify any errors or issues that may have caused the dashboard charts to break. This method is the most targeted and effective for diagnosing problems related to data refresh and integrity. Options A, C, and D are less relevant or effective for this specific scenario, as they either do not directly address the data refresh issue or are not applicable to the context of Data Studio and BigQuery integration.