Google Exam LookML-Developer Topic 2 Question 22 Discussion

Actual exam question for Google's Looker LookML Developer exam

Question #: 22
Topic #: 2

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?

AThe discounted_sale_price field should have a group_by: yes parameter.

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

CThe underlying database table does not have a field called sale_price.

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

Show Suggested Answer

Suggested Answer: B

by Stephaine at Jul 25, 2022, 08:32 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!