Labour Day Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 2493360325

Good News !!! LookML-Developer Looker LookML Developer Exam is now Stable and With Pass Result

LookML-Developer Practice Exam Questions and Answers

Looker LookML Developer Exam

Last Update 11 hours ago
Total Questions : 50

LookML-Developer is stable now with all latest exam questions are added 11 hours ago. Just download our Full package and start your journey with Google Looker LookML Developer Exam certification. All these Google LookML-Developer practice exam questions are real and verified by our Experts in the related industry fields.

LookML-Developer PDF

LookML-Developer PDF (Printable)
$48
$119.99

LookML-Developer Testing Engine

LookML-Developer PDF (Printable)
$56
$139.99

LookML-Developer PDF + Testing Engine

LookML-Developer PDF (Printable)
$70.8
$176.99
Question # 1

Business users report that they are unable to build useful queries because the list of fields in the Explore is too long to find what they need.

Which three LookML options should a developer use to curate the business user’s experience? (Choose three.)

Options:

A.  

Add a description parameter to each field with context so that users can search key terms.

B.  

Create a separate project for each business unit containing only the fields that the unit needs.

C.  

Add a group_label parameter to relevant fields to organize them into logical categories.

D.  

Use the hidden parameter to remove irrelevant fields from the Explore.

E.  

Use a derived table to show only the relevant fields.

Discussion 0
Question # 2

After running the LookML Validator, a developer sees the following error message in the Looker development environment:

“Measures with Looker aggregations (sum, average, min, max, list types) may not reference other measures”.

What could be causing this error?

Options:

A.  

A measure of type: count has a sql parameter defined.

B.  

A measure of type: sum adds up other measures in the sql parameter.

C.  

A measure of type: sum has a SUM function written in the sql parameter.

D.  

A measure of type: number has a SUM function written in the sql parameter.

Discussion 0
Question # 3

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.

Discussion 0
Question # 4

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 I

D.  

The users table has the detailed information about the individual buyer and seller.

How should the Explore be defined to meet this requirement?

A)

Question # 4

B)

Question # 4

C)

Question # 4

D)

Question # 4

Options:

A.  

Option A

B.  

Option B

C.  

Option C

D.  

Option D

Discussion 0
Question # 5

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)

Question # 5

B)

Question # 5

C)

Question # 5

D)

Question # 5

Options:

A.  

Option A

B.  

Option B

C.  

Option C

D.  

Option D

Discussion 0
Question # 6

A developer is defining the users table within a view file in Looker. Theusers table will be available as an individual Explore and it will also be joined into other Explores, such as the products Explore. The developer needs to limit the fields visible in the products Explore without affecting the visibility of the fields in the users Explore.

How should the developer meet this requirement?

Options:

A.  

Use the fields parameter at the join level for the products Explore to specify which fields should be included and leave the users Explore as is.

B.  

Create duplicate dimensions and measures, one for the users Explore and one for the products Explore, and use the hidden parameter to modify the visibility of the fields.

C.  

Create two view files for the users table. One view file will have all possible fields for the users Explore, and theother will have only the fields required for the products Explore.

D.  

Use the hidden parameter in the users view file for the fields that should not come over to the products Explore and leave the users Explore as is.

Discussion 0
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?

Options:

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.

Discussion 0
Get LookML-Developer dumps and pass your exam in 24 hours!

Free Exams Sample Questions