MENU
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?
Suggested Answer: B
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
43 comments · newest first
RE
Rebbecca
11 months ago
Full backups take too long, so not a good choice!
RO
Rodolfo
11 months ago
I agree, log backups are the way to go here.
LI
Lizbeth
11 months ago
Wait, can you even do a tail-log backup on the master database?
CO
Colette
12 months ago
Definitely log backups for minimizing time!
MA
Major
12 months ago
A differential backup would be faster after a full backup.
DA
Daniel
1 year ago
I feel like I should go with the differential backup, but I also remember that log backups are meant for point-in-time recovery. I just can't recall which one is faster in this case.
AF
Afton
1 year ago
I practiced a similar question where we had to choose between full and log backups. I think a log backup would be the fastest option since it only captures the transaction log changes.
GL
Glendora
1 year ago
I'm a bit unsure about the tail-log backup. I think it's used for specific scenarios, but I'm not sure if it's the best choice here.
LE
Leota
1 year ago
I remember that the full backup captures everything, but it takes longer. I think a differential backup might be quicker since it only backs up changes since the last full backup.
EL
Eliz
1 year ago
I'm feeling pretty confident about this one. The key is that we need to minimize the time it takes to perform the backup, and since we've already done a full backup, the log backup is the most efficient choice.
CA
Carisa
1 year ago
I'm not entirely sure about this one. The full recovery model is throwing me off a bit. I'll need to think through the backup types and their characteristics to determine the best option.
TW
Twana
1 year ago
Okay, I've got this. Since the question is asking for a backup that minimizes the time, and we've already done a full backup of the master database, the log backup is the way to go. That should be the quickest option.
AM
Amos
1 year ago
Hmm, I'm a bit confused. The question mentions the full recovery model, so I'm not sure if a differential backup is the best option here. I might need to double-check the details on the different backup types.
AL
Alyce
1 year ago
This looks like a straightforward backup question. I think the key is to minimize the time it takes to perform the backup, so I'll probably go with the differential backup option.
LE
Lemuel
2 years ago
I'm going to go with 'C' for 'Completely confused'. Seriously, who comes up with these questions? I need a vacation.
OL
Ollie
2 years ago
I'm pretty sure it's 'B' for differential.
DE
Dean
2 years ago
No, I believe it's 'D' for log.
BE
Bettina
2 years ago
I think the answer is 'A' for tail-log.
FR
Frank
2 years ago
I agree with Henriette, a full backup would be the most efficient choice in this scenario.
HE
Henriette
2 years ago
I think a full backup would be the best option to minimize the time taken.
LE
Leonie
2 years ago
A tail-log backup? What is this, amateur hour? That's like using a spoon to dig a hole. Log backup all the way, my friends.
BE
Benedict
2 years ago
I'm just going to go with 'D' and call it a day. Log backups are the way to go, and I'm not overthinking this. Simple and effective, that's my motto.
LE
Lemuel
2 years ago
'D' it is. Log backups are the most efficient for minimizing backup time.
VE
Verdell
2 years ago
Definitely 'D'. Log backups are the fastest way to backup the master database.
NI
Nickie
2 years ago
I think 'D' is the best option too. It's the most straightforward choice.
MA
Mable
2 years ago
I agree, 'D' is the way to go. Log backups are quick and efficient.
CA
Casie
2 years ago
Log backup, duh! That's the obvious choice when you're working with the full recovery model. What are the other options even doing here?
DI
Diane
2 years ago
Hmm, I don't know. A full backup might be overkill, but it would give you the most comprehensive coverage. Decisions, decisions...
SY
Sylvie
2 years ago
C) full
NO
Norah
2 years ago
B) differential
JA
Janessa
2 years ago
A) tail-log
AL
Alex
2 years ago
I disagree, I believe a differential backup would be more efficient.
AR
Arthur
2 years ago
I think a differential backup would be the best option. It's faster than a full backup and still gives you the protection you need.
DE
Delisa
2 years ago
D) log
TE
Teddy
2 years ago
C) full
BE
Beth
2 years ago
B) differential
KA
Kathrine
2 years ago
A) tail-log
ZA
Zana
2 years ago
I think we should perform a tail-log backup.
RA
Raina
2 years ago
A tail-log backup is definitely the way to go here. It's quick and easy, and will get the job done without any fuss.
EL
Elke
2 years ago
Actually, for minimizing the time it takes to perform the backup, a tail-log backup would be more efficient.
FR
Francesco
2 years ago
C) full
DO
Dorsey
2 years ago
Definitely! A tail-log backup is the best option for this scenario.
JE
Jeff
2 years ago
A) tail-log