Microsoft
70-432 · Question #22
You are the administrator of a SQL Server 2008 instance. There is a database named DB1 in the instance. There are data file and the transaction log file on the E: drive. You find that there is only…
The correct answer is C. You should run the following Transact-SQL statement. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. There is a database named DB1 in the instance. There are data file and the transaction log file on the E: drive. You find that there is only 6% spare space. Both files have to be moved to the V: drive. Which procedure should you use?
Options
- AYou should run the following Transact-SQL statement:
- BYou should terminate the SQL Server Service.
- CYou should run the following Transact-SQL statement:
- DYou should terminate the SQL Server service.
How the community answered
(63 responses)- A6% (4)
- B16% (10)
- C75% (47)
- D3% (2)
Community Discussion
No community discussion yet for this question.