A permanent table and temporary table have the same name, TBL1, in a schema.

Snowflake COF-C03 Question Answer

What will happen if a user executes select * from TBL1 ;?

The temporary table will take precedence over the permanent table.

The permanent table will take precedence over the temporary table.

An error will say there cannot be two tables with the same name in a schema.

The table that was created most recently will take precedence over the older table.

COF-C03 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"