LookML-Developer Looker LookML Developer Exam Dumps

Sample Question 4

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 sql_always_where parameter
D. A filtered measure

Show Answer Buy Now

---

Sample Question 5

A user reports an errormessage on an Explore: “Non-unique value/primary key (orsql_distinct_key), value overflow or collision when computing sum”.What should the LookML developer check for in the joined views of the Explore?

A. The sum measure used is defined correctly.
B. A unique primary key is defined in each view.
C. Symmetric_aggregates: no is not present in the Explore definition.
D. No concatenated primary keys are used.

Show Answer Buy Now

---

Sample Question 6

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? (Choosetwo.)

A. Apply the hidden parameter with a value of yes to Explores that only exist to powerspecific Looks, dashboards, or suggestion menus.
B. Modify the business users’ roles so they do nothave this model in their model set.
C. Combine the Explores into just a few Explores that each join to many views.
D. Apply the group_label parameter to organize the Explores under different headings.
E. Apply the fields parameter so that each Explore hasfewer fields in it.

Show Answer Buy Now

---

Sample Question 7

working on adding a new view to a project. Once both developers havefinished their work in the view, the changes will be pushed to production.Where should the developers write the LookML for this view?

A. In the master branch, with both users writing to the branch
B. In one user’s personal 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

Show Answer Buy Now

---

Sample Question 8

After running the Content Validator, a developer can seethe error “Unknown field”.Which two changes could cause this issue? (Choose two.)

A. View name was changed from users to customers.
B. Field type was changed from number to string.
C. Model name was changed from e_commerce to reporting.
D. Explore label was changed from users to customers.
E. Field name was changed from id to user_id.

Show Answer Buy Now

---

Sample Question 9

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 beused in an aggregate function.The developer checks the field definition and finds it to be:measure: discounted_sale_price {type: numbersql: ${sale_price} * 0.8 ;;}The developer also finds the LookML definition of the sale_price field to be:dimension: sale_price {type: numbersql: ${TABLE}.sale_price ;;}What isthe likely cause of the SQL error?

A. The discounted_sale_price field should have a group_by: yes parameter.
B. The sale_price field should be defined as a measure of type: number, not as adimension.
C. The underlying database table does not have a fieldcalled sale_price.
D. The discounted_sale_price field should be defined as a dimension of type: number, notas a measure.

Show Answer Buy Now

---

Sample Question 10

Users report that the main dashboard has been slow toshow 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. Ratio of visualizations to text tiles
D. Format used to deliver these reports
E. Amount of data rendered for each query

Show Answer Buy Now

---

Sample Question 11

A developer has a persistent derived table view called user_facts that contains aggregateddata for each user. The developer needs to query the data from this table in anotherderived table view called user_region_facts.Which strategy should the developer use to write the query for user_region_facts that willleverage the existing derived table?

A. Use ${user_facts.SQL_TABLE_NAME} to reference the user_facts derived table.
B. Copy the name of the database table inthe scratch schema for the user_facts derivedtable.
C. Writhe the query form user_facts into a common table expression (WITH user_factsAS...).
D. Write a subquery in the FROM clause and alias with ${user_facts}.

Show Answer Buy Now

---