Pass Google LookML-Developer Exam Quickly With Actual4Exams
Prepare LookML-Developer Question Answers - LookML-Developer Exam Dumps
NEW QUESTION 17
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. Change the existing measures in the transactions view to dimensions, and add measures of the different required types.
- B. Create a constant for each measure so it can be reused across other areas of the LookML project.
- C. Add measures to the transactions view of type: number to apply the required functions.
- D. Create native derived tables using transactions as the explore_source.
Answer: D
NEW QUESTION 18
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 D
- B. Option A
- C. Option C
- D. Option B
Answer: A
NEW QUESTION 19
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 20
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. Persist the derived table.
- B. Use a conditional WHERE clause for Development Mode.
- C. Use index distribution_key or sort_key for this derived table.
- D. Build a user attribute filter into the Explore.
Answer: A
NEW QUESTION 21
After validating LookML code, a developer receives the following error message:
"Unknown or Inaccessible Field users.name"
What is causing this error?
- A. The field uses incorrect SQL syntax.
- B. The join relationship is incorrect.
- C. The field is set to "hidden".
- D. There is a missing join.
Answer: D
NEW QUESTION 22
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 for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.
- C. Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}
- D. 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.
Answer: B
NEW QUESTION 23
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. An Explore LookML file based on the dashboard.
- D. A dashboard LookML file included in the project.
Answer: D
NEW QUESTION 24
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. Convert_tz
- C. Fiscal_month_offset
- D. Week_start_day
Answer: C
NEW QUESTION 25
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. Limit the filter suggestions using the suggestions parameter.
- B. Add an always_filter parameter to restrict the filter suggestions.
- C. Add persistence to the base view of the Explore.
- D. Use an access_filter parameter to automatically apply filters.
Answer: A
NEW QUESTION 26
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 will be automatically pointed to the orders Explore in model_b.
- B. Dashboard tiles and Looks that rely on this Explore will be deleted.
- C. Dashboard tiles and Looks that rely on this Explore will return an error.
- D. Dashboard tiles and Looks will redirect to the new database connection.
Answer: B
NEW QUESTION 27
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 discounted_sale_price field should have a group_by: yes parameter.
- B. The discounted_sale_price field should be defined as a dimension of type: number, not as a measure.
- C. The sale_price field should be defined as a measure of type: number, not as a dimension.
- D. The underlying database table does not have a field called sale_price.
Answer: C
NEW QUESTION 28
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 D
- C. Option C
- D. Option B
Answer: A
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 A
- B. Option D
- C. Option C
- D. Option B
Answer: A
NEW QUESTION 30
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 and validate whether removing the conversion from date fields changes the results.
- 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 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 A
- B. Option D
- C. Option C
- D. Option E
- E. Option B
Answer: A,C
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. A front-end filter in the Explore
- D. An always_filter parameter
Answer: C
NEW QUESTION 33
After running the Content Validator, a developer can see the error "Unknown field".
Which two changes could cause this issue? (Choose two.)
- A. Field type was changed from number to string.
- B. Field name was changed from id to user_id.
- C. Explore label was changed from users to customers.
- D. View name was changed from users to customers.
- E. Model name was changed from e_commerce to reporting.
Answer: A,B
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 A
- B. Option D
- C. Option C
- D. Option B
Answer: A
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. Use the hidden parameter to remove irrelevant fields from the Explore.
- B. Create a separate project for each business unit containing only the fields that the unit needs.
- C. Add a group_label parameter to relevant fields to organize them into logical categories.
- D. Add a description parameter to each field with context so that users can search key terms.
- E. Use a derived table to show only the relevant fields.
Answer: C,D,E
NEW QUESTION 36
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. There is an Explore named inventory_items which references the order_items view.
- B. A field in the order_items view references a field in the inventory_items view.
- C. A field in the inventory_items view references a field in the order_items view.
- D. There is another Explore named order_items which references the inventory_items view.
Answer: B
NEW QUESTION 37
......
Real Google LookML-Developer Exam Questions [Updated 2021]: https://www.actual4exams.com/LookML-Developer-valid-dump.html