Microsoft
DP-300 · Question #310
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
The correct answer is B. full. Backups, only a full database backup can be performed on the master database. https://learn.microsoft.com/en-us/sql/relational-databases/databases/master-database?view=sql-
Submitted by suresh_in· Mar 6, 2026Plan and configure a high availability and disaster recovery (HA/DR) environment
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?
Options
- Alog
- Bfull
- Cdifferential
- Dtail-log
How the community answered
(25 responses)- A8% (2)
- B80% (20)
- C8% (2)
- D4% (1)
Explanation
Backups, only a full database backup can be performed on the master database. https://learn.microsoft.com/en-us/sql/relational-databases/databases/master-database?view=sql-
Community Discussion
No community discussion yet for this question.