70-467 · Question #64
You need to roll back the compatibility level of the Research database. What should you do?
The correct answer is A. Restore a backup of the previous version of the database. Rolling back an SSAS database compatibility level requires restoring a backup because compatibility upgrades are irreversible through properties alone.
Question
You need to roll back the compatibility level of the Research database. What should you do?
Options
- ARestore a backup of the previous version of the database.
- BUse an ALTER DATABASE statement to set the compatibility option.
- CChange the CompatibilityLevel property in the XMLA script, and then execute the script.
- DIn SQL Server Management Studio (SSMS), change the compatibility level in the database
How the community answered
(36 responses)- A89% (32)
- B3% (1)
- C6% (2)
- D3% (1)
Why each option
Rolling back an SSAS database compatibility level requires restoring a backup because compatibility upgrades are irreversible through properties alone.
In SQL Server Analysis Services (SSAS), the compatibility level cannot be lowered once upgraded - it is a one-way operation. The only supported method to revert to a previous compatibility level is to restore a backup taken before the upgrade was applied.
ALTER DATABASE sets the compatibility level for a relational SQL Server database engine, not for an Analysis Services multidimensional or tabular database.
Changing CompatibilityLevel in an XMLA script cannot lower the level below the current value - SSAS will reject a downgrade attempt via XMLA.
The SSMS database properties dialog for SSAS does not allow reducing the compatibility level because the upgrade is irreversible in place.
Concept tested: SSAS database compatibility level rollback
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/compatibility-level-of-a-multidimensional-database-analysis-services
Topics
Community Discussion
No community discussion yet for this question.