Looker LookML Developer Exam Questions and Answers
A developer has created a persistent derived table that tracks new or updated orders and they want to cache the results. The cache should be refreshed whenever some new order isavailable on the underlying datasource table my tablename or at least every 24 hours.
Which datagroup definition will refresh the cache as expected?
A)
B)
C)
D)
A developer commits changes after adding LookML for a new measure. Upon pulling from production, the developer notices the following lines in the LookML:
A user reports an errormessage on an Explore: “Non-unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum”.
What should the LookML developer check for in the joined views of the Explore?
Adeveloper is connecting a LookML project to a remote Git repository. The developer wants to track which users are committing code changes, creating pull requests, or deploying to production when the different Git commands are initiated from within Looker.
Which type of Git connection should be utilized to meet this business requirement?
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?
A)
B)
C)
D)
A developer has User Specific Time Zones enabled fora Looker instance, but wants to ensure that queries run in Looker are as performant as they can be. The developer wants to add a datatype: date parameter to all dimension_group definitions without time data in a table-based view, so that time conversions don’t occur for these fields.
How can the developer determine to which fields this parameter should be applied through SQL Runner?
A LookML developer has created a model with many Explores in it. Business users are having a difficult time locating the Explore they want in the long list displayed.
Which two actions can the LookML developer take to improve the user interface? (Choose two.)
