Winter Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

LookML-Developer PDF

$38.5

$109.99

3 Months Free Update

Add to Cart
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

LookML-Developer PDF + Testing Engine

$61.6

$175.99

3 Months Free Update

Add to Cart
  • Exam Name: Looker LookML Developer Exam
  • Last Update: Dec 5, 2024
  • Questions and Answers: 50
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

LookML-Developer Engine

$46.2

$131.99

3 Months Free Update

Add to Cart
  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included

LookML-Developer Practice Exam Questions with Answers Looker LookML Developer Exam Certification

Question # 6

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?

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.

Full Access
Question # 7

A developer needs to implement three persistent derived tables (PDTs) as described below.

The PDTs need to be refreshed after the daily ETL pipeline adds incremental loads to the underlying tables.

Each PDT is built off of one underlying table in the database (one PDT per table).

The underlying tables for each PDT are updated one after the other, and a new row is added to an ETL log table each time a table is updated.

Due to the unpredictable nature of the ETL pipeline, each PDT does not refresh at the same time from day to day.

Each PDT takes over an hour to build, and to save on compute costs each PDT should only be refreshed once per day.

How can the developer set up the PDTs according to these requirements?

A.

Create one datagroup tied to all three PDTs that runs when the total row count across all three tables changes.

B.

Create one datagroup tied to all three PDTs that parameterizes the view name for each PDT in the SQL trigger condition.

C.

Create three separate datagroups tied to three PDTs that run when each corresponding table’s row count changes.

D.

Create threeseparate datagroups tied to three PDTs that run when a new row is added to the ETL log table.

Full Access
Question # 8

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?

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.

Full Access
Question # 9

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?

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.

Full Access
Question # 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?

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.

Full Access
Question # 11

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?

A.

access_grant

B.

always_filter

C.

access_filter

D.

sql_always_where

Full Access
Question # 12

After running the Content Validator, a developer can seethe error “Unknown field”.

Which two changes could cause this issue? (Choose two.)

A.

View name was changed from users to customers.

B.

Field type was changed from number to string.

C.

Model name was changed from e_commerce to reporting.

D.

Explore label was changed from users to customers.

E.

Field name was changed from id to user_id.

Full Access
Question # 13

The code below shows a vieworder_items with its measures total_revenue and user_count

LookML-Developer question answer

Which code correctly represents a new measure that calculates average revenue per user?

A)

LookML-Developer question answer

B)

LookML-Developer question answer

C)

LookML-Developer question answer

D)

LookML-Developer question answer

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 14

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?

A.

A bare Git repository

B.

Multiple account HTTPS

C.

Single account HTTPS

D.

SSH

Full Access
Question # 15

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?

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.

Full Access