A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1;?
A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1;?
When a permanent table and a temporary table have the same name within a schema, the temporary table takes precedence in queries executed within the session. This is because temporary tables are session-specific and all queries within that session will act upon the temporary table instead of the permanent table.
A is correct . All queries and other operations performed in the session on the table affect only the temporary table https://docs.snowflake.com/en/user-guide/tables-temp-transient#potential-naming-conflicts-with-other-table-types
A correct - https://docs.snowflake.com/en/user-guide/tables-temp-transient