Question 490
A Snowflake administrator investigates the following production situation: A developer creates a TEMP table in one worksheet session and expects a different connection to see it by default. Which corrective action best addresses the stated problem?
Explanation
Correct Answer
The root issue is that a temporary table is scoped to the session that created it. The selected fix targets that condition: Use a suitable persistent shared object when cross-session visibility is required. Validate it by checking this outcome: The second authorized session queries the intended persistent data without relying on the first session.
Incorrect Answers
This action targets identifier case rules, where quoted identifiers preserve case while unquoted identifiers are normalized under standard rules. In the given incident, the decisive issue is instead that a temporary table is scoped to the session that created it.
This action targets apache iceberg catalog ownership, where externally managed Iceberg tables use an external catalog as the metadata authority. The corrective response here is “Use a suitable persistent shared object when cross-session visibility is required”; this alternative does not provide that response.
This action targets snowflake object context, where the session's current database and schema control unqualified object-name resolution. The stem reports a developer creates a TEMP table in one worksheet session and expects a different connection to see it by default; this control addresses a different failure condition.