Practice Test 2 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
Data analysts are using Google Data Studio to build dashboards reading data from BigQuery as a data source. The CTO wants to minimize the costs of BigQuery queries run by dashboards. You suggested enabling predictive (pre-fetch) caching.
Which of the following will minimize the costs?
A. Restrict data fetch to be once every 24 hours and make sure Data Studio report has view credentials on the BigQuery dataset.
B. Enable pre-fetch caching for the report and make sure Data Studio report has view credentials on the BigQuery dataset.
C. Enable pre-fetch caching for the report and make sure Data Studio report is an owner on the BigQuery dataset.
D. Restrict data fetch to be once every 24 hours and make sure Data Studio report is an owner on the BigQuery dataset.
Answer C.
The predictive (pre-fetch) cache analyzes the dimensions, metrics, and filter controls contained in the report, and predicts the possible queries. Data Studio then executes those queries in the background and stores the responses in the predictive cache. When a query can’t be answered by the responsive cache, Data Studio tries to answer it using this predicted data. The predictive cache is limited in size, so it’s possible your report can issue queries not already contained in the cache. If the query can’t be answered by the predictive cache, Data Studio requests the data from the underlying data set.
Limitation: The predictive (pre-fetch) cache is only active for data sources that use owner’s credentials to access the underlying data.
Answer A is incorrect: Data Studio caching maximum period is 12 hours.
Answer B is incorrect: As stated in the description, owner credentials should be granted on data sets.
Answer D is incorrect: Same as A, data fetch caching maximum period is 12 hours.
Source(s):
Data Studio – Manage Data Freshness: https://support.google.com/datastudio/answer/7020039?hl=en
Comments are closed, but trackbacks and pingbacks are open.