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

1 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

Annita

5 days ago

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

upvoted 0 times

...

Teddy

1 months ago

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

upvoted 0 times

...

Ben

1 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

Ngoc

2 days ago

A) undrop database xyz;

upvoted 0 times

...

Noemi

1 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

17 days ago

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

upvoted 0 times

...

Ulysses

23 days ago

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

upvoted 0 times

...

Vanda

1 months ago

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

upvoted 0 times

...

Skye

2 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

Vallie

5 hours ago

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

upvoted 0 times

...

Chauncey

2 days ago

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

upvoted 0 times

...

Blair

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

6 days ago

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

upvoted 0 times

...

Eliseo

13 days ago

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

upvoted 0 times

...

Avery

15 days ago

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

upvoted 0 times

...

Lelia

25 days ago

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

upvoted 0 times

...

Billy

1 months ago

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

upvoted 0 times

...

Christiane

1 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

1 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

2 months ago

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

upvoted 0 times

...

William

2 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

2 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

2 months ago

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

upvoted 0 times

...

Tiera

2 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

3 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

...