Google LookML-Developer Exam Questions Instant Access

Question 1

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 to use 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?

AOption A

BOption B

COption C

DOption D

Answer : A

Question 2

A LookML developer is creating a new view with 20 dimensions in Development Mode using the Create View from Table functionality. Now users want the developer to add only four dimensions from this new view to an existing Explore.

What can the developer add to the Explore to limit the number of fields from the view that are accessible to the user in the Explore?

ASet definition

BJoin condition

CFields parameter

DHidden parameter

Answer : B

Question 3

Users must be able to click on the Country field in their Explore and be redirected to another Explore that shows all countries compared.

Which parameter should be added to the country dimension to create a connection to this other associated Explore?

Aurl_encode

Bdrill_fields

Ctags

Dlink

Answer : D

Question 4

Business users report that they are unable to build useful queries because the list of fields in the Explore is too long to find what they need.

Which three LookML options should a developer use to curate the business user's experience? (Choose three.)

AAdd a description parameter to each field with context so that users can search key terms.

BCreate a separate project for each business unit containing only the fields that the unit needs.

CAdd a group_label parameter to relevant fields to organize them into logical categories.

DUse the hidden parameter to remove irrelevant fields from the Explore.

EUse a derived table to show only the relevant fields.

Answer : A, C, E

Question 5

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?

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

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

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

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

Answer : A

Question 6

A developer would like to add a new dimension of type: yesno for the enabled column in their users table. The column is of type: string in the database and returns yes and no values.

How should the developer define the yesno dimension?