Exam4Training

Which persistence parameter should be added to the derived table’s definition in order to satisfy this use case?

A developer creates a derived table and wants to add persistence to it. Because the table is not used on a frequent basis, the developer wants thetable to be cached for 12 hours, but only when a user has queried it.

Which persistence parameter should be added to the derived table’s definition in order to satisfy this use case?
A . persist_with: “12 hours”
B . datagroup: 12_hours {
max_cache_age: “12 hours”
}
C . persist_for: “12 hours”
D . sql_trigger_value: SELECT FLOOR {UNIX_TIMESTAMP {} / {6*60*60} };;

Answer: A

Explanation:

Reference: https://docs.looker.com/data-modeling/learning-lookml/caching

Exit mobile version