Administering a SQL Database Infrastructure — Question 94

You administer a Microsoft SQL Server 2016 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?

Answer options

• A. STATS
• B. COMPRESSION
• C. CHECKSUM
• D. IN IT

Correct answer: A

Explanation

The correct answer is A. The STATS option allows you to see the progress of the backup operation. The other options, COMPRESSION and CHECKSUM, relate to data integrity and size reduction but do not provide feedback on the backup's progress, while IN IT is irrelevant in this context.