Question 540
A short-lived staging table should be invisible to other sessions and disappear when its creating session ends. What is the most appropriate next design or operational decision?
Explanation
Correct Answer
A temporary table has session-scoped lifetime and is removed at the end of its session. Success should be confirmed by this scenario-specific evidence: the table is usable in its creating session but is not available as a persistent shared artifact later.
Incorrect Answers
Automatic suspension avoids continuous compute billing during genuine idle periods. In contrast, a temporary table has session-scoped lifetime and is removed at the end of its session.
A sequence provides a managed generator independent of scanning the target table for MAX values. In contrast, a temporary table has session-scoped lifetime and is removed at the end of its session.
Snowflake cloud services coordinate control-plane operations; virtual warehouses execute the compute-heavy portions of SQL. In contrast, a temporary table has session-scoped lifetime and is removed at the end of its session.





SnowPro Core COF-C03 Practice Tests