Big Halloween Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Snowflake SnowPro Core Certification Exam COF-C02 Question # 261 Topic 27 Discussion

Snowflake SnowPro Core Certification Exam COF-C02 Question # 261 Topic 27 Discussion

COF-C02 Exam Topic 27 Question 261 Discussion:
Question #: 261
Topic #: 27

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.