[Dec 11, 2021] Get New LookML-Developer Certification Practice Test Questions Exam Dumps
Real LookML-Developer Exam Dumps Questions Valid LookML-Developer Dumps PDF
NEW QUESTION 25
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 26
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 27
The daily_forecast Explore used by the sales team needs to be cached for 24 hours. All other Explores used by the sales team need to be cached for one hour.
What is a scalable way to configure this caching logic?
- A. Define max_cache_age on daily_forecast Explores of 24 hours. Define max_cache_age on all other Explores for one hour.
- B. Define two datagroups for the model. Apply persist_with at the model level with the datagroup for 1-hour caching, and apply persist_with to daily_forecast with the datagroup for 24-hour caching.
- C. Define for the model one datagroup that caches for 1 hour. Create a persistent derived table (PDT) for the daily_forecast Explore, and apply sql_trigger_value to it selecting the current date.
- D. Define two datagroups for the model. Create a persistent derived table (PDT) for the daily_forecast Explore, and apply datagroup_trigger to it using the datagroup for 24-hour caching.
Answer: B
NEW QUESTION 28
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 29
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 be defined as a dimension of type: number, not as a measure.
- B. The sale_price field should be defined as a measure of type: number, not as a dimension.
- C. The underlying database table does not have a field called sale_price.
- D. The discounted_sale_price field should have a group_by: yes parameter.
Answer: B
NEW QUESTION 30
A developer wants to create a measure that shows the item count broken out by category. When a second, more granular dimension is added to the same query, the count broken out by category should still represent the original aggregation and be duplicated on each line. The business wants this "count" in "category" available in the Explore section without any additional work done by the end user. For example:
The Count column represents the count for each combination of Category and Item.
The Count in Category column represents the count for each Category only.
How can the developer address this need with a LookML object?
- A. Create a measure with type: sum_over_dimension, and make the dimension value controlled by a parameter.
- B. Calculate the measure using a derived table, and then join that derived table back into the Explore.
- C. Calculate the overall count using table calculations in the Explore.
- D. Create a measure filtered on Category, and make the filter value controlled by a parameter.
Answer: B
NEW QUESTION 31
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 D
- B. Option B
- C. Option A
- D. Option C
Answer: C
NEW QUESTION 32
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 33
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 34
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] in the revenue view, required_access_grants: [grant_a, grant_b] in the total_revenue field
- B. required_access_grants: [grant_b] in the revenue view, required_access_grants: [grant_a] 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_a, grant_b] in the revenue view, required_access_grants: [grant_a] in the total_revenue field
Answer: A
NEW QUESTION 35
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. An always_filter parameter
- B. A front-end filter in the Explore
- C. A filtered measure
- D. A sql_always_where parameter
Answer: B
NEW QUESTION 36
A developer is building an e-commerce Explore with the following datasets: orders and users. The business user needs to be able to answer questions about sellers and buyers within the same Explore. Each order in the orders table reports a buyer and seller ID. The users table has the detailed information about the individual buyer and seller.
How should the Explore be defined to meet this requirement?
A)
B)
C)
D)
- A. Option D
- B. Option A
- C. Option C
- D. Option B
Answer: D
NEW QUESTION 37
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 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.
- B. 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.
- 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 persistent derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.
Answer: B
NEW QUESTION 38
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 39
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 is set to "hidden".
- B. The join relationship is incorrect.
- C. There is a missing join.
- D. The field uses incorrect SQL syntax.
Answer: C
NEW QUESTION 40
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 D
- B. Option B
- C. Option E
- D. Option A
- E. Option C
Answer: D,E
NEW QUESTION 41
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 developer's personal branch
- B. A change has been deployed to production.
- C. A change has been committed in another shared branch.
- D. A change has been deployed to a shared branch.
Answer: A
NEW QUESTION 42
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. Copy the name of the database table in the scratch schema for the user_facts derived table.
- B. Writhe the query form user_facts into a common table expression (WITH user_facts AS...).
- C. Use ${user_facts.SQL_TABLE_NAME} to reference the user_facts derived table.
- D. Write a subquery in the FROM clause and alias with ${user_facts}.
Answer: B
NEW QUESTION 43
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: [can_view_financial_data]
- B. required_access_grants: [leadership]
- C. required_access_grants: ["000","999"]
- D. required_access_grants: [total_revenue]
Answer: A
NEW QUESTION 44
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 45
......
LookML-Developer Exam Dumps - PDF Questions and Testing Engine: https://www.pass4surecert.com/Google/LookML-Developer-practice-exam-dumps.html