Answer-first summary for fast verification
Answer: The temporary table will take precedence over the permanent table.
According to Snowflake documentation and the community discussion with unanimous consensus (100% agreement), when a temporary table and a permanent table have the same name in the same schema, the temporary table takes precedence over the permanent table for all operations within the session. This is a documented Snowflake behavior where temporary tables shadow permanent tables with identical names. Option A correctly states this precedence, while option B is incorrect as it reverses the precedence. Option C is wrong because Snowflake allows tables with the same name but different types (temporary vs permanent). Option D is incorrect as creation time does not determine precedence - the table type (temporary vs permanent) is what matters.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A permanent table and a temporary table with the same name, TBL1, exist in the same schema. What is the result of executing the query SELECT * FROM TBL1;?
A
The temporary table will take precedence over the permanent table.
B
The permanent table will take precedence over the temporary table.
C
An error will say there cannot be two tables with the same name in a schema.
D
The table that was created most recently will take precedence over the older table.
No comments yet.