LookML-Developer 試験問題を無料オンラインアクセス

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.Writhe the query form user_facts into a common table expression (WITH user_facts AS...).
• D.Use ${user_facts.SQL_TABLE_NAME} to reference the user_facts derived table.

Users report that the main dashboard has been slow to show results.
Which two options should the developer evaluate to improve dashboard performance? (Choose two.)

• A.Amount of data rendered for each query
• B.Format used to deliver these reports
• C.Number of queries used by the dashboard
• D.Ratio of visualizations to text tiles
• E.Number of databases used by dashboard elements

A developer needs to add an Explore built off of the orders view, which surfaces only completed orders. An orders Explore exists that contains all order information. Fields from the orders view are also referenced in other existing views such as ${orders.fieldname}.
How should developer define a new Explore for completed orders and keep all field references working correctly?
A)

B)

C)

D)

• A.Option D
• B.Option B
• C.Option A
• D.Option C

A developer would like to add a new dimension of type: yesno for the enabled column in their users table. The column is of type: string in the database and returns yes and no values.
How should the developer define the yesno dimension?
A)

B)

C)

D)

• A.Option D
• B.Option B
• C.Option A
• D.Option C

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?
A)

B)

C)

D)

• A.Option D
• B.Option B
• C.Option A
• D.Option C