2022 Realistic LookML-Developer Dumps Exam Tips Test Pdf Exam Material
Powerful LookML-Developer PDF Dumps for LookML-Developer Questions
NEW QUESTION 27
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. Add persist_for: "24 hours" to the orders Explore.
- B. Create a persistent derived table from the user's query.
- C. Create an ephemeral derived table from the user's query.
- D. Create an Explore with users as the base table.
Answer: D
NEW QUESTION 28
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 29
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 30
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 "======", and ">>>>>> branch 'master'"
- B. Remove "<<<<<< HEAD", "======", and everything following "======"
- C. Remove everything between "<<<<<< HEAD" and ">>>>>> branch 'master'"
- D. Remove "<<<<<< HEAD", "======", and ">>>>>> branch 'master'"
Answer: C
NEW QUESTION 31
The code below shows a view order_items with its measures total_revenue and user_count
Which code correctly represents a new measure that calculates average revenue per user?
A)
B)
C)
D)
- A. Option C
- B. Option D
- C. Option B
- D. Option A
Answer: A
NEW QUESTION 32
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 33
A user reports an error message on an Explore: "Non-unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum".
What should the LookML developer check for in the joined views of the Explore?
- A. No concatenated primary keys are used.
- B. Symmetric_aggregates: no is not present in the Explore definition.
- C. The sum measure used is defined correctly.
- D. A unique primary key is defined in each view.
Answer: B
NEW QUESTION 34
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 35
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. Number of databases used by dashboard elements
- B. Number of queries used by the dashboard
- C. Amount of data rendered for each query
- D. Ratio of visualizations to text tiles
- E. Format used to deliver these reports
Answer: B,D
NEW QUESTION 36
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 37
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 sql_always_where parameter
- B. An always_filter parameter
- C. A filtered measure
- D. A front-end filter in the Explore
Answer: D
NEW QUESTION 38
After running the Content Validator, a developer can see the error "Unknown field".
Which two changes could cause this issue? (Choose two.)
- A. Explore label was changed from users to customers.
- B. Model name was changed from e_commerce to reporting.
- C. Field type was changed from number to string.
- D. Field name was changed from id to user_id.
- E. View name was changed from users to customers.
Answer: C,D
NEW QUESTION 39
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 40
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 41
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 42
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 43
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. Use an access_filter parameter to automatically apply filters.
- D. Add persistence to the base view of the Explore.
Answer: A
NEW QUESTION 44
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 45
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 C
- C. Option B
- D. Option A
Answer: D
NEW QUESTION 46
......
Google LookML-Developer Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
Guaranteed Accomplishment with Newest Mar-2022 FREE: https://torrentvce.certkingdompdf.com/LookML-Developer-latest-certkingdom-dumps.html