Snowflake Exam DEA-C01 Topic 1 Question 7 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 7
Topic #: 1

Database XYZ has the data_retention_time_in_days parameter set to 7 days and table xyz.public.ABC has the data_retention_time_in_days set to 10 days.

A Developer accidentally dropped the database containing this single table 8 days ago and just discovered the mistake.

How can the table be recovered?

Aundrop database xyz;

Bcreate -able abc_restore as select * from xyz.public.abc at {offset => -60*60*24*8};

Ccreate table abc_restore clone xyz.public.abc at (offset => -30G*24*3);

DCreate a Snowflake Support case lo restore the database and tab e from 'a i-safe

Show Suggested Answer

Suggested Answer: B

External functions must be scalar functions. A scalar external function returns a single value for each input row.

by Caitlin at Jul 08, 2023, 11:44 PM

Limited Time Offer

25%

Off

Get Premium DEA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Tiffiny

3 months ago

I'm leaning towards Option B, but I'd double-check the syntax. Restoring from a specific offset could be tricky.

upvoted 0 times

Micaela

1 months ago

Let's go with Option B for now and see if we can successfully recover the table.

upvoted 0 times

...

Janey

1 months ago

Creating a clone of the table with Option C might also work, but it seems more complex.

upvoted 0 times

...

Lorriane

1 months ago

I agree, but we should definitely verify the syntax before proceeding.

upvoted 0 times

...

Annita

2 months ago

I think Option B is the way to go. It seems like the most straightforward solution.

upvoted 0 times

...

Teddy

3 months ago

Haha, Option A really made me chuckle. 'Undrop database xyz' - like that's going to work! Good one.

upvoted 0 times

...

Ben

3 months ago

Hmm, Option C is interesting, but 30G? That's a lot of space. Is that really necessary for just 8 days' worth of data?

upvoted 0 times

Paola

1 months ago

D) Create a Snowflake Support case lo restore the database and table from \'a i-safe\'

upvoted 0 times

...

Glendora

1 months ago

Yeah, it's better to be safe than sorry when it comes to data recovery.

upvoted 0 times

...

Orville

1 months ago

C) create table abc_restore clone xyz.public.abc at (offset => -30G*24*3);

upvoted 0 times

...

Galen

2 months ago

That does seem like a lot of space, but maybe it's needed for some reason.

upvoted 0 times

...

Sophia

2 months ago

C) create table abc_restore clone xyz.public.abc at (offset => -30G*24*3);

upvoted 0 times

...

Dana

2 months ago

B) create -able abc_restore as select * from xyz.public.abc at {offset => -60*60*24*8};

upvoted 0 times

...

Ngoc

2 months ago

A) undrop database xyz;

upvoted 0 times

...

Noemi

3 months ago

I'd go with Option D. Creating a Snowflake Support case is the safest bet here. I don't want to risk messing up the database further.

upvoted 0 times

Clement

2 months ago

Let's not take any chances, let's create a Snowflake Support case to restore the database and table.

upvoted 0 times

...

Ulysses

3 months ago

I think we should go with Option D as well. It's better to be safe than sorry.

upvoted 0 times

...

Vanda

3 months ago

I agree, creating a Snowflake Support case seems like the best option.

upvoted 0 times

...

Skye

4 months ago

Option B looks promising, but I'm not sure about the syntax. Shouldn't it be 'create table abc_restore as select * from xyz.public.abc at (offset => -60*60*24*8)'?

upvoted 0 times

Nobuko

2 months ago

Sounds good, let's give it a try and see if we can recover the table successfully.

upvoted 0 times

...

Vallie

2 months ago

I agree, let's go with option B and try to recover the table using that syntax.

upvoted 0 times

...

Chauncey

2 months ago

I think option B is the best choice to recover the table.

upvoted 0 times

...

Blair

2 months ago

Yes, you are correct. The syntax should be 'create table abc_restore as select * from xyz.public.abc at (offset => -60*60*24*8)'.

upvoted 0 times

...

Huey

2 months ago

Sounds like a plan. Let's hope it works and we can recover the table successfully.

upvoted 0 times

...

Eliseo

2 months ago

Let's proceed with Option B and try to recover the table.

upvoted 0 times

...

Avery

2 months ago

I agree, let's go ahead and try using Option B to recover the table.

upvoted 0 times

...

Lelia

3 months ago

I think Option B is the best choice. We should go with that.

upvoted 0 times

...

Billy

3 months ago

That makes sense. Option B seems like the best choice to recover the table.

upvoted 0 times

...

Christiane

3 months ago

Yes, you are correct. The syntax should be 'create table abc_restore as select * from xyz.public.abc at (offset => -60*60*24*8)'.

upvoted 0 times

...

Verlene

3 months ago

Yes, you are correct. The syntax should be 'create table abc_restore as select * from xyz.public.abc at (offset => -60*60*24*8)'.

upvoted 0 times

...

Dianne

4 months ago

I see your point, but I still think option B makes more sense in this scenario

upvoted 0 times

...

William

4 months ago

I disagree, I believe the correct answer is C) create table abc_restore clone xyz.public.abc at (offset => -30G*24*3)

upvoted 0 times

...

Dianne

4 months ago

I think the answer is B) create -able abc_restore as select * from xyz.public.abc at {offset => -60*60*24*8}

upvoted 0 times

...

Hortencia

4 months ago

Hmm, that makes sense too. Let's see what others think before deciding

upvoted 0 times

...

Tiera

4 months ago

I disagree, I believe the correct answer is D) Create a Snowflake Support case to restore the database and table from a backup

upvoted 0 times

...

Hortencia

4 months ago

I think the answer is B) create -able abc_restore as select * from xyz.public.abc at {offset => -60*60*24*8}

upvoted 0 times

...