
Ultimate access to all questions.
In your role as a data engineer, you have created a crucial report for your large team using Google Data Studio 360. This report relies on Google BigQuery as its data source. Upon reviewing the report, you observe that the visualizations do not display data that is less than 1 hour old. How should you address this issue?
A
Disable caching by editing the report settings.
B
Disable caching in BigQuery by editing table details.
C
Refresh your browser tab showing the visualizations.
D
Clear your browser history for the past hour then reload the tab showing the visualizations.
Explanation:
The correct answer is A. By default, Google Data Studio 360 caches data to improve performance and reduce the number of queries made to the data source. However, this can cause visualizations to not show data that is less than 1 hour old because the cached data is not up-to-date. Disabling caching in the report settings will ensure that the visualizations are not using cached data and will reflect the most up-to-date information from your Google BigQuery data source. This can be done by opening the report, going to the 'File' menu, selecting 'Report settings', scrolling down to the 'Data' section, and toggling off the 'Enable cache' option. Disabling caching might increase the query load on the data source and affect report performance, so it is essential to consider the trade-off between performance and data accuracy.