Get Google LookML-Developer Exam Practice Questions - Real and Updated

Users viewing an Explore should be able to view rows of data only where the value of the product.brand column matches the value of the user's company user attribute.

Which access filter should the developer use to meet this requirement?

A)

B)

C)

D)

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?

A developer needs to build a new dimension that offers an age-based cohort representation of users.

Which LookML code should the developer use to meet the requirement?

A)

B)

C)

D)

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 developer is building an e-commerce Explore with the following datasets: orders and users. The business user needs to be able to answer questions about sellers and buyers within the same Explore. Each order in the orders table reports a buyer and seller ID. The users table has the detailed information about the individual buyer and seller.

How should the Explore be defined to meet this requirement?

A)

B)

C)

D)