LOOKML-DEVELOPER Online Practice Questions and Answers

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

A. required_access_grants: [can_view_financial_data]

B. required_access_grants: [leadership]

C. required_access_grants: [“000”,“999”]

D. required_access_grants: [total_revenue]

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 user reports the following SQL error when selecting the discounted sale price field:

ERROR: column “order_items.sale_price”; must appear in the GROUP BY clause or be used in an

aggregate function.

The developer checks the field definition and finds it to be:

measure: discounted_sale_price {

type: number

sql: ${sale_price} * 0.8 ;;

}

The developer also finds the LookML definition of the sale_price field to be:

dimension: sale_price {

type: number

sql: ${TABLE}.sale_price ;;

}

What is the likely cause of the SQL error?

A. The discounted_sale_price field should have a group_by: yes parameter.

B. The sale_price field should be defined as a measure of type: number, not as a dimension.

C. The underlying database table does not have a field called sale_price.

D. The discounted_sale_price field should be defined as a dimension of type: number, not as a measure.

A LookML developer is creating a new view with 20 dimensions in Development Mode using the Create View from Table functionality. Now users want the developer to add only four dimensions from this new view to an existing Explore.

What can the developer add to the Explore to limit the number of fields from the view that are accessible to the user in the Explore?

A. Set definition

B. Join condition

C. Fields parameter

D. Hidden parameter

A user reports an error message 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?

A. The sum measure used is defined correctly.

B. A unique primary key is defined in each view.

C. Symmetric_aggregates: no is not present in the Explore definition.

D. No concatenated primary keys are used.

The developer is creating an Explore that includes the product users, and orders views that will meet the following guidelines.

Joins between the orders and users views should not incur high performance costs.

Users of this Explore will primarily be looking at data from the orders view.

Users of this Explore should only be able to see orders from the retailer “Fashion.ly”.

The only field the users need from the products view is product.name.

Which LookML should the developer use?

A. Option A

B. Option B

C. Option C

D. Option D

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

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 builds a view that contains sensitive information. Only members of the Management group should have access to the view. The developer needs to restrict the view from appearing in the field picker for any Explore where it might be joined for users outside of the Management group.

Which LookML parameter should the developer use to meet this requirement?

A. access_grant

B. always_filter

C. access_filter

D. sql_always_where