SIMULATION You have a legacy application written for Microsoft SQL Server 2012. The application will be the only application that accesses db1. You need to ensure that db1 is compatible with all the f

SIMULATION You have a legacy application written for Microsoft SQL Server 2012. The application will be the only application that accesses db1. You need to ensure that db1 is compatible with all the features and syntax of SQL Server 2012. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal. Answer: View or change the compatibility level of a database You can view or change the compatibility level of a database in SQL Server, Azure SQL Database, or Azure SQL Managed Instance by using SQL Server Management Studio or Transact-SQL. Use SQL Server Management Studio To view or change the compatibility level of a database using SQL Server Management Studio (SSMS) Step 1: Connect to the appropriate server or instance hosting your database [Here db1]. Step 2: Select the server name in Object Explorer. Step 3: Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database. Step 4: Right-click the database, and then select Properties. The Database Properties dialog box opens. Step 5: In the Select a page pane, select Options. The current compatibility level is displayed in the Compatibility level list box. Step 6: To change the compatibility level, select a different option from the list [Select SQL Server 2012] Reference: https://learn.microsoft.com/en-us/sql/relational-databases/databases/view-or-change-the- compatibility-level-of-a-database