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…

The correct answer is C. Process the databases. D. Change the DataDir property for the server. 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…

Maintain a BI Solution

Question

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.)

Options

AReboot the server.
BDetach and reattach each database.
CProcess the databases.
DChange the DataDir property for the server.

How the community answered

(28 responses)

A
11% (3)
B
4% (1)
C
86% (24)

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 re- process (or backup and restore). 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.

Topics

#SSAS storage management#DataDir property#database processing#capacity planning

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice