Question 10
A pipeline builds disposable intermediate tables from data that can be regenerated. The team wants to avoid the seven-day Fail-safe storage period. Which table category fits best?
Explanation
Correct Answer
Transient tables have no Fail-safe period, but offer less disaster-recovery protection.
Incorrect Answers
Permanent tables retain Fail-safe and warehouse size is unrelated.
Views generally do not replace physical intermediate-table persistence.
Search optimization affects certain query patterns rather than table recovery class.