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

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

LookML-Developer Sample Questions Answers

Questions 4

A developer has created a persistent derived table that tracks new or updated orders and they want to cache the results. The cache should be refreshed whenever some new order isavailable on the underlying datasource table my tablename or at least every 24 hours.

Which datagroup definition will refresh the cache as expected?

A)

B)

C)

D)

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Buy Now
Questions 5

A LookML developer has a transactions view with several measures that each perform complex calculations involving multiple fields. The LookML developer creates an Explore based onthe transactions view. The product team wants to perform further functions on these measures, such as SUM, AVG, MIN, MAX, and RANK. The team wants these further functions to be performed at different levels of detail: weekly, monthly, and yearly.

How can the LookML developer model these requirements and minimize the amount of code rewriting?

Options:

A.

Add measures to the transactions view of type: number to apply the required functions.

B.

Change the existing measures in the transactions view to dimensions, and add measures of the different required types.

C.

Create a constant for each measure so it can be reused across other areas of the LookML project.

D.

Create native derived tables using transactions as the explore_source.

Buy Now
Questions 6

A developer commits changes after adding LookML for a new measure. Upon pulling from production, the developer notices the following lines in the LookML:

Options:

A.

Remove “<<<<<< HEAD”, “======”, and “>>>>>> branch ‘master’”

B.

Remove “<<<<<< HEAD”, “======”, and everything following “======”

C.

Remove everything between “<<<<<< HEAD” and “======”, and “>>>>>> branch ‘master’”

D.

Remove everything between “<<<<<< HEAD” and “>>>>>> branch ‘master’”

Buy Now
Questions 7

The developer is creating an Explore that includes the product users, and orders views that will meet the following guidelines.

Joins between the orders and users views should not incur high performance costs.

Users of this Explore will primarily be looking at data from the orders view.

Users of this Explore should only be able to see orders from the retailer “Fashion.ly”.

The onlyfield the users need from the products view is product.name.

Which LookML should the developer use?

A)

B)

C)

D)

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Buy Now
Questions 8

Users report that every time they change the filter on their Explore, the filters take a very long time to populate.

How can the developer improve the filtering experience with this Explore?

Options:

A.

Limit the filter suggestions using the suggestions parameter.

B.

Add an always_filter parameter to restrict the filter suggestions.

C.

Use an access_filter parameter to automatically apply filters.

D.

Add persistence to the base view of the Explore.

Buy Now
Questions 9

A user reports an errormessage on an Explore: “Non-unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum”.

What should the LookML developer check for in the joined views of the Explore?

Options:

A.

The sum measure used is defined correctly.

B.

A unique primary key is defined in each view.

C.

Symmetric_aggregates: no is not present in the Explore definition.

D.

No concatenated primary keys are used.

Buy Now
Questions 10

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 11

The daily_forecast Explore used by the sales team needs to be cached for 24 hours. All other Explores usedby the sales team need to be cached for one hour.

What is a scalable way to configure this caching logic?

Options:

A.

Define two datagroups for the model. Apply persist_with at the model level with the datagroup for 1-hour caching, and apply persist_with to daily_forecast with the datagroup for 24-hour caching.

B.

Define max_cache_age on daily_forecast Explores of 24 hours. Define max_cache_age on all other Explores for one hour.

C.

Define two datagroups for the model. Create a persistent derived table (PDT) forthe daily_forecast Explore, and apply datagroup_trigger to it using the datagroup for 24-hour caching.

D.

Define for the model one datagroup that caches for 1 hour. Create a persistent derived table (PDT) for the daily_forecast Explore, and apply sql_trigger_value to it selecting the current date.

Buy Now
Questions 12

A developer is building an e-commerce Explore with the following datasets: orders and users. The business user needs to be able to answer questions about sellers and buyers within the same Explore. Each order in the orders table reports a buyer and seller ID. The users table has the detailed information about the individual buyer and seller.

How should the Explore be defined to meet this requirement?

A)

B)

C)

D)

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Buy Now
Questions 13

A LookML developer creates an Explore that joins two views. The base view has information about users’interactions with the support team. The joined view contains data about the users. The support team using this Explore feels overwhelmed by the amount of data this Explore shows them and decides to just look at open tickets.

What should the developer add to the Explore in the model to achieve these requirements?

Options:

A.

A filtered measure

B.

The hidden parameter

C.

The sql_always_where parameter

D.

A relationship definition

Buy Now
Questions 14

A LookML developer finishes some LookML work and commits changes in their personal development branch. The developer is asked to Pull and Merge Other Changes.

What does this indicate?

Options:

A.

A changehas been deployed to a shared branch.

B.

A change has been committed in another developer’s personal branch

C.

A change has been committed in another shared branch.

D.

A change has been deployed to production.

Buy Now
Questions 15

A LookML developer has created a model with many Explores in it. Business users are having a difficult time locating the Explore they want in the long list displayed.

Which two actions can the LookML developer take to improve the user interface? (Choose two.)

Options:

A.

Apply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.

B.

Modify the business users’ roles so they do nothave this model in their model set.

C.

Combine the Explores into just a few Explores that each join to many views.

D.

Apply the group_label parameter to organize the Explores under different headings.

E.

Apply the fields parameter so that each Explore hasfewer fields in it.

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