LookML-Developer PDF Dumps Nov 24, 2021 Exam Questions – Valid LookML-Developer Dumps
Ultimate LookML-Developer Guide to Prepare Free Latest Google Practice Tests Dumps
NEW QUESTION 19
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 20
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 21
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 22
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 23
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 new model is missing an Explore definition.
- B. The developer has not added users to the new model set.
- C. The developer has not pushed the new model to Production Mode.
- D. The users do not have permission to access this dashboard.
Answer: B
NEW QUESTION 24
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 25
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 26
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 ">>>>>> branch 'master'"
- B. Remove "<<<<<< HEAD", "======", and everything following "======"
- C. Remove "<<<<<< HEAD", "======", and ">>>>>> branch 'master'"
- D. Remove everything between "<<<<<< HEAD" and "======", and ">>>>>> branch 'master'"
Answer: A
NEW QUESTION 27
A developer needs to model out LookML to convert existing reports into Looker. The existing reports are:
Report 1: A report with order and order_items data, which finds the order with the largest total value of the order_item prices.
Report 2: A report with order and order_items data, which finds the order with the largest total number of products ordered.
Report 3: A report with data on every product, whether or not it has been ordered.
Each database table used is updated in real time as orders are made.
How should the developer construct an Explore using the order_items view as the base view?
- A. Create one persistent derived table to calculate Report 1, create one persistent derived table to calculate Report 2, and join in the products view with a full_outer join.
- B. Create one persistent derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.
- C. Create one ephemeral derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.
- D. Create one ephemeral derived table to calculate Report 1, create one ephemeral derived table to calculate Report 2, and join in the products view with a left_outer join.
Answer: A
NEW QUESTION 28
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 29
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 30
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 31
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 32
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. A filtered measure
- B. The hidden parameter
- C. The sql_always_where parameter
- D. A relationship definition
Answer: D
NEW QUESTION 33
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 34
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 35
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 36
A developer defines the following measure in the order_items view:
The code must validate without errors.
Which action should the developer take?
- A. Join order_items and inventory_items in the same Explore.
- B. Copy the cost definition from inventory_items to the order_items view file.
- C. Join order_items and inventory_items in a derived table.
- D. Add the following to the order_items view file: include: "inventory_items,view.lkml"
Answer: C
NEW QUESTION 37
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 38
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 39
......
Passing Key To Getting LookML-Developer Certified Exam Engine PDF: https://www.briandumpsprep.com/LookML-Developer-prep-exam-braindumps.html
