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

Business users report that they are unable to build useful queries because the list of fields in the Explore is too long to find what they need.

Which three LookML options should a developer use to curate the business user's experience? (Choose three.)

A. Add a description parameter to each field with context so that users can search key terms.

B. Create a separate project for each business unit containing only the fields that the unit needs.

C. Add a group_label parameter to relevant fields to organize them into logical categories.

D. Use the hidden parameter to remove irrelevant fields from the Explore.

E. Use a derived table to show only the relevant fields.

A LookML developer creates a new model and a test dashboard from the model. The developer shares the link to the new dashboard with users, but the users report that all they see is the “Model Not Found” error.

What is a possible cause of this issue?

A. The developer has not pushed the new model to Production Mode.

B. The developer has not added users to the new model set.

C. The users do not have permission to access this dashboard.

D. The new model is missing an Explore definition.

A user needs to create a report that shows a count of all orders and of orders over $100. Which solution should the developer implement to meet these requirements?

A. An always_filter parameter

B. A front-end filter in the Explore

C. A sql_always_where parameter

D. A filtered measure

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.

Business users report that an ephemeral derived table tile on the dashboard is slow.

Information about the dashboard includes:

The dashboard filter is linked to the user attributes.

This tile usually takes approximately 5 minutes to complete running.

Which solution should be used to improve the dashboard load time?

A. Use a conditional WHERE clause for Development Mode.

B. Build a user attribute filter into the Explore.

C. Use index distribution_key or sort_key for this derived table.

D. Persist the derived table.

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?

A. Limit the filter suggestions using the suggestions parameter.

B. Add an always_filter parameter to restrict the filter suggestions.

C. Use an access_filter parameter to automatically apply filters.

D. Add persistence to the base view of the Explore.

A LookML developer has a transactions view with several measures that each perform complex calculations involving multiple fields. The LookML developer creates an Explore based on the transactions view. The product team wants to perform further functions on these measures, such as SUM, AVG, MIN, MAX, and RANK. The team wants these further functions to be performed at different levels of detail: weekly, monthly, and yearly.

How can the LookML developer model these requirements and minimize the amount of code rewriting?

A. Add measures to the transactions view of type: number to apply the required functions.

B. Change the existing measures in the transactions view to dimensions, and add measures of the different required types.

C. Create a constant for each measure so it can be reused across other areas of the LookML project.

D. Create native derived tables using transactions as the explore_source.

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. 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}} ;;

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