LookML-Developer Exam Dumps : Looker LookML Developer Exam

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 onlyfield the users need from the products view is product.name.

Which LookML should the developer use?

A)

B)

C)

D)

A developer has created a persistent derived table that tracks new or updated orders and they want to cache the results. The cache should be refreshed whenever some new order isavailable on the underlying datasource table my tablename or at least every 24 hours.

Which datagroup definition will refresh the cache as expected?

A)

B)

C)

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 isthe likely cause of the SQL error?