Google Looker LookML Developer LookML-Developer Exam Questions

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)

B)

C)

D)

A developer would like to add a new dimension of type: yesno for the enabled column in their users table. The column is of type: string in the database and returns yes and no values.

How should the developer define the yesno dimension?

A)

B)

C)

D)

A developer wants to calculate the ratio of total sales from the orders view and total users from the users view.

Which two methods can be used to create a measure that meets these requirements? (Choose two.)

B)

C)

D)

E)

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