nerdexam
Microsoft

70-467 · Question #67

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

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.

Plan business intelligence (BI) infrastructure

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

How the community answered

(36 responses)
  • A
    89% (32)
  • B
    3% (1)
  • C
    3% (1)
  • D
    6% (2)

Why each option

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

ARestore the SSAS databases from the latest backup to SSAS01.Correct

SSAS supports backup (.abf files) and restore operations that faithfully replicate the full database structure, partitions, and aggregations to a target server. Restoring from the latest backup to SSAS01 gives the test environment an accurate, self-contained copy of the production database.

BScript the databases as a Create script to a new window and then execute the script on

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.

CDetach the SSAS databases from the SSASCIuster, and then attach them to SSAS01.

SSAS multidimensional databases do not support a detach/attach operation like SQL Server relational databases; this option does not exist for SSAS.

DUse the Import/Export Wizard to copy the databases from the production server to the

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

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

Topics

#SSAS database restore#SSMS#database availability#testing environment

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-467 Practice