SnowflakeSnowflake
COF-C02 · Question #309
COF-C02 Question #309: Real Exam Question with Answer & Explanation
The correct answer is A: The temporary table will take precedence over the permanent table.. In Snowflake, if a temporary table and a permanent table have the same name within the same schema, the temporary table takes precedence over the permanent table within the session where the temporary table was created.
Snowflake Cloud Data Platform Features and Architecture
Question
A permanent table and temporary table have the same name, TBL1, in a schema. What will happen if a user executes select * from TBL1 ;?
Options
- AThe temporary table will take precedence over the permanent table.
- BThe permanent table will take precedence over the temporary table.
- CAn error will say there cannot be two tables with the same name in a schema.
- DThe table that was created most recently will take precedence over the older table.
Explanation
In Snowflake, if a temporary table and a permanent table have the same name within the same schema, the temporary table takes precedence over the permanent table within the session where the temporary table was created.
Topics
#Temporary Tables#Table Types#Name Resolution#Schema Objects
Community Discussion
No community discussion yet for this question.