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

3 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

Romana

2 months ago

B) View

upvoted 0 times

...

Bette

2 months ago

A) Schema

upvoted 0 times

...

Vannessa

3 months ago

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

upvoted 0 times

...

Alease

3 months ago

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

upvoted 0 times

...

Matt

3 months ago

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

upvoted 0 times

...

Kimberlie

3 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

3 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

4 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

Leonie

2 months ago

It's important to know which objects can be restored easily, saves a lot of time and effort.

upvoted 0 times

...

Alonso

2 months ago

I always get confused with which objects can be restored, but now I know it's tables and roles.

upvoted 0 times

...

Lisandra

2 months ago

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

upvoted 0 times

...

Rory

2 months ago

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

upvoted 0 times

...

Micheal

2 months ago

It's important to remember which objects can be restored to avoid any mistakes in the future.

upvoted 0 times

...

Mammie

3 months 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

3 months ago

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

upvoted 0 times

...

Kerry

3 months ago

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

upvoted 0 times

...

Hana

4 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

4 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

3 months ago

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

upvoted 0 times

...

Joye

3 months ago

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

upvoted 0 times

...

Emmanuel

4 months ago

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

upvoted 0 times

...

Kate

4 months ago

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

upvoted 0 times

...