You administer a Microsoft SQL Server 2012 database. You want to make a full backup of the database to a file on disk.

In doing so, you need to output the progress of the backup.

Which backup option should you use?

A. STATS

B. COMPRESSION

C. CHECKSUM

D. IN IT

Explanation:

STATS is a monitoring option of the BACKUP command.

STATS [ =percentage ]

Displays a message each time another percentage completes, and is used to gauge progress. If percentage is omitted, SQL Server displays a message after each 10 percent is completed.

The STATS option reports the percentage complete as of the threshold for reporting the next interval. This is at approximately the specified percentage; for example, with STATS=10, if the amount completed is 40 percent, the option might display 43 percent. For large backup sets, this is not a problem, because the percentage complete moves very slowly between completed I/O calls.

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql