You need to roll back the compatibility level of the Research database.What should you do?
A.
Restore a backup of the previous version of the database.
B.
Use an ALTER DATABASE statement to set the compatibility option.
C.
Change the CompatibilityLevel property in the XMLA script, and then execute the script.
D.
In SQL Server Management Studio (SSMS), change the compatibility level in the database properties
OK
Hello MicrosoftAnswer,
how should we understand your answer? Please help.
Thanks
C
https://msdn.microsoft.com/en-us/library/gg471593.aspx
I would say D
Actually, it is D for SQL Server. BUT! For SSAS u cannot revert to 1050, so you need to use a backup. So the question here is: what kind of database? What SQL Version?
https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/compatibility-level-of-a-multidimensional-database-analysis-services
Warning+
Setting the database compatibility to a higher level is irreversible. After you increase the compatibility level to 1100, you must continue to run the database on newer servers. You cannot rollback to 1050. You cannot attach or restore an 1100 database on a server version that is earlier than SQL Server 2012 or SQL Server 2017.
B
Alter Database XXXX set compatibility level = 100
I actually did it through D.
Several times.