LookML-Developer Questions and Answers
Question # 1
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)
Question # 2
The code below shows a vieworder_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)
Question # 3
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 storemanagers. 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?
