LookML-Developer Looker LookML Developer Exam Questions and Answers

Users must be able to click on the Country field in their Explore and be redirected to another Explore that shows all countries compared.

Which parameter should be added to the country dimension to create a connection to this other associated Explore?

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 the table 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 developer needs to build a new dimension that offers an age-based cohort representation of users.

Which LookML code should the developer use to meet the requirement?

A)

B)

C)

D)

A LookML developer creates an Explore that joins two views. The base view has information about users’ interactions with the support team. The joined view contains data about the users. The support team using this Explore feels overwhelmed by the amount of data this Explore shows them and decides to just look at open tickets.

What should the developer add to the Explore in the model to achieve these requirements?

A developer 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?

Users report that every time they change the filter on their Explore, the filters take a very long time to populate.

How can the developer improve the filtering experience with this Explore?

Users viewing an Explore should be able to view rows of data only where the value of the product.brand column matches the value of the user’s company user attribute.

Which access filter should the developer use to meet this requirement?

A)

B)

C)

D)

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 are also 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 retail company wants to limit who can see the financial information in their reports to executives and store managers. The LookML Developer creates a user attribute called leadership with the value “000” for executives and “999” for store managers. The developer creates three access grant objects and one dimension:

How should the developer ensure that only authorized users see the data in the Total Revenue dimension?

Only users with department attributes of Finance and Executive should be able to access the revenue view. Only users with the value of Executive for the department user attribute should be able to view the total_revenue field.

Given the code snippet below:

How should the required access grants be structured to set up this system of access?

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