A developer wants tocreate a measure that shows the item count broken out by category. When a second, more granular dimension is added to the same query, the count broken out by category should still represent the original aggregation and be duplicated on each line. The business wants this “count” in “category” available in the Explore section without any additional work done by the end user. For example:
The Count column represents the count for each combination of Category and Item.
The Count in Category column represents the count for each Category only.
How can the developer address this need with a LookML object?
A developer wants to calculate the ratio of total sales from the orders view and total users from the users view.
Which two methods can be used to create ameasure that meets these requirements? (Choose two.)
A)
B)
C)
D)
E)
Users have built a popular dashboard and want to have change management built in for any edits made to the dashboard. The developer sets up version control for the model on which the dashboard isbased.
What should the developer build to meet the business requirement?
Business users reportthat 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 LookML developer has a transactions view with several measures that each perform complex calculations involving multiple fields. The LookML developer creates an Explore based onthe 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?
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.)
A developer has the dimensions enrollment_month and graduation_month already defined in the view. Both were created as part of dimension_groups of type: time. The developer need touse these two dimensions in the sql_start and sql_end parameters of a dimension group of type: duration.
Which LookML should be used to calculate the number of month and years between enrollment month and graduation month?
A)
B)
C)
D)
TESTED 21 Feb 2025
