Free Snowflake SnowPro-Core Actual Exam Questions - Question 11 Discussion
C/D? Since UNDROP only works if Time Travel is active, and the question doesn’t say so, I’d go with D as the default. B’s out because cloning isn’t restoring, it’s just copying. A doesn’t restore anything by itself, just enables a feature. So it really boils down to whether Time Travel is on or not, and without that detail, recreating (D) seems like the only guaranteed fix.
It’s C if Time Travel is enabled because UNDROP directly restores the dropped stage, which is cleaner than recreating it. If Time Travel isn’t on, then D makes sense since you have no rollback option. So without that info, I’d say C is the more precise restoration command when possible, not just recreating from scratch.
D imo, safest bet without Time Travel info is just to recreate the stage.
Good point about cloning (B) not actually restoring the original stage, just making a copy. So, it’s not really the answer here since the stage has to be restored, not duplicated. B seems off.
C/D? If Time Travel is on, UNDROP (C) is the obvious choice to restore a dropped stage. Without it, you’re stuck with recreating the stage (D). Options A and B don’t quite match restoration—Time Travel just enables recovery but doesn’t do it alone, and cloning a dropped stage isn’t a thing since it’s gone. So it really depends on whether Time Travel is enabled or not.
D imo, just recreate it.