SnowPro Core Certification — Question 1148

What happens to foreign key constraints when a table is cloned to another database?

Answer options

• 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

Correct answer: B

Explanation

The correct answer is B because when a table is cloned, it retains its structure, allowing it to reference the primary key from the source table. Options A and D are incorrect as they misrepresent the cloning process, and C is incorrect because the cloned table maintains its references to the primary key.