Get 2022 Free Google LookML-Developer Exam Practice Materials Collection [Q30-Q47]

5/5 - (3 votes)

Get 2022 Free Google LookML-Developer Exam Practice Materials Collection

Get Latest and 100% Accurate LookML-Developer Exam Questions

Google LookML-Developer Exam Syllabus Topics:

Topic	Details
Topic 1	Apply procedural concepts to evaluate the performance of queries and reports Apply procedural concepts to optimize queries and reports for performance
Topic 2	Modify existing project structure to account for new reporting needs Design new LookML dimensions or measures with given requirements
Topic 3	Ensure existing contents are working (e.g., use Content Validator, audit, search for errors) Maintain the health of LookML projects in a given scenario
Topic 4	Decide which Looker features to use to implement data security Apply procedural concepts to implement data security requirements
Topic 5	Build project-based needs (e.g., data sources, replication, mock reports provided by clients) Determine which views and tables to use
Topic 6	Analyze data models and business requirements to create LookML objects Determine how to join views into Explores

NEW QUESTION 30
A retail company wants to limit who can see the financial information in their reports to executives and store managers. The LookML Developer creates a user attribute called leadership with the value “000” for executives and “999” for store managers. The developer creates three access grant objects and one dimension:

How should the developer ensure that only authorized users see the data in the Total Revenue dimension?

required_access_grants: [can_view_financial_data]

required_access_grants: [leadership]

required_access_grants: [“000″,”999”]

required_access_grants: [total_revenue]

NEW QUESTION 31
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.

NEW QUESTION 32
A developer commits changes after adding LookML for a new measure. Upon pulling from production, the developer notices the following lines in the LookML:

Remove “<<<<<< HEAD”, “======”, and “>>>>>> branch ‘master'”

Remove “<<<<<< HEAD”, “======”, and everything following “======”

Remove everything between “<<<<<< HEAD” and “======”, and “>>>>>> branch ‘master'”

Remove everything between “<<<<<< HEAD” and “>>>>>> branch ‘master'”

NEW QUESTION 33
A developer has User Specific Time Zones enabled for a Looker instance, but wants to ensure that queries run in Looker are as performant as they can be. The developer wants to add a datatype: date parameter to all dimension_group definitions without time data in a table-based view, so that time conversions don’t occur for these fields.
How can the developer determine to which fields this parameter should be applied through SQL Runner?

Open the Explore query in SQL Runner and validate whether removing the conversion from date fields changes the results.

Open the Explore query in SQL Runner to determine which fields are converted.

Use the CAST function in SQL Runner to ensure that all underlying fields are dates and conversions are not applied.

Use the Describe feature in SQL Runner to determine which fields include time data.

NEW QUESTION 34
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 measure of type: count has a sql parameter defined.

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

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

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

NEW QUESTION 35
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 field in the order_items view references a field in the inventory_items view.

A field in the inventory_items view references a field in the order_items view.

There is an Explore named inventory_items which references the order_items view.

There is another Explore named order_items which references the inventory_items view.

NEW QUESTION 36
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 an ephemeral derived table from the user’s query.

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

NEW QUESTION 37
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 to use 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)

B)

C)

D)

Option A

Option B

Option C

Option D

NEW QUESTION 38
Two developers are working on adding a new view to a project. Once both developers have finished their work in the view, the changes will be pushed to production.
Where should the developers write the LookML for this view?

In the master branch, with both users writing to the branch

In one user’s personal branch, with both users writing to the branch

In a new shared branch created from the master branch

In each of their personal branches, with each user writing code separately

NEW QUESTION 39
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?

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

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

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

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

NEW QUESTION 40
Business users report that 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?

Use a conditional WHERE clause for Development Mode.

Build a user attribute filter into the Explore.

Use index distribution_key or sort_key for this derived table.

Persist the derived table.

NEW QUESTION 41
A LookML developer creates a new model and a test dashboard from the model. The developer shares the link to the new dashboard with users, but the users report that all they see is the “Model Not Found” error.
What is a possible cause of this issue?

The developer has not pushed the new model to Production Mode.

The developer has not added users to the new model set.

The users do not have permission to access this dashboard.

The new model is missing an Explore definition.

NEW QUESTION 42
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

NEW QUESTION 43
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 is available on the underlying datasource table my tablename or at least every 24 hours.
Which datagroup definition will refresh the cache as expected?
A)

B)

C)

D)

Option A

Option B

Option C

Option D

NEW QUESTION 44
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?

Create a measure filtered on Category, and make the filter value controlled by a parameter.

Calculate the measure using a derived table, and then join that derived table back into the Explore.

Create a measure with type: sum_over_dimension, and make the dimension value controlled by a parameter.

Calculate the overall count using table calculations in the Explore.

NEW QUESTION 45
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.)

B)

C)

D)

E)

Option A

Option B

Option C

Option D

Option E

NEW QUESTION 46
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 change has 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.

NEW QUESTION 47
Users must be able to click on the Country field in their Explore and be redirected to another Explore that shows all countries compared.
Which parameter should be added to the country dimension to create a connection to this other associated Explore?

url_encode

drill_fields