DP-300 Certification Practice Question #244

Question

You deploy an instance of SQL Server on Azure Virtual Machines: named SQL1 that hosts multiple databases.

You configure the full recovery model for all the databases.

You perform a full backup of the master database on SQL1.

You need to a perform an additional backup of the master database on SQL1. The solution must minimize how long it takes to perform the backup.

Which type of backup should you perform?

Accepted Answer

In SQL Server, the master database has unique backup restrictions. Specifically, only full database backups can be performed on the master database. Differential database backups and transaction log backups are not supported, regardless of the recovery model configured for the database. Therefore, even though the objective is to minimize the time taken, options A (log), C (differential), and D (tail-log) are technically impossible to perform on the master database. A full backup is the only valid and supported option.

More DP-300 practice questions