DP-300 Certification Practice Question #279

Question

You have a SQL Server on Azure Virtual Machines instance that hosts a database named DB1.

You need to configure the autogrow and autoshrink settings for DB1.

Which statements should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

In SQL Server, file-related properties (such as file size, maximum size, and file growth/autogrow increment) are configured for specific files using the `ALTER DATABASE MODIFY FILE` command, which belongs to the "File and Filegroup options". Database-wide behavior options (such as automatic shrinking) are configured using the `ALTER DATABASE SET

More DP-300 practice questions