March Special Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia

LookML-Developer Sample Questions Answers

Questions 4

A developer defines the following measure in the order_items view:

The code must validate without errors.

Which action should thedeveloper take?

Options:

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”

Buy Now
Questions 5

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?

Options:

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.

Buy Now
Questions 6

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?

Options:

A.

A measure of type: count has a sql parameter defined.

B.

A measure of type: sum adds up other measures in the sql parameter.

C.

A measure of type: sum has a SUM function written in the sql parameter.

D.

A measure of type: number has a SUM function written in the sql parameter.

Buy Now
Questions 7

A user reports the following SQL error when selecting the discounted sale price field:

ERROR: column “order_items.sale_price”; must appear in the GROUP BY clause or be used in an aggregate function.

The developer checks the field definition and finds it to be:

measure: discounted_sale_price {

type: number

sql: ${sale_price} * 0.8 ;;

}

The developer also finds the LookML definition of the sale_price field to be:

dimension: sale_price {

type: number

sql: ${TABLE}.sale_price ;;

}

What isthe likely cause of the SQL error?

Options:

A.

The discounted_sale_price field should have a group_by: yes parameter.

B.

The sale_price field should be defined as a measure of type: number, not as a dimension.

C.

The underlying database table does not have a fieldcalled sale_price.

D.

The discounted_sale_price field should be defined as a dimension of type: number, not as a measure.

Buy Now
Exam Code: LookML-Developer
Exam Name: Looker LookML Developer Exam
Last Update: Mar 25, 2024
Questions: 50
$64  $159.99
$48  $119.99
$40  $99.99
buy now LookML-Developer