Updated Jan-2022 Premium LookML-Developer Exam Engine pdf - Download Free Updated 51 Questions
Authentic LookML-Developer Dumps With 100% Passing Rate Practice Tests Dumps
NEW QUESTION 16
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 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.
- 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 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.
Answer: B
NEW QUESTION 17
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 the master branch, with both users writing to the branch
- B. In each of their personal branches, with each user writing code separately
- C. In a new shared branch created from the master branch
- D. In one user's personal branch, with both users writing to the branch
Answer: C
NEW QUESTION 18
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 adds up other measures in the sql parameter.
- B. A measure of type: number has a SUM function written in the sql parameter.
- C. A measure of type: count has a sql parameter defined.
- D. A measure of type: sum has a SUM function written in the sql parameter.
Answer: C
NEW QUESTION 19
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 "<<<<<< HEAD", "======", and everything following "======"
- B. Remove everything between "<<<<<< HEAD" and ">>>>>> branch 'master'"
- C. Remove everything between "<<<<<< HEAD" and "======", and ">>>>>> branch 'master'"
- D. Remove "<<<<<< HEAD", "======", and ">>>>>> branch 'master'"
Answer: B
NEW QUESTION 20
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. Convert_tz
- B. Datatype
- C. Fiscal_month_offset
- D. Week_start_day
Answer: C
NEW QUESTION 21
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 and validate whether removing the conversion from date fields changes the results.
- B. Use the Describe feature in SQL Runner to determine which fields include time data.
- C. Open the Explore query in SQL Runner to determine which fields are converted.
- D. Use the CAST function in SQL Runner to ensure that all underlying fields are dates and conversions are not applied.
Answer: D
NEW QUESTION 22
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. url_encode
- C. drill_fields
- D. tags
Answer: A
NEW QUESTION 23
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. 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.
- D. 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.
Answer: B
NEW QUESTION 24
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. A unique primary key is defined in each view.
- B. The sum measure used is defined correctly.
- C. Symmetric_aggregates: no is not present in the Explore definition.
- D. No concatenated primary keys are used.
Answer: C
NEW QUESTION 25
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 deployed to a shared branch.
- D. A change has been committed in another shared branch.
Answer: A
NEW QUESTION 26
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 discounted_sale_price field should have a group_by: yes parameter.
- C. The discounted_sale_price field should be defined as a dimension of type: number, not as a measure.
- D. The underlying database table does not have a field called sale_price.
Answer: A
NEW QUESTION 27
A LookML developer has written the following persistent derived table. It references orders_rollup, another persistent derived table that also rebuilds with the same SQL trigger value.
Which change is needed to guarantee that user_facts will always rebuild with the latest data from orders_rollup?
- A. Change the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.
- B. Change the orders_rollup view reference to the literal table name from the database's scratch schema.
- C. Change the sql_trigger_value parameter of user_facts to select the current date plus one hour, so it triggers an hour after orders_rollup.
- D. Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}
Answer: A
NEW QUESTION 28
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 D
- C. Option C
- D. Option A
Answer: A
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 A
- B. Option B
- C. Option D
- D. Option C
Answer: A
NEW QUESTION 30
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?
- A. Use a conditional WHERE clause for Development Mode.
- B. Use index distribution_key or sort_key for this derived table.
- C. Persist the derived table.
- D. Build a user attribute filter into the Explore.
Answer: C
NEW QUESTION 31
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. An Explore LookML file based on the dashboard.
- B. A dashboard LookML file included in the project.
- C. A native derived table based on the dashboard.
- D. A link to the dashboard included in the project.
Answer: B
NEW QUESTION 32
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?
- A. required_access_grants: [can_view_financial_data]
- B. required_access_grants: [total_revenue]
- C. required_access_grants: [leadership]
- D. required_access_grants: ["000","999"]
Answer: A
NEW QUESTION 33
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 inventory_items view references a field in the order_items view.
- B. There is an Explore named inventory_items which references the order_items view.
- C. There is another Explore named order_items which references the inventory_items view.
- D. A field in the order_items view references a field in the inventory_items view.
Answer: D
NEW QUESTION 34
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. Single account HTTPS
- C. SSH
- D. A bare Git repository
Answer: C
NEW QUESTION 35
A LookML Developer is working with denormalized tables and needs to create a measure adding up the Order Shipping column in the table below:
A)
B)
C)
D)
- A. Option A
- B. Option B
- C. Option D
- D. Option C
Answer: A
NEW QUESTION 36
......
Google LookML-Developer Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
Verified Pass LookML-Developer Exam in First Attempt Guaranteed: https://www.examtorrent.com/LookML-Developer-valid-vce-dumps.html
