Looker certifications LookML-Developer Practice Test Engine: Try These 51 Exam Questions
Guaranteed Success in Looker certifications LookML-Developer Exam Dumps
NEW QUESTION 27
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 28
A developer needs to add an Explore built off of the orders view, which surfaces only completed orders. An orders Explore exists that contains all order information. Fields from the orders view are also referenced in other existing views such as ${orders.fieldname}.
How should developer define a new Explore for completed orders and keep all field references working correctly?
A)
B)
C)
D)
- A. Option D
- B. Option B
- C. Option A
- D. Option C
Answer: D
NEW QUESTION 29
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 30
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 31
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 32
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 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
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 35
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 36
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. Create an ephemeral derived table from the user's query.
- B. Add persist_for: "24 hours" to the orders Explore.
- C. Create an Explore with users as the base table.
- D. Create a persistent derived table from the user's query.
Answer: C
NEW QUESTION 37
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 38
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 redirect to the new database connection.
- B. Dashboard tiles and Looks that rely on this Explore will be deleted.
- C. Dashboard tiles and Looks will be automatically pointed to the orders Explore in model_b.
- D. Dashboard tiles and Looks that rely on this Explore will return an error.
Answer: B
NEW QUESTION 39
A developer is defining the users table within a view file in Looker. The users table will be available as an individual Explore and it will also be joined into other Explores, such as the products Explore. The developer needs to limit the fields visible in the products Explore without affecting the visibility of the fields in the users Explore.
How should the developer meet this requirement?
- A. Create duplicate dimensions and measures, one for the users Explore and one for the products Explore, and use the hidden parameter to modify the visibility of the fields.
- B. Create two view files for the users table. One view file will have all possible fields for the users Explore, and the other will have only the fields required for the products Explore.
- C. Use the hidden parameter in the users view file for the fields that should not come over to the products Explore and leave the users Explore as is.
- D. Use the fields parameter at the join level for the products Explore to specify which fields should be included and leave the users Explore as is.
Answer: D
NEW QUESTION 40
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 41
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. Ratio of visualizations to text tiles
- B. Number of databases used by dashboard elements
- C. Format used to deliver these reports
- D. Number of queries used by the dashboard
- E. Amount of data rendered for each query
Answer: A,D
NEW QUESTION 42
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. Fiscal_month_offset
- C. Convert_tz
- D. Week_start_day
Answer: B
NEW QUESTION 43
......
Test Engine to Practice LookML-Developer Test Questions: https://www.itpassleader.com/Google/LookML-Developer-dumps-pass-exam.html