Snowflake Exam COF-R02 Topic 1 Question 9 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 9
Topic #: 1

[All COF-R02 Questions]

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

ASchema

BView

CInternal stage

DTable

EUser

FRole

Show Suggested Answer

Suggested Answer: C

by Laurel at Feb 06, 2023, 09:17 PM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Dalene

1 months ago

Hmm, I've got a gut feeling that the answer is D) Table and E) User. Although, if I could just drop and restore my boss, that would be pretty sweet.

upvoted 0 times

Vannessa

7 days ago

Haha, if only we could use it on people too!

upvoted 0 times

...

Alease

13 days ago

Yeah, those are the correct options for the UNDROP command.

upvoted 0 times

...

Matt

16 days ago

I think you're right, it's D) Table and E) User.

upvoted 0 times

...

Kimberlie

1 months ago

Wait, wait, wait. I think the answer is D) Table and B) View. Because, you know, who doesn't love a good ol' fashioned table restoration party?

upvoted 0 times

...

Bev

1 months ago

Oh, this is easy! The answer is clearly D) Table and C) Internal stage. I mean, who even uses views these days, right?

upvoted 0 times

...

Tijuana

1 months ago

Aha, I think I've got it! D) Table and F) Role. Restoring a view? That's like trying to put toothpaste back in the tube.

upvoted 0 times

Mammie

7 days ago

I always get confused with what can be restored using UNDROP, but now I know it's tables and roles.

upvoted 0 times

...

Shanda

27 days ago

Yeah, views and schemas cannot be restored directly. It's like trying to put toothpaste back in the tube.

upvoted 0 times

...

Kerry

1 months ago

I think you're right, D) Table and F) Role can be directly restored using the UNDROP command.

upvoted 0 times

...

Hana

2 months ago

I'm not sure about this. I think schemas and internal stages can also be restored using the UNDROP command.

upvoted 0 times

...

Kate

2 months ago

Hmm, let's see. I'd say the answer is D) Table and E) User. Can't restore a schema, that's just crazy talk!

upvoted 0 times

Stanford

27 days ago

Yeah, I agree. Restoring a schema does sound crazy!

upvoted 0 times

...

Joye

1 months ago

I think you're right, D) Table and E) User are the correct options.

upvoted 0 times

...

Emmanuel

2 months ago

I agree with Kate. Tables and views are the objects that can be restored using the UNDROP command.

upvoted 0 times

...

Kate

2 months ago

I think tables and views can be directly restored using the UNDROP command.

upvoted 0 times

...