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?
A. Change the sql_trigger_value parameter of user_facts to select the current date plus one hour, so it triggers an hour after orders_rollup.
B. Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}
C. Change the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.
D. Change the orders_rollup view reference to the literal table name from the database’s scratch schema.
|
Download Printable PDF. VALID exam to help you PASS. |
 |