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

Google LookML-Developer Looker LookML Developer Exam Exam Practice Test

Looker LookML Developer Exam Questions and Answers

Question 1

A LookML developer has written the following persistent derived table. It references orders_rollup, another persistent derived table that also rebuilds with the same SQL trigger value.

Which change is needed to guarantee that user_facts will always rebuild with the latest data from orders_rollup?

Options:

A.

Change the sql_trigger_value parameter of user_facts toselect the current date plus one hour, so it triggers an hour after orders_rollup.

B.

Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}

C.

Change the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.

D.

Change the orders_rollup view reference to the literal table name from the database’s scratch schema.

Question 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?

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.

Question 3

Business users reportthat an ephemeral derived table tile on the dashboard is slow.

Information about the dashboard includes:

The dashboard filter is linked to the user attributes.

This tile usually takes approximately 5 minutes to complete running.

Which solution should be used to improve the dashboard load time?

Options:

A.

Use a conditional WHERE clause for Development Mode.

B.

Build a user attribute filter into the Explore.

C.

Use index distribution_key or sort_key for this derived table.

D.

Persist the derived table.

Question 4

A developer wants to create a new Explore based on the order_items view. The developer creates an Explore in the ecommerce model file with the following definition:

explore: order_items {}

After saving and validations, the developer receives this LookML validator error:

Inaccessible view “inventory_items”, “inventory_items” is not accessible inexplore” “order_items”. Check for typos and missing joins in explore “order_items”.

What caused this error to appear?

Options:

A.

A field in the order_items view references a field in the inventory_items view.

B.

A field in the inventory_items view references a field in the order_items view.

C.

There is an Explore named inventory_items which references the order_items view.

D.

There is another Explore named order_items which references the inventory_items view.

Question 5

A user reports that a query run against the orders Explore takes a long time to run. The query includes only fields from the users view. Data for both views is updated in real time. The developer runs the following query in SQL Runner and quickly receives results:

SELECT * FROM users.

What should the developer do to improve the performance of the query in the Explore?

Options:

A.

Create an Explore with users as the base table.

B.

Create a persistent derived table from the user’s query.

C.

Create anephemeral derived table from the user’s query.

D.

Add persist_for: “24 hours” to the orders Explore.

Question 6

A LookML developer builds a view that contains sensitive information. Only members of the Management group should have access to the view. The developer needs to restrict the view from appearing in the field picker for any Explore where it might be joined for users outside of the Management group.

Which LookML parameter should the developer use to meet this requirement?

Options:

A.

access_grant

B.

always_filter

C.

access_filter

D.

sql_always_where

Question 7

Users viewing an Explore should be able to view rows of data only where the value of the product.brand column matches the value of the user’s company user attribute.

Which access filter should the developer use to meet this requirement?

A)

B)

C)

D)

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D