Skip to main content

LOOKML-DEVELOPER Real Exam Questions

Looker LookML Developer

50 questions available · Page 1 of 5

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

The developer has moved the orders Explore (shown below) from model_a to model_b, where both models are in the same project, and all users have access to both models.

Connection: "demo"
include: ".view"
explore: orders {}

What will happen after making this change?

  1. A

    Dashboard tiles and Looks will be automatically pointed to the orders Explore in model_b.

  2. B

    Dashboard tiles and Looks will redirect to the new database connection.

  3. C

    Dashboard tiles and Looks that rely on this Explore will be deleted.

  4. D

    Dashboard tiles and Looks that rely on this Explore will return an error.

Show answer and explanation

Correct answer: C

Question 2 Multiple choice

A developer wants to calculate the ratio of total sales from the orders view and total users from the users view.

Which two methods can be used to create a measure that meets these requirements? (Choose two.)

  1. A

    Option A

  2. B

    Option B

  3. C

    Option C

  4. D

    Option D

  5. E

    Option E

Show answer and explanation

Correct answers: A, C

Question 3 Single choice

A user reports that a query run against the orders Explore takes a long time to run. The query includes only fields from the users view. Data for both views is updated in real time. The developer runs the following query in SQL Runner and quickly receives results:

SELECT * FROM users.

What should the developer do to improve the performance of the query in the Explore?

  1. A

    Create an Explore with users as the base table.

  2. B

    Create a persistent derived table from the user's query.

  3. C

    Create an ephemeral derived table from the user's query.

  4. D

    Add persist_for: "24 hours" to the orders Explore.

Show answer and explanation

Correct answer: A

Question 4 Single choice

A user reports an error message 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?

  1. A

    The sum measure used is defined correctly.

  2. B

    A unique primary key is defined in each view.

  3. C

    Symmetric_aggregates: no is not present in the Explore definition.

  4. D

    No concatenated primary keys are used.

Show answer and explanation

Correct answer: C

Question 5 Single choice

Users viewing an Explore should be able to view rows of data only where the value of the product.brand column matches the value of the user's company user attribute.

Which access filter should the developer use to meet this requirement?

  1. A

    Option A

  2. B

    Option B

  3. C

    Option C

  4. D

    Option D

Show answer and explanation

Correct answer: B

Question 6 Single choice

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?

  1. A

    Option A

  2. B

    Option B

  3. C

    Option C

  4. D

    Option D

Show answer and explanation

Correct answer: B

Question 7 Single choice

A developer defines the following measure in the order_items view:

The code must validate without errors.

Which action should the developer take?

  1. A

    Join order_items and inventory_items in a derived table.

  2. B

    Join order_items and inventory_items in the same Explore.

  3. C

    Copy the cost definition from inventory_items to the order_items view file.

  4. D

    Add the following to the order_items view file: include: "inventory_items,view.lkml"

Show answer and explanation

Correct answer: A

Question 8 Single choice

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?

  1. A

    An always_filter parameter

  2. B

    A front-end filter in the Explore

  3. C

    A sql_always_where parameter

  4. D

    A filtered measure

Show answer and explanation

Correct answer: B

Question 9 Single choice

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

What is a scalable way to configure this caching logic?

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

  2. B

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

  3. C

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

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

Show answer and explanation

Correct answer: A

Question 10 Single choice

A developer needs to build a new dimension that offers an age-based cohort representation of users.

Which LookML code should the developer use to meet the requirement?

  1. A

    Option A

  2. B

    Option B

  3. C

    Option C

  4. D

    Option D

Show answer and explanation

Correct answer: B