DP-300 · Question #345
DP-300 Question #345: Real Exam Question with Answer & 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 Properti
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
Options
- taskEnsure that db1 is compatible with all the features and syntax of SQL Server 2012 (View or change the compatibility level of db1 to SQL Server 2012)
- prerequisitesSign in to the virtual machine. SQL Server Management Studio and the Azure portal may be needed.
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
Community Discussion
No community discussion yet for this question.