Google Exam LookML-Developer Topic 2 Question 10 Discussion

Actual exam question for Google's Looker LookML Developer exam

Question #: 10
Topic #: 2

The daily_forecast Explore used by the sales team needs to be cached for 24 hours. All other Explores used by the sales team need to be cached for one hour.

What is a scalable way to configure this caching logic?

ADefine two datagroups for the model. Apply persist_with at the model level with the datagroup for 1-hour caching, and apply persist_with to daily_forecast with the datagroup for 24-hour caching.

BDefine max_cache_age on daily_forecast Explores of 24 hours. Define max_cache_age on all other Explores for one hour.

CDefine two datagroups for the model. Create a persistent derived table (PDT) for the daily_forecast Explore, and apply datagroup_trigger to it using the datagroup for 24-hour caching.

DDefine for the model one datagroup that caches for 1 hour. Create a persistent derived table (PDT) for the daily_forecast Explore, and apply sql_trigger_value to it selecting the current date.

Show Suggested Answer

Suggested Answer: A

by Angella at May 07, 2022, 06:45 AM

Limited Time Offer

25%

Off

Get Premium LookML-Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!