What action he can take to recover the dropped Share?

Ryan, a Data Engineer, accidently drop the Share named SF_SHARE which results in immediate access revoke for all the consumers (i.e., accounts who have created a database from that SF_SHARE).

What action he can take to recover the dropped Share?
A . By Executing UNDROP command he could possibly recover the dropped Share SF_SHARE & its associated Databases for immediate consumer access.
B . He can recreate a share with the same name as a previous share which does restore the databases created (by any consumers) from the share SF_SHARE.
C . A dropped share cannot be restored. The share must be created again using the CRE-ATE SHARE command and then configured using GRANT <privilege> … TO SHARE and ALTER SHARE.
D . Consumer accounts that have created databases from the share will still be able to query these databases as Share is separate securable object & it’s still accessible using time travel feature.

View Answer

Answer: C

Explanation:

You can drop a share at any time using the DROP SHARE command.

Dropping a share instantly invalidates all databases created from the share by consumer accounts.

All queries and other operations performed on these databases will no longer work.

After dropping a share, you can recreate it with the same name;

however, this does not restore any of the databases created from the share by consumer accounts. The recreated share is treated as a new share and all consumer accounts must create a new database from the new share.