Winter Special Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

  1. Home
  2. Google
  3. Looker certifications
  4. LookML-Developer
  5. Looker LookML Developer Exam Questions and Answers

LookML-Developer Looker LookML Developer Exam Questions and Answers

Questions 4

A developer defines the following measure in the order_items view:

LookML-Developer Question 4

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

Adeveloper is connecting a LookML project to a remote Git repository. The developer wants to track which users are committing code changes, creating pull requests, or deploying to production when the different Git commands are initiated from within Looker.

Which type of Git connection should be utilized to meet this business requirement?

Options:

A.

A bare Git repository

B.

Multiple account HTTPS

C.

Single account HTTPS

D.

SSH

Buy Now
Questions 6

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?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 7

A developer wants tocreate a measure that shows the item count broken out by category. When a second, more granular dimension is added to the same query, the count broken out by category should still represent the original aggregation and be duplicated on each line. The business wants this “count” in “category” available in the Explore section without any additional work done by the end user. For example:

The Count column represents the count for each combination of Category and Item.

The Count in Category column represents the count for each Category only.

LookML-Developer Question 7

How can the developer address this need with a LookML object?

Options:

A.

Create a measure filtered on Category, and make the filter value controlled by a parameter.

B.

Calculate the measure using a derived table, and then join that derived table back into the Explore.

C.

Create a measure with type: sum_over_dimension, and make the dimension value controlled by a parameter.

D.

Calculate the overall count using table calculations in the Explore.

Buy Now
Exam Code: LookML-Developer
Exam Name: Looker LookML Developer Exam
Last Update: Dec 1, 2024
Questions: 50

PDF + Testing Engine

$66  $164.99
buy now LookML-Developer pdf + testing engine

Testing Engine

$50  $124.99
buy now LookML-Developer testing engine

PDF (Q&A)

$42  $104.99
buy now LookML-Developer pdf