You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. During your leave, you have given a
Domain.com user named Mia Hamm permission to keep the database snapshots. You need to
make sure that Mia Hamm has the appropriate rights assigned to remove database snapshots.
What should you do?
A.
You should allow Mia Hamm to use UPDATE.
B.
You should allow Mia Hamm to use DROP DATABASE.
C.
You should allow Mia Hamm to use INSERT ANY DATASPACE.
D.
You should allow Mia Hamm to use RECREATE.