Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.