Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake Exam DEA-C01 Topic 1 Question 7 Discussion

Actual exam question for Snowflake's DEA-C01 exam
Question #: 7
Topic #: 1
[All DEA-C01 Questions]

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?

Show Suggested Answer Hide 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
18 days 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
...
Teddy
19 days ago
Haha, Option A really made me chuckle. 'Undrop database xyz' - like that's going to work! Good one.
upvoted 0 times
...
Ben
21 days 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
...
Noemi
29 days 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 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
8 days ago
I think we should go with Option D as well. It's better to be safe than sorry.
upvoted 0 times
...
Vanda
17 days ago
I agree, creating a Snowflake Support case seems like the best option.
upvoted 0 times
...
...
Skye
1 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
Lelia
10 days ago
I think Option B is the best choice. We should go with that.
upvoted 0 times
...
Billy
19 days ago
That makes sense. Option B seems like the best choice to recover the table.
upvoted 0 times
...
Christiane
21 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
...
Verlene
27 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
...
...
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
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
...

Save Cancel