LookML-Developer Exam Dumps - Google Looker certifications Questions and Answers

Page: 1 / 1

Questions 4

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?

Options:

Add measures to the transactions view of type: number to apply the required functions.

Change the existing measures in the transactions view to dimensions, and add measures of the different required types.

Create a constant for each measure so it can be reused across other areas of the LookML project.

Create native derived tables using transactions as the explore_source.

Buy Now

Questions 5

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.)

Options:

Apply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.

Modify the business users’ roles so they do nothave this model in their model set.

Combine the Explores into just a few Explores that each join to many views.

Apply the group_label parameter to organize the Explores under different headings.

Apply the fields parameter so that each Explore hasfewer fields in it.

Buy Now

Questions 6

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?