Exam Professional Data Engineer topic 1 question 4 discussion

A. Disable caching by editing the report settings. By default, Google Data Studio 360 caches data to improve performance and reduce the amount of queries made to the data source. However, this can cause visualizations to not show data that is less than 1 hour old, as the cached data is not up-to-date. To resolve this, you should disable caching by editing the report settings. This can be done by following these steps: Open the report in Google Data Studio 360. Click on the "File" menu in the top left corner of the screen. Select "Report settings" from the dropdown menu. In the "Report settings" window, scroll down to the "Data" section. Toggle off the "Enable cache" option. Click the "Save" button to apply the changes. Disabling caching ensures that the data shown in the visualizations is always up-to-date, but it may increase the query load on the data source and affect the report's performance. Therefore, it's important to consider the trade-off between performance and data accuracy when making this change.

To ensure that Google Data Studio visualizations show the most recent data, you should disable caching within Data Studio's report settings.

A. Disable caching by editing the report settings. By default, Google Data Studio 360 caches data to improve performance and reduce the amount of queries made to the data source. However, this can cause visualizations to not show data that is less than 1 hour old, as 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 will allow your report to show data that is less than 1 hour old. Caching is often used for performance optimization, but it can result in delays in displaying real-time or near-real-time data, so disabling it is the appropriate action in this case.

disable caching in report setting will get the issue resolved

The solution from the site is perfect.

what is relevant here is to uncache Data Studio

A. Disable caching by editing the report settings. Data Studio 360 uses caching to speed up report loading times. When caching is enabled, Data Studio 360 will only show the data that was present in the data source at the time the report was loaded. To ensure that the visualizations in your report are always up-to-date, you should disable caching by editing the report settings. This will force Data Studio 360 to retrieve the latest data from the data source (in this case BigQuery) every time the report is loaded. Option B is incorrect as it would only disable caching in BigQuery, but it wouldn't affect the caching in Data Studio 360, so the visualizations would still not show the latest data. Option C and D will not help as the data is not being updated in Data Studio 360, it's just the cache that needs to be updated.

I'm confused, is it possible that the cache is in BigQuery level? and the looker just get the cache from bigquery

Based on the doc, you can refresh the report using refresh button on the report, not the browser's refresh button. So the answer is A.

On my opinion it's C, because Data Studio doesn't support the Real-Time dashboard updates, so it means that if caching will be disabled, user will be forced to update the dashboard manually, otherwise report will be stuck on the data from the last update. According to documentation https://support.google.com/looker-studio/answer/7020039?hl=en#zippy=%2Cin-this-article, if we want to keep the data fresh we need to setup caching with minimum value of 15 minites - it means that data in the report will be updated automatically wvery 15 minutes, if cache will be disabled completely then the report will be stuck until we will manually update it. So, tbh for me it doesn't make sense to disable cache.

C. Since the data is not always stale. When it is, click on refresh button. Document also says the same Refresh report data manually Report editors can refresh the cache at any time: View or edit the report. In the top right, click More options. and then click RefreshRefresh data . This refreshes the cache for every data source added to the report.

https://support.google.com/looker-studio/answer/7020039?hl=en#zippy=%2Cin-this-article

A. should be correct. after disabled the cache, it will retrieve data every time.

Same question from a Cloud guru and answer was C. The wording is slightly different in the documentation but still, the idea is that you can trigger a manual refresh

A. Disable caching by editing the report settings.