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 B
• B.Option D
• C.Option C
• D.Option A

Comment: *

Name: *

Email: *

Verification: *

Users must be able to click on the Country field in their Explore and be redirected to another Explore that shows all countries compared.
Which parameter should be added to the country dimension to create a connection to this other associated Explore?

• A.link
• B.drill_fields
• C.url_encode
• D.tags

Comment: *

Name: *

Email: *

Verification: *

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.Add a description parameter to each field with context so that users can search key terms.
• D.Create a separate project for each business unit containing only the fields that the unit needs.
• E.Use a derived table to show only the relevant fields.

Comment: *

Name: *

Email: *

Verification: *

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.Use an access_filter parameter to automatically apply filters.
• C.Limit the filter suggestions using the suggestions parameter.
• D.Add persistence to the base view of the Explore.

Comment: *

Name: *

Email: *

Verification: *

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.Write a subquery in the FROM clause and alias with ${user_facts}.
• B.Copy the name of the database table in the scratch schema for the user_facts derived table.
• C.Use ${user_facts.SQL_TABLE_NAME} to reference the user_facts derived table.
• D.Writhe the query form user_facts into a common table expression (WITH user_facts AS...).

Comment: *

Name: *

Email: *

Verification: *