Google Looker LookML Developer Exam Practice Test

Page: 1 / 14
Total 50 questions

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?

A)

B)

C)

D)



Answer : A

Question 2

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 a measure that meets these requirements? (Choose two.)

B)

C)

D)

E)



Answer : A, C

Question 3

A user reports that, when a date dimension is filtered to ''before now'' results are returned that consistently include tomorrow. Dimension fill has been ruled out as a cause of the issue.

Which LookML parameter should be used to resolve this issue?



Answer : D

Question 4

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?



Answer : A

Question 5

Two developers are working on adding a new view to a project. Once both developers have finished their work in the view, the changes will be pushed to production.

Where should the developers write the LookML for this view?



Answer : C

Page:    1 / 14   
Total 50 questions