A developer creates a derived table and wants to add persistence to it. Because the table is not used on a frequent basis, the developer wants the table to be cached for 12 hours, but only when a user has queried it.
Which persistence parameter should be added to the derived table’s definition in order to satisfy this use case?
A. persist_with: “12 hours”
B. datagroup: 12_hours
{ max_cache_age: “12 hours”
}
C. persist_for: “12 hours”
D. sql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;