Free LookML Developer Exam Braindumps (page: 6)

Page 5 of 13

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?

  1. Dashboard tiles and Looks will be automatically pointed to the orders Explore in model_b.
  2. Dashboard tiles and Looks will redirect to the new database connection.
  3. Dashboard tiles and Looks that rely on this Explore will be deleted.
  4. Dashboard tiles and Looks that rely on this Explore will return an error.

Answer(s): C



Business users report that an ephemeral derived table tile on the dashboard is slow.
Information about the dashboard includes:

The dashboard filter is linked to the user attributes.
This tile usually takes approximately 5 minutes to complete running.

Which solution should be used to improve the dashboard load time?

  1. Use a conditional WHERE clause for Development Mode.
  2. Build a user attribute filter into the Explore.
  3. Use index distribution_key or sort_key for this derived table.
  4. Persist the derived table.

Answer(s): D


Reference:

https://docs.looker.com/reference/dashboard-reference



A developer has created a persistent derived table that tracks new or updated orders and they want to cache the results. The cache should be refreshed whenever some new order is available on the underlying datasource table my tablename or at least every 24 hours.

Which datagroup definition will refresh the cache as expected?





Answer(s): A



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?





Answer(s): B






Post your Comments and Discuss Google LookML Developer exam with other Community members:

LookML Developer Exam Discussions & Posts