When UNDROP is blocked due to a name collision, what operation enables restoring the previous version?

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

Multiple Choice

When UNDROP is blocked due to a name collision, what operation enables restoring the previous version?

Explanation:
UNDROP must recreate the dropped object using its original name, so that name must be free. When something already exists with that name, the restore is blocked. Renaming the existing object to a different name frees up the original name, allowing UNDROP to reconstruct the previously dropped object under that name. After the restore, you can rename things again if needed. Dropping the conflicting object would remove it entirely, not just let UNDROP proceed; creating a new object with a different name doesn’t free up the original name; clearing the cache has no effect on object metadata or UNDROP.

UNDROP must recreate the dropped object using its original name, so that name must be free. When something already exists with that name, the restore is blocked. Renaming the existing object to a different name frees up the original name, allowing UNDROP to reconstruct the previously dropped object under that name. After the restore, you can rename things again if needed. Dropping the conflicting object would remove it entirely, not just let UNDROP proceed; creating a new object with a different name doesn’t free up the original name; clearing the cache has no effect on object metadata or UNDROP.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy