Snowflake Exam COF-R02 Topic 1 Question 29 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 29
Topic #: 1

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

AThe cloned views and the stored procedures will reference the cloned tables in the cloned database.

BAn error will occur, as views with qualified references cannot be cloned.

CAn error will occur, as stored objects cannot be cloned.

DThe stored procedures and views will refer to tables in the source database.

Show Suggested Answer

Suggested Answer: B

by Wayne at Apr 25, 2024, 07:58 PM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Devora

2 days ago

I think option A is the correct answer. The cloned views and stored procedures should reference the cloned tables in the new database.

upvoted 0 times

...

Loren

20 days ago

But what if the stored procedures and views refer to tables in the source database?

upvoted 0 times

...

Vanda

27 days ago

I disagree, I believe an error will occur because views with qualified references cannot be cloned.

upvoted 0 times

...

Loren

28 days ago

I think the cloned views and stored procedures will reference the cloned tables in the cloned database.

upvoted 0 times

...