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…

Submitted by lars.no· Mar 6, 2026Implement and Manage Databases - specifically configuring database properties such as compatibility level to support application requirements in SQL Server or Azure SQL environments (commonly tested in AZ-900, DP-300, or SQL Server certification exams).

Question

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

Explanation

To ensure db1 is compatible with all features and syntax of SQL Server 2012, you must change the database compatibility level to 110, which corresponds to SQL Server 2012. This is accomplished through SQL Server Management Studio by right-clicking the database, selecting Properties, navigating to the Options page, and setting the Compatibility Level dropdown to 'SQL Server 2012 (110)'. The compatibility level controls which T-SQL syntax and database engine behaviors are available, ensuring legacy applications function as expected without breaking changes introduced in newer SQL Server versions.

Topics

#Database Compatibility Level#SQL Server Management Studio (SSMS)#Azure SQL Database#Legacy Application Support

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice