When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
When a database containing stored procedures and regular views with fully qualified table references is cloned, the cloned stored procedures and views will continue to refer to the tables in the source database. Fully qualified table references include the database name, schema, and table name, ensuring that the references remain tied to the original source database, not the cloned database.
Fully Qualified table reference means, specifying the table name like the below, <DB>.<Schema>.<TableName>. The questions says, the DB containing stored procedures and regular views (reason it was told a regular view is, for secure view the table cross reference across DB needs a REFERENCE GRANT) that have a fully qualified table references. If its a not a qualified name, then the Table will be looked into the current DB, which is the DB in which the cloned SP and Views are created.
https://docs.snowflake.com/en/sql-reference/sql/create-clone.html
D. The stored procedures and views will refer to tables in the source database
For sure D. Just tested this.
Not A for sure, D