Online Access Free LookML-Developer Exam Questions

A developer wants to create 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.Create a measure filtered on Category, and make the filter value controlled by a parameter.
• B.Create a measure with type: sum_over_dimension, and make the dimension value controlled by a parameter.
• C.Calculate the measure using a derived table, and then join that derived table back into the Explore.
• D.Calculate the overall count using table calculations in the Explore.

A developer is defining the users table within a view file in Looker. The users table will be available as an individual Explore and it will also be joined into other Explores, such as the products Explore. The developer needs to limit the fields visible in the products Explore without affecting the visibility of the fields in the users Explore.
How should the developer meet this requirement?

• A.Create two view files for the users table. One view file will have all possible fields for the users Explore, and the other will have only the fields required for the products Explore.
• B.Use the fields parameter at the join level for the products Explore to specify which fields should be included and leave the users Explore as is.
• C.Use the hidden parameter in the users view file for the fields that should not come over to the products Explore and leave the users Explore as is.
• D.Create duplicate dimensions and measures, one for the users Explore and one for the products Explore, and use the hidden parameter to modify the visibility of the fields.

Users report that the main dashboard has been slow to show results.
Which two options should the developer evaluate to improve dashboard performance? (Choose two.)

• A.Number of databases used by dashboard elements
• B.Format used to deliver these reports
• C.Number of queries used by the dashboard
• D.Amount of data rendered for each query
• E.Ratio of visualizations to text tiles

A user is seeing an error in the Explore that indicates the primary key defined for a one-million-row table is not unique.
How can the developer use SQL Runner to troubleshoot quickly?

• A.Create a query that selects all the fields from the table, and sort by primary key.
• B.Create a query that selects the primary key from the base view, and look for duplicates.
• C.Create a query that concatenates two columns to create a compound primary key.
• D.Create a query that counts how many occurrences of the primary key value are in the base view, and sort by count.

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 is based.
What should the developer build to meet the business requirement?

• A.A native derived table based on the dashboard.
• B.A link to the dashboard included in the project.
• C.A dashboard LookML file included in the project.
• D.An Explore LookML file based on the dashboard.