Microsoft
70-467 · Question #61
70-467 Question #61: Real Exam Question with Answer & Explanation
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.
Explanation
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.
Common mistakes.
- A. 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.
- B. 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.
- C. 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.
Concept tested. SQL Server SSMS backup compression for pre-upgrade procedure
Community Discussion
No community discussion yet for this question.