You maintain a SQL Server 2008 Analysis Services (SSAS) server.
After several databases are deployed to the server, you notice that the drives are nearing
capacity.
You need to move the data to drives with more space.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
A.
Reboot the server.
B.
Detach and reattach each database.
C.
Process the databases.
D.
Change the DataDir property for the server.
Explanation:
C, D: Datadir is the folder that stores the database files that tells SSAS what databases it
has. It is also the default location for the data files for all your SSAS databases, but you can
set the StorageLocation property on objects like partitions to move them to a different
location.
If you change the DataDir property on the server you would need to re-deploy and reprocess (or backup and restore).
Incorrect:
Not B: You can use database Detach and Attach Method option to move database files from
one location to another location on the server. However, you would need to move them as
well.