Google Exam LookML-Developer Topic 2 Question 16 Discussion

Actual exam question for Google's LookML-Developer exam

Question #: 16
Topic #: 2

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 Suggested Answer

Suggested Answer: A

by Nieves at May 07, 2022, 11:39 PM

Limited Time Offer

25%

Off

Get Premium LookML-Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!