Snowpro Advanced Architect · Free Practice Question Medium
Question 6
When cloning a schema with a foreign key constraint, what happens?
- A A. The constraint is removed in the cloned schema.
- B B. The foreign key references the source table only.
- C C. The cloned table references the corresponding cloned table if present.
- D D. The foreign key constraint is suspended.
Reveal correct answer
Correct answer: C
Explanation
Foreign key constraints in a cloned schema reference the corresponding cloned table if available.A. Incorrect, constraints are retained.
B. Incorrect, it may reference cloned or source depending on context.
C. Correct, foreign keys in the clone reference the corresponding cloned table if present.
D. Incorrect, it is not suspended.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
