70-467 Question #67: Real Exam Question with Answer & Explanation

The correct answer is A: Restore the SSAS databases from the latest backup to SSAS01.. Restoring SSAS databases from backup is the correct method to provision them onto a standalone SSAS instance for testing.

Question

You need to use SQL Server Management Studio (SSMS) to make the SSAS databases available for application testing. What should you do?

Options

ARestore the SSAS databases from the latest backup to SSAS01.
BScript the databases as a Create script to a new window and then execute the script on
CDetach the SSAS databases from the SSASCIuster, and then attach them to SSAS01.
DUse the Import/Export Wizard to copy the databases from the production server to the

Explanation

Restoring SSAS databases from backup is the correct method to provision them onto a standalone SSAS instance for testing.

Common mistakes.

B. A Create script generated from SSAS in SSMS produces the schema definition only - it does not include partition data or aggregations, so the restored database would be empty of data.
C. SSAS multidimensional databases do not support a detach/attach operation like SQL Server relational databases; this option does not exist for SSAS.
D. The Import/Export Wizard is a SQL Server Integration Services tool designed for relational data movement and cannot copy or migrate SSAS cube databases.

Concept tested. SSAS database backup and restore to test server

Reference. https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/backup-and-restore-of-analysis-services-databases

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice