1. Home
  2. Discussions
  3. Google
  4. Looker certifications
  5. LookML-Developer Discussions
  6. LookML-Developer Exam Topic 2 Question 15 Discussion

Google Looker LookML Developer Exam LookML-Developer Question # 15 Topic 2 Discussion

 Google Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous

Google Looker LookML Developer Exam LookML-Developer Question # 15 Topic 2 Discussion

LookML-Developer Exam Topic 2 Question 15 Discussion:
Question #: 15
Topic #: 2

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, andjoin 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.

Get Premium LookML-Developer Questions
Actual exam question for Google LookML-Developer exam by Flint26537 at Aug 2, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous