Question 160
For this Snowflake situation — A session-local scratch dataset must disappear automatically when the analyst's session ends. — the team adopts: Use a temporary table for session-scoped scratch data rather than permanent storage. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Review temporary object cleanup and naming practices in shared notebooks. It controls the recurring exposure associated with this mechanism: Temporary tables are scoped to their creating session and are removed when that session ends. The original action, use a temporary table for session-scoped scratch data rather than permanent storage., still needs operational checks when the environment or workload changes.
Incorrect Answers
This routine guards against another mechanism: Hybrid tables have transaction-oriented characteristics distinct from conventional analytic tables. The recurring exposure in the current case is: Temporary tables are scoped to their creating session and are removed when that session ends. The matching preventive check is “Review temporary object cleanup and naming practices in shared notebooks”.
The suggested review tracks a different technical risk: Cortex AI functions bring supported model inference into the Snowflake processing environment. Here the sustained control must address: Temporary tables are scoped to their creating session and are removed when that session ends. Choose “Review temporary object cleanup and naming practices in shared notebooks”.
This routine guards against another mechanism: Durable managed table storage scales independently of the virtual warehouse compute used to process queries. The recurring exposure in the current case is: Temporary tables are scoped to their creating session and are removed when that session ends. The matching preventive check is “Review temporary object cleanup and naming practices in shared notebooks”.