Looker LookML Developer Exam Real LookML-Developer Exam Questions

Page 1 of 1

1. A developer defines the following measure in the order_items view:

The code must validate without errors.

Which action should thedeveloper take?

Join order_items and inventory_items in a derived table.

Join order_items and inventory_items in the same Explore.

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

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

2. Users must be able to click on the Country field in their Explore and be redirected to another Explore that shows all countries compared.

Which parameter should be added to the country dimension to create a connection to this other associated Explore?

url_encode

drill_fields

tags

link

3. A developer creates a derived table and wants to add persistence to it. Because the table is not used on a frequent basis, the developer wants thetable to be cached for 12 hours, but only when a user has queried it.

Which persistence parameter should be added to the derived table’s definition in order to satisfy this use case?

persist_with: “12 hours”

datagroup: 12_hours { max_cache_age: “12 hours” }

persist_for: “12 hours”

sql_trigger_value: SELECT FLOOR {UNIX_TIMESTAMP {} / {6*60*60} };;

4. A user is seeing an error in the Explore that indicates the primary key defined for a one- million-row table is not unique.

How can the developer use SQL Runner to troubleshoot quickly?

Create a query that selects all the fields from the table, and sort by primary key.

Create a query that selects the primary key from the base view, and look forduplicates.

Create a query that counts how many occurrences of the primary key value are in the base view, and sort by count.

Create a query that concatenates two columns to create a compound primary key.

5. A user reports that, when a date dimension is filtered to “before now” results are returned that consistently include tomorrow. Dimension fill has been ruled out as a cause of the issue.

Which LookML parameter should be used to resolve this issue?

Week_start_day

Convert_tz

Datatype

Fiscal_month_offset

6. 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?

An always_filter parameter

A front-end filter in the Explore

A sql_always_where parameter

A filtered measure

Welcome To Choose Required IT Certification Exams Online

Looker LookML Developer Exam Real LookML-Developer Exam Questions

Before Getting Real LookML-Developer Exam Questions, You Are Recommended To Read LookML-Developer Free Questions For Checking.

Author