Snowflake SnowPro Core Certification Exam COF-C02 Question # 215 Topic 22 Discussion

Snowflake SnowPro Core Certification Exam COF-C02 Question # 215 Topic 22 Discussion

COF-C02 Exam Topic 22 Question 215 Discussion:
Question #: 215
Topic #: 22

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.

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.


Get Premium COF-C02 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.