Excellent LookML-Developer PDF Dumps With 100% Prep4away Exam Passing Guaranted [Nov-2021]
100% Pass Your LookML-Developer Looker LookML Developer at First Attempt with Prep4away
NEW QUESTION 28
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 29
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. Use the Describe feature in SQL Runner to determine which fields include time data.
- B. Open the Explore query in SQL Runner to determine which fields are converted.
- C. Open the Explore query in SQL Runner and validate whether removing the conversion from date fields changes the results.
- 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 30
A developer defines the following measure in the order_items view:
The code must validate without errors.
Which action should the developer take?
- A. Copy the cost definition from inventory_items to the order_items view file.
- B. Join order_items and inventory_items in a derived table.
- C. Add the following to the order_items view file: include: "inventory_items,view.lkml"
- D. Join order_items and inventory_items in the same Explore.
Answer: B
NEW QUESTION 31
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 D
- B. Option B
- C. Option A
- D. Option C
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 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 ephemeral derived table from the user's query.
- B. Add persist_for: "24 hours" to the orders Explore.
- C. Create an Explore with users as the base table.
- D. Create a persistent derived table from the user's query.
Answer: C
NEW QUESTION 34
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 D
- B. Option B
- C. Option A
- D. Option C
Answer: C
NEW QUESTION 35
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 36
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 one user's personal branch, with both users writing to the branch
- B. In the master branch, with both users writing to the branch
- C. In a new shared branch created from the master branch
- D. In each of their personal branches, with each user writing code separately
Answer: C
NEW QUESTION 37
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?
- A. Add an always_filter parameter to restrict the filter suggestions.
- B. Add persistence to the base view of the Explore.
- C. Use an access_filter parameter to automatically apply filters.
- D. Limit the filter suggestions using the suggestions parameter.
Answer: D
NEW QUESTION 38
Users report that the main dashboard has been slow to show results.
Which two options should the developer evaluate to improve dashboard performance? (Choose two.)
- A. Ratio of visualizations to text tiles
- B. Number of databases used by dashboard elements
- C. Format used to deliver these reports
- D. Number of queries used by the dashboard
- E. Amount of data rendered for each query
Answer: A,D
NEW QUESTION 39
A LookML developer builds a view that contains sensitive information. Only members of the Management group should have access to the view. The developer needs to restrict the view from appearing in the field picker for any Explore where it might be joined for users outside of the Management group.
Which LookML parameter should the developer use to meet this requirement?
- A. access_grant
- B. access_filter
- C. always_filter
- D. sql_always_where
Answer: A
NEW QUESTION 40
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 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?
- A. The developer has not pushed the new model to Production Mode.
- B. The developer has not added users to the new model set.
- C. The new model is missing an Explore definition.
- D. The users do not have permission to access this dashboard.
Answer: B
NEW QUESTION 42
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. The sql_always_where parameter
- B. A filtered measure
- C. The hidden parameter
- D. A relationship definition
Answer: D
NEW QUESTION 43
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 44
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. 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.
- 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. 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.
Answer: D
NEW QUESTION 45
A LookML developer is creating a new view with 20 dimensions in Development Mode using the Create View from Table functionality. Now users want the developer to add only four dimensions from this new view to an existing Explore.
What can the developer add to the Explore to limit the number of fields from the view that are accessible to the user in the Explore?
- A. Join condition
- B. Set definition
- C. Fields parameter
- D. Hidden parameter
Answer: A
NEW QUESTION 46
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 47
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 48
......
Trend for LookML-Developer pdf dumps before actual exam: https://www.prep4away.com/Google-certification/braindumps.LookML-Developer.ete.file.html