Microsoft
70-433 · Question #48
You are the administrator of a SQL Server 2008 instance with a database named DB1. When you are absent, a user will use a login named Mary to log in and maintain the database snapshots. The user has…
The correct answer is C. DROP DATABASE. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named DB1. When you are absent, a user will use a login named Mary to log in and maintain the database snapshots. The user has to delete the database snapshots for DB1, so you have to give the appropriate permissions to the user. Which database permission should you give the user?
Options
- ADELETE
- BCONTROL
- CDROP DATABASE
- DALTER ANY DATASPACE
How the community answered
(21 responses)- A14% (3)
- B5% (1)
- C76% (16)
- D5% (1)
Community Discussion
No community discussion yet for this question.