SnowPro Core Certification — Question 253

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

Answer options

• A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.
• B. An error will occur, as views with qualified references cannot be cloned.
• C. An error will occur, as stored objects cannot be cloned.
• D. The stored procedures and views will refer to tables in the source database.

Correct answer: D

Explanation

The correct answer is D because when you clone a database, the stored procedures and views maintain their original references to the tables in the source database. Options A, B, and C are incorrect; cloning does not change the references to the source tables, and views with qualified references can be cloned without generating errors.