Question No. 1

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?

ACreate an Explore with users as the base table.

BCreate a persistent derived table from the user's query.

CCreate an ephemeral derived table from the user's query.

DAdd persist_for: ''24 hours'' to the orders Explore.

Show Answer

Correct Answer: A

Question No. 2

The daily_forecast Explore used by the sales team needs to be cached for 24 hours. All other Explores used by the sales team need to be cached for one hour.

What is a scalable way to configure this caching logic?

ADefine two datagroups for the model. Apply persist_with at the model level with the datagroup for 1-hour caching, and apply persist_with to daily_forecast with the datagroup for 24-hour caching.

BDefine max_cache_age on daily_forecast Explores of 24 hours. Define max_cache_age on all other Explores for one hour.

CDefine two datagroups for the model. Create a persistent derived table (PDT) for the daily_forecast Explore, and apply datagroup_trigger to it using the datagroup for 24-hour caching.

DDefine for the model one datagroup that caches for 1 hour. Create a persistent derived table (PDT) for the daily_forecast Explore, and apply sql_trigger_value to it selecting the current date.

Show Answer

Correct Answer: A

Question No. 3

After validating LookML code, a developer receives the following error message:

''Unknown or Inaccessible Field users.name''

What is causing this error?

AThere is a missing join.

BThe field is set to ''hidden''.

CThe join relationship is incorrect.

DThe field uses incorrect SQL syntax.

Show Answer

Correct Answer: A

Question No. 4

A user reports an error message on an Explore: ''Non-unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum''.

What should the LookML developer check for in the joined views of the Explore?

AThe sum measure used is defined correctly.

BA unique primary key is defined in each view.

CSymmetric_aggregates: no is not present in the Explore definition.

DNo concatenated primary keys are used.

Show Answer

Correct Answer: C

Question No. 5

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.)