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 are also 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. Option A

B. Option B

C. Option C

D. Option D

A user needs to create a report that shows a count of all orders and of orders over $100. Which solution should the developer implement to meet these requirements?

A. An always_filter parameter

B. A front-end filter in the Explore

C. A sql_always_where parameter

D. A filtered measure

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. Option A

B. Option B

C. Option C

D. Option D

A developer needs to model out LookML to convert existing reports into Looker. The existing reports are:

Report 1: A report with order and order_items data, which finds the order with the largest total value of the order_item prices. Report 2: A report with order and order_items data, which finds the order with the largest total number of

products ordered.

Report 3: A report with data on every product, whether or not it has been ordered.

Each database table used is updated in real time as orders are made.

How should the developer construct an Explore using the order_items view as the base view?

A. Create one persistent derived table to calculate Report 1, create one persistent derived table to calculate Report 2, and join in the products view with a full_outer join.

B. Create one persistent derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.

C. Create one ephemeral derived table to calculate Report 1, create one ephemeral derived table to calculate Report 2, and join in the products view with a left_outer join.

D. Create one ephemeral derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.

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. Option A

B. Option B

C. Option C

D. Option D