Answer-first summary for fast verification
Answer: The cloned table will reference the primary key in the source table.
The question specifically asks about cloning a table to a different database. According to Snowflake documentation and the community discussion consensus (with B receiving 83% of votes and detailed explanations), when tables are in separate databases or schemas, the cloned table with foreign key constraints references the primary key in the source table, not the cloned version. Option B correctly states this behavior. Option A is incorrect because not all referenced tables are necessarily cloned. Option C is partially correct but incomplete since it only mentions primary key references. Option D is incorrect because foreign key constraints are maintained and reference the source table's primary key, not lost entirely.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When a table is cloned into a different database, what is the status of its foreign key constraints?
A
All referenced tables will be cloned.
B
The cloned table will reference the primary key in the source table.
C
The cloned table will lose all references to the primary key.
D
The cloned table will lose all references to the foreign and primary keys
No comments yet.