New 2022 Realistic LookML-Developer Dumps Test Engine Exam Questions in here
Updated Official licence for LookML-Developer Certified by LookML-Developer Dumps PDF
NEW QUESTION 24
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: 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 adds up other measures in the sql parameter.
Answer: C
NEW QUESTION 25
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 CAST function in SQL Runner to ensure that all underlying fields are dates and conversions are not applied.
- B. Open the Explore query in SQL Runner and validate whether removing the conversion from date fields changes the results.
- C. Use the Describe feature in SQL Runner to determine which fields include time data.
- D. Open the Explore query in SQL Runner to determine which fields are converted.
Answer: A
NEW QUESTION 26
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: ["000","999"]
- B. required_access_grants: [can_view_financial_data]
- C. required_access_grants: [leadership]
- D. required_access_grants: [total_revenue]
Answer: B
NEW QUESTION 27
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 dashboard LookML file included in the project.
- B. A native derived table based on the dashboard.
- C. An Explore LookML file based on the dashboard.
- D. A link to the dashboard included in the project.
Answer: A
NEW QUESTION 28
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 one user's personal branch, with both users writing to the branch
- C. In each of their personal branches, with each user writing code separately
- D. In a new shared branch created from the master branch
Answer: D
NEW QUESTION 29
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 deployed to a shared branch.
- B. A change has been committed in another shared branch.
- C. A change has been deployed to production.
- D. A change has been committed in another developer's personal branch
Answer: D
NEW QUESTION 30
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. Hidden parameter
- C. Set definition
- D. Fields parameter
Answer: A
NEW QUESTION 31
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 E
- B. Option C
- C. Option D
- D. Option B
- E. Option A
Answer: B,E
NEW QUESTION 32
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 C
- B. Option B
- C. Option A
- D. Option D
Answer: D
NEW QUESTION 33
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 C
- B. Option D
- C. Option B
- D. Option A
Answer: A
NEW QUESTION 34
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 C
- C. Option B
- D. Option A
Answer: D
NEW QUESTION 35
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 36
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 37
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. always_filter
- B. access_filter
- C. access_grant
- D. sql_always_where
Answer: C
NEW QUESTION 38
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_b] in the financial_data Explore, required_access_grants: [grant_a] in the total_revenue field
- B. required_access_grants: [grant_a, grant_b] in the revenue view, required_access_grants: [grant_a] in the total_revenue field
- C. required_access_grants: [grant_a] in the revenue view, required_access_grants: [grant_a, grant_b] 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: C
NEW QUESTION 39
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. Single account HTTPS
- B. A bare Git repository
- C. SSH
- D. Multiple account HTTPS
Answer: C
NEW QUESTION 40
A developer defines the following measure in the order_items view:
The code must validate without errors.
Which action should the developer take?
- A. Add the following to the order_items view file: include: "inventory_items,view.lkml"
- B. Join order_items and inventory_items in a derived table.
- C. Join order_items and inventory_items in the same Explore.
- D. Copy the cost definition from inventory_items to the order_items view file.
Answer: B
NEW QUESTION 41
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. Change the existing measures in the transactions view to dimensions, and add measures of the different required types.
- C. Create native derived tables using transactions as the explore_source.
- D. Create a constant for each measure so it can be reused across other areas of the LookML project.
Answer: C
NEW QUESTION 42
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. Persist the derived table.
- C. Use index distribution_key or sort_key for this derived table.
- D. Build a user attribute filter into the Explore.
Answer: B
NEW QUESTION 43
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 orders_rollup view reference to the literal table name from the database's scratch schema.
- B. 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.
- C. Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}
- D. Change the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.
Answer: D
NEW QUESTION 44
......
Grab latest Google LookML-Developer Dumps as PDF Updated: https://www.latestcram.com/LookML-Developer-exam-cram-questions.html
