Labour Day Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

Home > Google > Looker certifications > LookML-Developer

LookML-Developer Looker LookML Developer Exam Question and Answers

Question # 4

The code below shows a vieworder_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.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 5

The developer is creating an Explore that includes the product users, and orders views that will meet the following guidelines.

Joins between the orders and users views should not incur high performance costs.

Users of this Explore will primarily be looking at data from the orders view.

Users of this Explore should only be able to see orders from the retailer “Fashion.ly”.

The onlyfield the users need from the products view is product.name.

Which LookML should the developer use?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 6

A developer defines the following measure in the order_items view:

The code must validate without errors.

Which action should thedeveloper take?

A.

Join order_items and inventory_items in a derived table.

B.

Join order_items and inventory_items in the same Explore.

C.

Copy the cost definition from inventory_items to the order_items view file.

D.

Add the following to the order_itemsview file: include: “inventory_items,view.lkml”

Full Access
Question # 7

A developer needs to add an Explore built off of the orders view, which surfaces only completed orders. An orders Explore exists that contains all order information. Fields from the orders view arealso referenced in other existing views such as ${orders.fieldname}.

How should developer define a new Explore for completed orders and keep all field references working correctly?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access