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

Loren

14 days ago

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

upvoted 0 times

...

Vanda

21 days ago

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

upvoted 0 times

...

Loren

22 days ago

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

upvoted 0 times

...