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?
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?
B
A developer is connecting a LookML project to a remote Git repository. The developer wants to track which users are
committing code changes, creating pull requests, or deploying to production when the different Git commands are initiated
from within Looker.
Which type of Git connection should be utilized to meet this business requirement?
D
Explanation:
Reference: https://docs.looker.com/data-modeling/getting-started/version-control-and-deploying-changes
Only users with department attributes of Finance and Executive should be able to access the revenue view. Only users with
the value of Executive for the department user attribute should be able to view the total_revenue field.
Given the code snippet below:
How should the required access grants be structured to set up this system of access?
B
A developer creates a derived table and wants to add persistence to it. Because the table is not used on a frequent basis,
the developer wants the table to be cached for 12 hours, but only when a user has queried it.
Which persistence parameter should be added to the derived tables definition in order to satisfy this use case?
A
Explanation:
Reference: https://docs.looker.com/data-modeling/learning-lookml/caching
A developer needs to build a new dimension that offers an age-based cohort representation of users.
Which LookML code should the developer use to meet the requirement?
B
After running the LookML Validator, a developer sees the following error message in the Looker development environment:
Measures with Looker aggregations (sum, average, min, max, list types) may not reference other measures.
What could be causing this error?
A
Explanation:
Reference: https://help.looker.com/hc/en-us/articles/360038371614--Error-Measures-with-Looker-Aggregations-Sum-
Average-Min-Max-List-Types-May-Not-Reference-Other-Measures
Users report that the main dashboard has been slow to show results.
Which two options should the developer evaluate to improve dashboard performance? (hoose two.)
B C
Explanation:
Reference: https://help.looker.com/hc/en-us/articles/360038233334-Considerations-When-Building-Performant-Looker-
Dashboards
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.)
B C
A developer wants to create a new Explore based on the order_items view. The developer creates an Explore in the
ecommerce model file with the following definition:
explore: order_items {}
After saving and validations, the developer receives this LookML validator error:
Inaccessible view inventory_items, inventory_items is not accessible in explore order_items. Check for typos and
missing joins in explore order_items.
What caused this error to appear?
A