Home » Microsoft » 70-765 » HOTSPOT
HOTSPOT
A company has an on-premises Microsoft SQL Server 2016 environment. All futures databases must meet the following requirements: The recovery model must be set to simple.
The compatibility level must be set to SQL server 2014 (120). Your need to configure the SQL server 2016 environment.
In the table below, identify the database you must modify for each requirement.
Hot Area:
Correct Answer:
Explanation/Reference:
Explanation:
Model: Change from full to simple Recovery Model
Newly created user databases use the same recovery model as the model database.
The model database is used as the template for all databases created on an instance of SQL Server. Because tempdb is created every time SQL Server is started, the model database must always exist on a SQL Server system. The entire contents of the model database, including database options, are copied to the new database.
Model: Set compatibility level to 120
For all installations of SQL Server, the default compatibility level is set to the version of the Database Engine. Databases are set to this level unless the model database has a lower compatibility level.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/databases/model-database?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-2017