Google Looker LookML Developer LookML-Developer Exam Practice Test

A LookML developer builds a view that contains sensitive information. Only members of the Management group should have access to the view. The developer needs to restrict the view from appearing in the field picker for any Explore where it might be joined for users outside of the Management group.

Which LookML parameter should the developer use to meet this requirement?

A user reports an error message on an Explore: ''Non-unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum''.

What should the LookML developer check for in the joined views of the Explore?

The code below shows a view order_items with its measures total_revenue and user_count

Which code correctly represents a new measure that calculates average revenue per user?

A)

B)

C)

D)

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?

A LookML Developer is working with denormalized tables and needs to create a measure adding up the Order Shipping column in the table below:

A)

B)

C)

D)

A LookML developer finishes some LookML work and commits changes in their personal development branch. The developer is asked to Pull and Merge Other Changes.

What does this indicate?

After running the LookML Validator, a developer sees the following error message in the Looker development environment:

''Measures with Looker aggregations (sum, average, min, max, list types) may not reference other measures''.

What could be causing this error?