You are managing a SQL Server 2008 Analysis Services (SSAS) instance which includes a database for Company.com.
You alter the DataDir attribute of the instance to a new folder.
You should make sure that instance utilizes the new folder in least time.
Which is the correct answer?
A.
You should operate the database.
B.
You should operate the database at the same time.
C.
You should stop the Analysis Services service.
D.
Before stopping the Analysis Services service you should remove the files in the original folder,
Explanation:
Another wordingYou work as a database administrator at Domain.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) instance for Domain.com.
The SQL Server 2008 Analysis Services instance contains a database named CKOrders.
You decide to change the DataDir feature of the instance to a new folder. You need to accomplish this task in the least amount of time. What should you do?A. You should consider running the database.
B. You should consider running the database at the same time.
C. You should consider ceasing the Analysis Services service.
D. You should consider removing the files in the original folder prior to ceasing the Analysis Services.