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 Explore with users as the base table.

B. Create a persistent derived table from the user's query.

C. Create an ephemeral derived table from the user's query.

D. Add persist_for: “24 hours” to the orders Explore.

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. Option A

B. Option B

C. Option C

D. Option D

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 be automatically pointed to the orders Explore in model_b.

B. Dashboard tiles and Looks will redirect to the new database connection.

C. Dashboard tiles and Looks that rely on this Explore will be deleted.

D. Dashboard tiles and Looks that rely on this Explore will return an error.

A LookML developer has a transactions view with several measures that each perform complex calculations involving multiple fields. The LookML developer creates an Explore based on the transactions view. The product team wants to perform further functions on these measures, such as SUM, AVG, MIN, MAX, and RANK. The team wants these further functions to be performed at different levels of detail: weekly, monthly, and yearly.

How can the LookML developer model these requirements and minimize the amount of code rewriting?

A. Add measures to the transactions view of type: number to apply the required functions.

B. Change the existing measures in the transactions view to dimensions, and add measures of the different required types.

C. Create a constant for each measure so it can be reused across other areas of the LookML project.

D. Create native derived tables using transactions as the explore_source.

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. persist_with: “12 hours”

B. datagroup: 12_hours { max_cache_age: “12 hours” }

C. persist_for: “12 hours”

D. sql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;