Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Google LookML-Developer - Looker LookML Developer Exam

Page: 2 / 2
Total 50 questions

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?

A.

An always_filter parameter

B.

A front-end filter in the Explore

C.

A sql_always_where parameter

D.

A filtered measure

Two developers are working on adding a new view to a project. Once both developers have finished their work in the view, the changes will be pushed to production.

Where should the developers write the LookML for this view?

A.

In the master branch, with both users writing to the branch

B.

In one user’s personal branch, with both users writing to the branch

C.

In a new shared branch created from the master branch

D.

In each of their personal branches, with each user writing code separately

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?

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.

After validating LookML code, a developer receives the following error message:

“Unknown or Inaccessible Field users.name”

What is causing this error?

A.

There is a missing join.

B.

The field is set to “hidden”.

C.

The join relationship is incorrect.

D.

The field uses incorrect SQL syntax.

A developer needs to add an Explore built off of the orders view, which surfaces only completed orders. An orders Explore exists that contains all order information. Fields from the orders view arealso referenced in other existing views such as ${orders.fieldname}.

How should developer define a new Explore for completed orders and keep all field references working correctly?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D