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%

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

...