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 underlying database table does not have a field called sale_price.
• B. The discounted_sale_price field should be defined as a dimension of type: number, not as a measure.
• C. The discounted_sale_price field should have a group_by: yes parameter.
• D. The sale_price field should be defined as a measure of type: number, not as a dimension.

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. Option D
• B. Option A
• C. Option B
• D. Option C

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. Symmetric_aggregates: no is not present in the Explore definition.
• B. A unique primary key is defined in each view.
• C. No concatenated primary keys are used.
• D. The sum measure used is defined correctly.

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: [leadership]
• B. required_access_grants: [total_revenue]
• C. required_access_grants: [can_view_financial_data]
• D. required_access_grants: ["000","999"]

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. Build a user attribute filter into the Explore.
• B. Use index distribution_key or sort_key for this derived table.
• C. Persist the derived table.
• D. Use a conditional WHERE clause for Development Mode.