LOOKML-DEVELOPER Online Practice Questions and Answers

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. Option A

B. Option B

C. Option C

D. Option D

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

A. Apply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.

B. Modify the business users’ roles so they do not have this model in their model set.

C. Combine the Explores into just a few Explores that each join to many views.

D. Apply the group_label parameter to organize the Explores under different headings.

E. Apply the fields parameter so that each Explore has fewer fields in it.

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. required_access_grants: [grant_b] in the revenue view, required_access_grants: [grant_a] in the total_revenue field

B. required_access_grants: [grant_a] in the revenue view, required_access_grants: [grant_a, grant_b] in the total_revenue field

C. required_access_grants: [grant_b] in the financial_data Explore, required_access_grants: [grant_a] in the total_revenue field

D. required_access_grants: [grant_a, grant_b] in the revenue view, required_access_grants: [grant_a] in the total_revenue field

The code below shows a view order_items with its measures total_revenue and user_count

Which code correctly represents a new measure that calculates average revenue per user?

A. Option A

B. Option B

C. Option C

D. Option 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. A filtered measure

B. The hidden parameter

C. The sql_always_where parameter

D. A relationship definition

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

B. drill_fields

C. tags

D. link

A LookML developer finishes some LookML work and commits changes in their personal development branch. The developer is asked to Pull and Merge Other Changes.

What does this indicate?

A. A change has been deployed to a shared branch.

B. A change has been committed in another developer's personal branch.

C. A change has been committed in another shared branch.

D. A change has been deployed to production.

A developer has the dimensions enrollment_month and graduation_month already defined in the view. Both were created as part of dimension_groups of type: time. The developer need to use these two dimensions in the sql_start and sql_end parameters of a dimension group of type: duration.

Which LookML should be used to calculate the number of month and years between enrollment month and graduation month?

A. Option A

B. Option B

C. Option C

D. Option D

A user reports that, when a date dimension is filtered to “before now” results are returned that consistently include tomorrow. Dimension fill has been ruled out as a cause of the issue.

Which LookML parameter should be used to resolve this issue?

A. Week_start_day

B. Convert_tz

C. Datatype

D. Fiscal_month_offset

A developer is defining the users table within a view file in Looker. The users table will be available as an individual Explore and it will also be joined into other Explores, such as the products Explore. The developer needs to limit the fields visible in the products Explore without affecting the visibility of the fields in the users Explore.

How should the developer meet this requirement?

A. Use the fields parameter at the join level for the products Explore to specify which fields should be included and leave the users Explore as is.

B. Create duplicate dimensions and measures, one for the users Explore and one for the products Explore, and use the hidden parameter to modify the visibility of the fields.

C. Create two view files for the users table. One view file will have all possible fields for the users Explore, and the other will have only the fields required for the products Explore.

D. Use the hidden parameter in the users view file for the fields that should not come over to the products Explore and leave the users Explore as is.