Snowflake SnowPro Advanced: Data Engineer Certification Exam DEA-C01 Question # 16 Topic 2 Discussion

Snowflake SnowPro Advanced: Data Engineer Certification Exam DEA-C01 Question # 16 Topic 2 Discussion

DEA-C01 Exam Topic 2 Question 16 Discussion:
Question #: 16
Topic #: 2

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_daysset 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?


A.

undrop database xyz;


B.

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


C.

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


D.

Create a Snowflake Support case lo restore the database and tab e from "a i-safe


Get Premium DEA-C01 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.