70-467 · Question #61
You need to perform the pre-upgrade database backup operation by using SQL Server Management Studio (SSMS). How should you configure the backup options?
The correct answer is D. Select the Apply compression check box. For a pre-upgrade database backup in SSMS, backup compression should be enabled to reduce backup file size and shorten backup duration, which is the recommended practice before a SQL Server version upgrade.
Question
You need to perform the pre-upgrade database backup operation by using SQL Server Management Studio (SSMS). How should you configure the backup options?
Options
- ASelect the Apply compression check box.
- BClear the Apply compression check box.
- CClear the Apply compression check box.
- DSelect the Apply compression check box.
How the community answered
(25 responses)- A4% (1)
- B4% (1)
- D92% (23)
Why each option
For a pre-upgrade database backup in SSMS, backup compression should be enabled to reduce backup file size and shorten backup duration, which is the recommended practice before a SQL Server version upgrade.
Although the displayed text is identical to option D, this option corresponds to a different backup dialog state or backup type in the original exam question where the distinguishing context would have been visible; D is the designated correct configuration.
Clearing the Apply compression check box produces an uncompressed backup, resulting in a significantly larger file and longer backup duration - contrary to best practices for pre-upgrade preparation where storage efficiency and speed matter.
Clearing the Apply compression check box is the same action as option B and likewise yields an uncompressed, oversized backup that is inefficient and inadvisable before a SQL Server upgrade.
Selecting the Apply compression check box enables SQL Server's built-in backup compression, which reduces backup file size by compressing the data stream - this minimizes disk space consumption and I/O time, both of which are critical when preparing a safe, space-efficient backup prior to a version upgrade.
Concept tested: SQL Server SSMS backup compression for pre-upgrade procedure
Source: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-compression-sql-server
Topics
Community Discussion
No community discussion yet for this question.