VCEdump

LOOKML-DEVELOPER Looker LookML Developer

PDF question preview Back to product

Reading controls

Reader tools

Free demo

8 of 50 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice7

Multiple choice1

Google · LOOKML-DEVELOPER

Free LOOKML-DEVELOPER Exam Dumps Preview

Preview real exam questions, verified answers and available explanations before choosing a study plan.

Question 1

Single choice

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?

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.

Reveal answer details Close answer details

Correct answerA

Question 2

Multiple choice

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.)

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.

Reveal answer details Close answer details

Correct answersA, C, E

Question 3

Single choice

The code below shows a view order_items with its measures total_revenue and user_count

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

A
Option A
B
Option B
C
Option C
D
Option D

Reveal answer details Close answer details

Correct answerC

Question 4

Single choice

A LookML Developer is working with denormalized tables and needs to create a measure adding up the Order Shipping column in the table below:

A
Option A
B
Option B
C
Option C
D
Option D

Reveal answer details Close answer details

Correct answerA

Question 5

Single choice

A developer wants to create a new Explore based on the order_items view. The developer creates an Explore in the ecommerce model file with the following definition:

explore: order_items {}

After saving and validations, the developer receives this LookML validator error:

Inaccessible view "inventory_items", "inventory_items" is not accessible in explore" "order_items". Check for typos and missing joins in explore "order_items".

What caused this error to appear?

A
A field in the order_items view references a field in the inventory_items view.
B
A field in the inventory_items view references a field in the order_items view.
C
There is an Explore named inventory_items which references the order_items view.
D
There is another Explore named order_items which references the inventory_items view.

Reveal answer details Close answer details

Correct answerA

Question 6

Single choice

A developer wants to create 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.

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

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.

Reveal answer details Close answer details

Correct answerB

Question 7

Single choice

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.

Reveal answer details Close answer details

Correct answerA

Question 8

Single choice

A developer creates a derived table and wants to add persistence to it. Because the table is not used on a frequent basis, the developer wants the table to be cached for 12 hours, but only when a user has queried it.

Which persistence parameter should be added to the derived table's definition in order to satisfy this use case?

A
persist_with: "12 hours"
B
datagroup: 12_hours {
max_cache_age: "12 hours"
}
C
persist_for: "12 hours"
D
sql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;

Reveal answer details Close answer details

Correct answerA

VOL	TYPE	QUESTIONS
1	Single choice	7
2	Multiple choice	1

Free LOOKML-DEVELOPER Exam Dumps Preview

Looker LookML Developer

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8