HOTSPOT
You have a SQL Server database that contains all of the sales data for your company.
Users of the database report the following issues:
– Connections to the database fail when the users first attempt to connect in the morning.
– Inserting new records in the database takes longer than expected.
You need to resolve the issues.
Which two database properties should you modify? To answer, select the appropriate properties in the answer area.
Answer:
Explanation:
When Auto Close is enabled, the database is automatically shut down when the last user connection is ended. When a new connection is made to the database, the database automatically restarts. Auto Close should be disabled on production databases.
When Auto Shrink is enabled, SQL Server will check the database every 30 minutes, and shrink it if the database has too much unused space.
References: https://www.red-gate.com/simple-talk/sql/database-administration/database-properties-healthcheck/