Try Online Free LookML-Developer Certification Exam Questions

test2021-12-28T07:41:13+00:00

You must pass the LookML-Developer test if you want to obtain Looker LookML Developer certification and further your general concepts. FreeTestShare provides a free LookML-Developer practice test with real exam questions and answers to assist you understand the exam subjects and format. Real LookML-Developer questions and answers have been revised and updated to guarantee that they are accurate and up to date.In the LookML-Developer area, you may also practice the actual test questions online.

Page 1 of 2

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

Option A

Option B

Option C

Option D

2. 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?

A)

Option A

Option B

Option C

Option D

3. A developer has the dimensions enrollment_month and graduation_month already defined in the view. Both were created as part of dimension_groups of type: time. The developer need touse these two dimensions in the sql_start and sql_end parameters of a dimension group of type: duration.

Which LookML should be used to calculate the number of month and years between enrollment month and graduation month?

A)

Option A

Option B

Option C

Option D

4. 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 changehas been deployed to a shared branch.

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

A change has been committed in another shared branch.

A change has been deployed to production.

5. A developer needs to model out LookML to convert existing reports into Looker.

The existing reports are:

Report 1: A report with order and order_items data, which finds the order with the largest total value of the order_item prices.

Report 2: A report with order and order_items data, which finds the order with the largest total number of products ordered.

Report 3: A report with data on every product, whether or not it has been ordered.

Each database table used is updated in real time as orders are made.

How should the developer construct an Explore using the order_items view as the base view?

Create one persistent derived table to calculate Report 1, create one persistent derived table to calculate Report 2, and join in the products view with a full_outer join.

Create one persistent derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.

Create one ephemeral derived table to calculate Report 1, create one ephemeral derived table to calculate Report 2, andjoin in the products view with a left_outer join.

Create one ephemeral derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.

6. 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?

An always_filter parameter

A front-end filter in the Explore

A sql_always_where parameter

A filtered measure

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

A filtered measure

The hidden parameter

The sql_always_where parameter

A relationship definition

8. 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?

Create an Explore with users as the base table.

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

Create anephemeral derived table from the user’s query.

Add persist_for: “24 hours” to the orders Explore.

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

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

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

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

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

Use a derived table to show only the relevant fields.

10. 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?

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

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

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

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

Page 2 of 2

11. 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?

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

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

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

Create native derived tables using transactions as the explore_source.

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

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

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

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

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

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

13. 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?

Limit the filter suggestions using the suggestions parameter.

Add an always_filter parameter to restrict the filter suggestions.

Use an access_filter parameter to automatically apply filters.

Add persistence to the base view of the Explore.