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

B. 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.

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

D. Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}