Question 11

A LookML developer has a transactions view with several measures that each perform complex calculations involving multiple fields. The LookML developer creates an Explore based on the transactions view. The product team wants to perform further functions on these measures, such as SUM, AVG, MIN, MAX, and RANK. The team wants these further functions to be performed at different levels of detail: weekly, monthly, and yearly.
How can the LookML developer model these requirements and minimize the amount of code rewriting?
  • Question 12

    A developer defines the following measure in the order_items view:

    The code must validate without errors.
    Which action should the developer take?
  • Question 13

    A LookML Developer is working with denormalized tables and needs to create a measure adding up the Order Shipping column in the table below:

    A)

    B)

    C)

    D)
  • Question 14

    A LookML developer builds a view that contains sensitive information. Only members of the Management group should have access to the view. The developer needs to restrict the view from appearing in the field picker for any Explore where it might be joined for users outside of the Management group.
    Which LookML parameter should the developer use to meet this requirement?
  • Question 15

    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?