
Answer-first summary for fast verification
Answer: Schema, Table
The UNDROP command in Snowflake can directly restore specific objects that have been dropped. According to Snowflake documentation and the community consensus with 100% agreement and upvoted comments, the UNDROP command supports: UNDROP SCHEMA (option A) and UNDROP TABLE (option D). These are explicitly listed as supported UNDROP operations. Other options are not directly restorable using UNDROP: Views (B) cannot be undropped directly, Internal stages (C) don't have UNDROP support, Users (E) and Roles (F) are account-level objects that don't use the UNDROP command for restoration.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.