問題文
A team loads staging data that is rewritten every night and does not need to survive a system failure. Which table type reduces the storage the account pays for?
選択肢
- An external table over the staging files, which leaves the nightly files in cloud storage and charges the account only for the metadata.
- A transient table, which has no Fail-safe period and a maximum retention of one day.
- A temporary table, which exists only for the session and therefore is the right choice whenever a nightly pipeline writes data that the next night's run will replace anyway.
- A permanent table with the retention time set to zero, which removes the Fail-safe charge.