If an object with the same name already exists when attempting UNDROP, what must you do to restore the previous version?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

If an object with the same name already exists when attempting UNDROP, what must you do to restore the previous version?

Explanation:
UNDROP restores the dropped object to its original name, so that name must be free. If something already uses that name, you can’t complete the restore. Renaming the existing object frees up the original name while preserving the current version, letting you perform the UNDROP to bring back the previously dropped object under that name. Deleting the current object would discard its data, and creating a new object with a different name won’t reclaim the original name. So renaming is the right step to restore the previous version.

UNDROP restores the dropped object to its original name, so that name must be free. If something already uses that name, you can’t complete the restore. Renaming the existing object frees up the original name while preserving the current version, letting you perform the UNDROP to bring back the previously dropped object under that name. Deleting the current object would discard its data, and creating a new object with a different name won’t reclaim the original name. So renaming is the right step to restore the previous version.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy