LookML-Developer Looker LookML Developer Exam Questions and Answers

Questions 4

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

What is a scalable way to configure this caching logic?

Options:

Define 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.

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

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

Define 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.

Buy Now

Questions 5

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?

Options:

persist_with: “12 hours”

datagroup: 12_hours {

max_cache_age: “12 hours”

}

persist_for: “12 hours”

sql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;

Buy Now

Questions 6

A developer needs to add an Explore built off of the orders view, which surfaces only completed orders. An orders Explore exists that contains all order information. Fields from the orders view arealso referenced in other existing views such as ${orders.fieldname}.

How should developer define a new Explore for completed orders and keep all field references working correctly?