Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 6 question 39 discussion

Actual exam question from Microsoft's DP-300

Question #: 39
Topic #: 6

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?

A. log
B. full
C. differential
D. tail-log

Show Suggested Answer

Suggested Answer: B 🗳️

by HENRYARDILA at March 4, 2023, 3:34 a.m.

Comments

Submit Cancel

Vitos25

11 months ago

Master has a Simple recovery model hence B ONLY

upvoted 1 times

...

sca88

1 year, 3 months ago

Selected Answer: B

B is the correct answer https://learn.microsoft.com/en-us/sql/relational-databases/databases/master-database?view=sql-server-ver16

upvoted 1 times

...

Dalamain

1 year, 3 months ago

Answer needs to be corrected, its B - Full - Explained here: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-and-restore-of-system-databases-sql-server?view=sql-server-ver16

upvoted 1 times

...

jddc

1 year, 10 months ago

Selected Answer: B

you can only do a full backup of the master db

upvoted 1 times

...

bsk1983

1 year, 11 months ago

Selected Answer: B

tested Answer is B (FULL backup), you can ONLY take FULL backup on a master database

upvoted 1 times

...

bsk1983

1 year, 11 months ago

Selected Answer: B

You CAN NOT take differential or t-log backups on master database so, answer is FUll backup

upvoted 1 times

...

amazonalex

2 years, 3 months ago

answer is B. running differential/log backup will give you error: Msg 3024, Level 16, State 0, Line 1 You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database. Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally.

upvoted 3 times

...

dbasql

2 years, 4 months ago

Selected Answer: B

The correct answer: B 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-server-ver16

upvoted 3 times

U_C

2 years, 4 months ago

Just did a quick test to backup the "master" database. No matter the "master" database is in full recovery mode or "simple recovery mode", you only can do a full database backup. The correct answer is B.

upvoted 2 times