[Oct 31, 2021] LookML-Developer Practice Exam Dumps - 99% Marks In Google Exam
Updated Verified LookML-Developer Q&As - Pass Guarantee or Full Refund
NEW QUESTION 30
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. Add an always_filter parameter to restrict the filter suggestions.
- B. Add persistence to the base view of the Explore.
- C. Use an access_filter parameter to automatically apply filters.
- D. Limit the filter suggestions using the suggestions parameter.
Answer: D
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 D
- B. Option B
- C. Option A
- D. Option C
Answer: D
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 D
- B. Option B
- C. Option A
- D. Option C
Answer: A
NEW QUESTION 33
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 34
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 selects the primary key from the base view, and look for duplicates.
- B. Create a query that selects all the fields from the table, and sort by primary key.
- C. Create a query that counts how many occurrences of the primary key value are in the base view, and sort by count.
- D. Create a query that concatenates two columns to create a compound primary key.
Answer: D
NEW QUESTION 35
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 sql_trigger_value parameter of user_facts to select the current date plus one hour, so it triggers an hour after orders_rollup.
- B. Change the orders_rollup view reference to the literal table name from the database's scratch schema.
- C. Change the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.
- D. Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}
Answer: C
NEW QUESTION 36
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 37
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. Multiple account HTTPS
- B. A bare Git repository
- C. Single account HTTPS
- D. SSH
Answer: D
NEW QUESTION 38
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 group_label parameter to relevant fields to organize them into logical categories.
- B. Use the hidden parameter to remove irrelevant fields from the Explore.
- C. Use a derived table to show only the relevant fields.
- D. Create a separate project for each business unit containing only the fields that the unit needs.
- E. Add a description parameter to each field with context so that users can search key terms.
Answer: A,C,E
NEW QUESTION 39
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 40
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 41
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 B
- C. Option A
- D. Option C
Answer: C
NEW QUESTION 42
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 43
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 everything between "<<<<<< HEAD" and ">>>>>> branch 'master'"
- C. Remove "<<<<<< HEAD", "======", and ">>>>>> branch 'master'"
- D. Remove "<<<<<< HEAD", "======", and everything following "======"
Answer: B
NEW QUESTION 44
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. Set definition
- C. Fields parameter
- D. Hidden parameter
Answer: A
NEW QUESTION 45
A LookML developer has created a model with many Explores in it. Business users are having a difficult time locating the Explore they want in the long list displayed.
Which two actions can the LookML developer take to improve the user interface? (Choose two.)
- A. Combine the Explores into just a few Explores that each join to many views.
- B. Apply the fields parameter so that each Explore has fewer fields in it.
- C. Apply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.
- D. Apply the group_label parameter to organize the Explores under different headings.
- E. Modify the business users' roles so they do not have this model in their model set.
Answer: A,E
NEW QUESTION 46
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 47
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 48
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 D
- B. Option B
- C. Option A
- D. Option C
Answer: C
NEW QUESTION 49
......
LookML-Developer Real Valid Brain Dumps With 51 Questions: https://www.braindumpspass.com/Google/LookML-Developer-practice-exam-dumps.html
