問題文
A team needs a staging table for a nightly load. The data can be rebuilt from the source at any time, and the team wants to minimize storage cost. Which table type fits?
選択肢
- An external table over the source files, because reading the source directly removes the storage cost entirely.
- A temporary table, which persists across sessions with a shortened retention period and is dropped only when explicitly requested.
- A permanent table with the retention period set to zero, and that removes both the time travel window and the fail-safe period.
- A transient table, because it persists across sessions but carries no fail-safe period and therefore less storage overhead.