Microsoft Exam Questions

You need to roll back the compatibility level of the Research database.What should you do?

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