PrepAway - Latest Free Exam Questions & Answers

What should you do?

Your server hosts Microsoft SQL Server 2000 Analysis Services (SSAS) databases and cubes. You need to perform the migration of a database from Analysis Services 2000 to Analysis Services 2005. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Open a new SSAS project by using Business Intelligence Development Studio (BIDS). Right-click Project. Click the Add option, and then click the Existing Item option.

B.
Use Business Intelligence Development Studio (BIDS) to create a Deployment script. Use the .configsettings file to point to files copied from the Analysis Services 2000 instance.

C.
Back up the Analysis Services 2000 database by using Enterprise Manager. Use Microsoft SQL Server Management Studio (SSMS) to restore the database to the SQL Server 2005 SSAS instance.

D.
Connect to the SQL Server 2005 SSAS instance by using Microsoft SQL Server Management Studio (SSMS). Right-click Instance in Object Explorer, and then click the Migrate Database option.


Leave a Reply