Answer-first summary for fast verification
Answer: The stored procedures and views will refer to tables in the source database.
The correct answer is D because when cloning a database with stored procedures and views that have fully qualified table references (e.g., DB.Schema.Table), the cloned objects retain their original references to the source database tables rather than pointing to the cloned tables. This behavior is documented in Snowflake's CREATE CLONE documentation and confirmed by community testing. Option A is incorrect because the cloned objects do not reference the cloned tables. Options B and C are incorrect because cloning does not produce errors for qualified references or stored objects; it successfully creates the clone while preserving the original references.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When cloning a database that contains stored procedures and regular views with fully qualified table references, what will be the outcome?
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.
No comments yet.