nerdexam
Microsoft

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.

Plan business intelligence (BI) infrastructure

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)
  • A
    4% (1)
  • B
    4% (1)
  • D
    92% (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.

ASelect the Apply compression check box.

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.

BClear the Apply compression check box.

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.

CClear the Apply compression check box.

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.

DSelect the Apply compression check box.Correct

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

#backup compression#SSMS#database backup#upgrade preparation

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice