Nov-2021 Google LookML-Developer Actual Questions and Braindumps

LookML-Developer Dumps To Pass Google Exam in 24 Hours - ValidExam

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

• A. Create an Explore with users as the base table.
• B. Create a persistent derived table from the user's query.
• C. Create an ephemeral derived table from the user's query.
• D. Add persist_for: "24 hours" to the orders Explore.

Answer: A

 

NEW QUESTION 18
A user is seeing an error in the Explore that indicates the primary key defined for a one-million-row table is not unique.
How can the developer use SQL Runner to troubleshoot quickly?

• A. Create a query that concatenates two columns to create a compound primary key.
• B. Create a query that counts how many occurrences of the primary key value are in the base view, and sort by count.
• C. Create a query that selects the primary key from the base view, and look for duplicates.
• D. Create a query that selects all the fields from the table, and sort by primary key.

Answer: A

 

NEW QUESTION 19
A developer is defining the users table within a view file in Looker. The users table will be available as an individual Explore and it will also be joined into other Explores, such as the products Explore. The developer needs to limit the fields visible in the products Explore without affecting the visibility of the fields in the users Explore.
How should the developer meet this requirement?

• A. Create duplicate dimensions and measures, one for the users Explore and one for the products Explore, and use the hidden parameter to modify the visibility of the fields.
• B. Use the fields parameter at the join level for the products Explore to specify which fields should be included and leave the users Explore as is.
• C. Use the hidden parameter in the users view file for the fields that should not come over to the products Explore and leave the users Explore as is.
• D. Create two view files for the users table. One view file will have all possible fields for the users Explore, and the other will have only the fields required for the products Explore.

Answer: B

 

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. persist_for: "12 hours"
• C. persist_with: "12 hours"
• D. datagroup: 12_hours {
  max_cache_age: "12 hours"
  }

Answer: C

 

NEW QUESTION 21
A user reports the following SQL error when selecting the discounted sale price field:
ERROR: column "order_items.sale_price"; must appear in the GROUP BY clause or be used in an aggregate function.
The developer checks the field definition and finds it to be:
measure: discounted_sale_price {
type: number
sql: ${sale_price} * 0.8 ;;
}
The developer also finds the LookML definition of the sale_price field to be:
dimension: sale_price {
type: number
sql: ${TABLE}.sale_price ;;
}
What is the likely cause of the SQL error?

• A. The sale_price field should be defined as a measure of type: number, not as a dimension.
• B. The underlying database table does not have a field called sale_price.
• C. The discounted_sale_price field should have a group_by: yes parameter.
• D. The discounted_sale_price field should be defined as a dimension of type: number, not as a measure.

Answer: A

 

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

• A. Option A
• B. Option E
• C. Option B
• D. Option C
• E. Option D

Answer: A,D

 

NEW QUESTION 23
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 C
• B. Option A
• C. Option B
• D. Option D

Answer: B

 

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

• A. Open the Explore query in SQL Runner to determine which fields are converted.
• B. Open the Explore query in SQL Runner and validate whether removing the conversion from date fields changes the results.
• C. Use the CAST function in SQL Runner to ensure that all underlying fields are dates and conversions are not applied.
• D. Use the Describe feature in SQL Runner to determine which fields include time data.

Answer: C

 

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

B)

C)

D)

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

Answer: A

 

NEW QUESTION 26
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: sum has a SUM function written in the sql parameter.
• B. A measure of type: sum adds up other measures in the sql parameter.
• C. A measure of type: count has a sql parameter defined.
• D. A measure of type: number has a SUM function written in the sql parameter.

Answer: C

 

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

• A. In a new shared branch created from the master branch
• B. In each of their personal branches, with each user writing code separately
• C. In the master branch, with both users writing to the branch
• D. In one user's personal branch, with both users writing to the branch

Answer: A

 

NEW QUESTION 28
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 A
• B. Option B
• C. Option C
• D. Option D

Answer: C

 

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

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

Answer: B

 

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

• A. link
• B. tags
• C. drill_fields
• D. url_encode

Answer: A

 

NEW QUESTION 31
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 three separate datagroups tied to three PDTs that run when each corresponding table's row count changes.
• B. Create one datagroup tied to all three PDTs that parameterizes the view name for each PDT in the SQL trigger condition.
• C. Create three separate datagroups tied to three PDTs that run when a new row is added to the ETL log table.
• D. Create one datagroup tied to all three PDTs that runs when the total row count across all three tables changes.

Answer: C

 

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

• A. 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.
• B. 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.
• C. Define max_cache_age on daily_forecast Explores of 24 hours. Define max_cache_age on all other Explores for one hour.
• D. 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.

Answer: B

 

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

B)

C)

D)

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

Answer: A

 

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

• A. Dashboard tiles and Looks that rely on this Explore will return an error.
• B. Dashboard tiles and Looks will redirect to the new database connection.
• C. Dashboard tiles and Looks that rely on this Explore will be deleted.
• D. Dashboard tiles and Looks will be automatically pointed to the orders Explore in model_b.

Answer: C

 

NEW QUESTION 35
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 B
• B. Option A
• C. Option C
• D. Option D

Answer: A

 

NEW QUESTION 36
After running the Content Validator, a developer can see the error "Unknown field".
Which two changes could cause this issue? (Choose two.)

• A. Field type was changed from number to string.
• B. View name was changed from users to customers.
• C. Field name was changed from id to user_id.
• D. Model name was changed from e_commerce to reporting.
• E. Explore label was changed from users to customers.

Answer: A,C

 

NEW QUESTION 37
......

Download the Latest LookML-Developer Dump - 2021 LookML-Developer Exam Question Bank: https://www.validexam.com/LookML-Developer-latest-dumps.html