Snowflake
COF-R02 · Question #248
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
The correct answer is D. The stored procedures and views will refer to tables in the source database. See the full explanation below for the reasoning.
Question
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
Options
- AThe cloned views and the stored procedures will reference the cloned tables in the cloned
- 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.
How the community answered
(26 responses)- A8% (2)
- B4% (1)
- C19% (5)
- D69% (18)
Community Discussion
No community discussion yet for this question.