Google Exam LookML-Developer Topic 1 Question 9 Discussion

Actual exam question for Google's Looker LookML Developer exam

Question #: 9
Topic #: 1

A LookML developer has written the following persistent derived table. It references orders_rollup, another persistent derived table that also rebuilds with the same SQL trigger value.

Which change is needed to guarantee that user_facts will always rebuild with the latest data from orders_rollup?

AChange the sql_trigger_value parameter of user_facts to select the current date plus one hour, so it triggers an hour after orders_rollup.

BChange the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}

CChange the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.

DChange the orders_rollup view reference to the literal table name from the database's scratch schema.

Show Suggested Answer

Suggested Answer: C

by Daren at May 07, 2022, 10:37 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!