[2022] LookML-Developer PDF Questions - Perfect Prospect To Go With ITPassLeader Practice Exam [Q18-Q42]

[2022] LookML-Developer PDF Questions - Perfect Prospect To Go With ITPassLeader Practice Exam

Google LookML-Developer Pdf Questions - Outstanding Practice To your Exam

NEW QUESTION 18
A user reports that, when a date dimension is filtered to "before now" results are returned that consistently include tomorrow. Dimension fill has been ruled out as a cause of the issue.
Which LookML parameter should be used to resolve this issue?

A. Datatype
B. Fiscal_month_offset
C. Convert_tz
D. Week_start_day

Answer: B

NEW QUESTION 19
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 on the 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?

A. Create native derived tables using transactions as the explore_source.
B. Create a constant for each measure so it can be reused across other areas of the LookML project.
C. Add measures to the transactions view of type: number to apply the required functions.
D. Change the existing measures in the transactions view to dimensions, and add measures of the different required types.

Answer: A

NEW QUESTION 20
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. sql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;
B. datagroup: 12_hours {
max_cache_age: "12 hours"
}
C. persist_for: "12 hours"
D. persist_with: "12 hours"

Answer: D

NEW QUESTION 21
A developer is connecting a LookML project to a remote Git repository. The developer wants to track which users are committing code changes, creating pull requests, or deploying to production when the different Git commands are initiated from within Looker.
Which type of Git connection should be utilized to meet this business requirement?

A. Multiple account HTTPS
B. A bare Git repository
C. Single account HTTPS
D. SSH

Answer: D

NEW QUESTION 22
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 with type: sum_over_dimension, and make the dimension value controlled by a parameter.
B. Calculate the measure using a derived table, and then join that derived table back into the Explore.
C. Calculate the overall count using table calculations in the Explore.
D. Create a measure filtered on Category, and make the filter value controlled by a parameter.

Answer: B

NEW QUESTION 23
Users have built a popular dashboard and want to have change management built in for any edits made to the dashboard. The developer sets up version control for the model on which the dashboard is based.
What should the developer build to meet the business requirement?

A. A native derived table based on the dashboard.
B. A link to the dashboard included in the project.
C. A dashboard LookML file included in the project.
D. An Explore LookML file based on the dashboard.

Answer: C

NEW QUESTION 24
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. A change has been committed in another developer's personal branch
B. A change has been deployed to production.
C. A change has been committed in another shared branch.
D. A change has been deployed to a shared branch.

Answer: A

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

A. Symmetric_aggregates: no is not present in the Explore definition.
B. A unique primary key is defined in each view.
C. The sum measure used is defined correctly.
D. No concatenated primary keys are used.

Answer: A

NEW QUESTION 26
A developer would like to add a new dimension of type: yesno for the enabled column in their users table. The column is of type: string in the database and returns yes and no values.
How should the developer define the yesno dimension?
A)

B)

C)

D)

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

Answer: C

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

A. Remove everything between "<<<<<< HEAD" and "======", and ">>>>>> branch 'master'"
B. Remove everything between "<<<<<< HEAD" and ">>>>>> branch 'master'"
C. Remove "<<<<<< HEAD", "======", and ">>>>>> branch 'master'"
D. Remove "<<<<<< HEAD", "======", and everything following "======"

Answer: B

NEW QUESTION 28
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. There is another Explore named order_items which references the inventory_items view.
C. A field in the inventory_items view references a field in the order_items view.
D. There is an Explore named inventory_items which references the order_items view.

Answer: A

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

A. Create one datagroup tied to all three PDTs that runs when the total row count across all three tables changes.
B. Create three separate datagroups tied to three PDTs that run when a new row is added to the ETL log table.
C. Create one datagroup tied to all three PDTs that parameterizes the view name for each PDT in the SQL trigger condition.
D. Create three separate datagroups tied to three PDTs that run when each corresponding table's row count changes.

Answer: B

NEW QUESTION 30
A developer needs to add an Explore built off of the orders view, which surfaces only completed orders. An orders Explore exists that contains all order information. Fields from the orders view are also referenced in other existing views such as ${orders.fieldname}.
How should developer define a new Explore for completed orders and keep all field references working correctly?
A)

B)

C)

D)

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

Answer: D

NEW QUESTION 31
After validating LookML code, a developer receives the following error message:
"Unknown or Inaccessible Field users.name"
What is causing this error?

A. The field is set to "hidden".
B. The join relationship is incorrect.
C. There is a missing join.
D. The field uses incorrect SQL syntax.

Answer: C

NEW QUESTION 32
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)

B)

C)

D)

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

Answer: D

NEW QUESTION 33
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?
A)

B)

C)

D)

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

Answer: D

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

Answer: A

NEW QUESTION 35
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 only field the users need from the products view is product.name.
Which LookML should the developer use?
A)

B)

C)

D)

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

Answer: A

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

A. Create one ephemeral derived table to calculate Report 1, create one ephemeral derived table to calculate Report 2, and join in the products view with a left_outer join.
B. 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.
C. Create one ephemeral derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.
D. Create one persistent derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.

Answer: B

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