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.

Reference: https://docs.looker.com/reference/view-params/sql_trigger_value