[Dec 04, 2021] Latest LookML-Developer Exam with Accurate Looker LookML Developer PDF Questions
Practice To LookML-Developer - Exam4Labs Remarkable Practice On your Looker LookML Developer Exam
NEW QUESTION 19
Only users with department attributes of Finance and Executive should be able to access the revenue view. Only users with the value of Executive for the department user attribute should be able to view the total_revenue field.
Given the code snippet below:
How should the required access grants be structured to set up this system of access?
- A. required_access_grants: [grant_a, grant_b] in the revenue view, required_access_grants: [grant_a] in the total_revenue field
- B. required_access_grants: [grant_a] in the revenue view, required_access_grants: [grant_a, grant_b] in the total_revenue field
- C. required_access_grants: [grant_b] in the financial_data Explore, required_access_grants: [grant_a] in the total_revenue field
- D. required_access_grants: [grant_b] in the revenue view, required_access_grants: [grant_a] in the total_revenue field
Answer: B
NEW QUESTION 20
A developer has a persistent derived table view called user_facts that contains aggregated data for each user. The developer needs to query the data from this table in another derived table view called user_region_facts.
Which strategy should the developer use to write the query for user_region_facts that will leverage the existing derived table?
- A. Writhe the query form user_facts into a common table expression (WITH user_facts AS...).
- B. Use ${user_facts.SQL_TABLE_NAME} to reference the user_facts derived table.
- C. Write a subquery in the FROM clause and alias with ${user_facts}.
- D. Copy the name of the database table in the scratch schema for the user_facts derived table.
Answer: A
NEW QUESTION 21
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 shared branch.
- B. A change has been committed in another developer's personal branch
- C. A change has been deployed to a shared branch.
- D. A change has been deployed to production.
Answer: B
NEW QUESTION 22
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: [total_revenue]
- B. required_access_grants: [leadership]
- C. required_access_grants: ["000","999"]
- D. required_access_grants: [can_view_financial_data]
Answer: D
NEW QUESTION 23
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 24
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. Add measures to the transactions view of type: number to apply the required functions.
- B. Create a constant for each measure so it can be reused across other areas of the LookML project.
- C. Create native derived tables using transactions as the explore_source.
- D. Change the existing measures in the transactions view to dimensions, and add measures of the different required types.
Answer: C
NEW QUESTION 25
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)
- A. Option C
- B. Option A
- C. Option B
- D. Option D
Answer: B
NEW QUESTION 26
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 27
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 index distribution_key or sort_key for this derived table.
- B. Use a conditional WHERE clause for Development Mode.
- C. Build a user attribute filter into the Explore.
- D. Persist the derived table.
Answer: D
NEW QUESTION 28
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 29
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 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
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. Format used to deliver these reports
- B. Amount of data rendered for each query
- C. Ratio of visualizations to text tiles
- D. Number of databases used by dashboard elements
- E. Number of queries used by the dashboard
Answer: C,E
NEW QUESTION 32
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?
- A. A filtered measure
- B. A sql_always_where parameter
- C. An always_filter parameter
- D. A front-end filter in the Explore
Answer: D
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
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. SSH
- B. Multiple account HTTPS
- C. A bare Git repository
- D. Single account HTTPS
Answer: A
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 C
- B. Option A
- C. Option B
- D. Option D
Answer: B
NEW QUESTION 36
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 37
Business users report that they are unable to build useful queries because the list of fields in the Explore is too long to find what they need.
Which three LookML options should a developer use to curate the business user's experience? (Choose three.)
- A. Add a description parameter to each field with context so that users can search key terms.
- B. Add a group_label parameter to relevant fields to organize them into logical categories.
- C. Use the hidden parameter to remove irrelevant fields from the Explore.
- D. Create a separate project for each business unit containing only the fields that the unit needs.
- E. Use a derived table to show only the relevant fields.
Answer: A,B,E
NEW QUESTION 38
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 link to the dashboard included in the project.
- B. A native derived table based on the dashboard.
- C. A dashboard LookML file included in the project.
- D. An Explore LookML file based on the dashboard.
Answer: C
NEW QUESTION 39
......
Exam Questions and Answers for LookML-Developer Study Guide Questions and Answers!: https://www.exam4labs.com/LookML-Developer-practice-torrent.html