AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: SQL Server has always had configuration options azure video

Question 1 Be Honest
« Back   Next dp-300-database-admin-assoc Certification Question »
Answer

Full Certification Question

SQL Server has always had configuration options that were set at the database level. For example, the recovery model has always been a database setting, but as more complex features have been introduced to the database, more options have been added. Many of these options are tied to the compatibility level of the database, which is itself a database level configuration option. Database configuration options break down into two groups, with a minor difference: Options configured by the ALTER DATABASE SCOPED CONFIGURATION syntax in T-SQL Options configured by the ALTER DATABASE syntax in T-SQL Database scoped options were introduced in SQL Server 2016, and allow configuration of several options. Which options were formerly configured at the server level? (Select four)