Microsoft Exam DP-300 Topic 3 Question 99 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 99
Topic #: 3

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?

Atail-log

Bdifferential

Cfull

Dlog

Show Suggested Answer

Suggested Answer: B

by Sylvia at Sep 13, 2024, 12:54 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lemuel

6 months ago

I'm going to go with 'C' for 'Completely confused'. Seriously, who comes up with these questions? I need a vacation.

upvoted 0 times

Ollie

6 months ago

I'm pretty sure it's 'B' for differential.

upvoted 0 times

...

Dean

6 months ago

No, I believe it's 'D' for log.

upvoted 0 times

...

Bettina

6 months ago

I think the answer is 'A' for tail-log.

upvoted 0 times

...

Frank

7 months ago

I agree with Henriette, a full backup would be the most efficient choice in this scenario.

upvoted 0 times

...

Henriette

7 months ago

I think a full backup would be the best option to minimize the time taken.

upvoted 0 times

...

Leonie

7 months 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.

upvoted 0 times

...

Benedict

7 months 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.

upvoted 0 times

Lemuel

5 months ago

'D' it is. Log backups are the most efficient for minimizing backup time.

upvoted 0 times

...

Verdell

5 months ago

Definitely 'D'. Log backups are the fastest way to backup the master database.

upvoted 0 times

...

Nickie

6 months ago

I think 'D' is the best option too. It's the most straightforward choice.

upvoted 0 times

...

Mable

6 months ago

I agree, 'D' is the way to go. Log backups are quick and efficient.

upvoted 0 times

...

Casie

7 months 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?

upvoted 0 times

...

Diane

7 months ago

Hmm, I don't know. A full backup might be overkill, but it would give you the most comprehensive coverage. Decisions, decisions...

upvoted 0 times

Sylvie

6 months ago

C) full

upvoted 0 times

...

Norah

6 months ago

B) differential

upvoted 0 times

...

Janessa

7 months ago

A) tail-log

upvoted 0 times

...

Alex

7 months ago

I disagree, I believe a differential backup would be more efficient.

upvoted 0 times

...

Arthur

7 months 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.

upvoted 0 times

Delisa

6 months ago

D) log

upvoted 0 times

...

Teddy

6 months ago

C) full

upvoted 0 times

...

Beth

6 months ago

B) differential

upvoted 0 times

...

Kathrine

7 months ago

A) tail-log

upvoted 0 times

...

Zana

7 months ago

I think we should perform a tail-log backup.

upvoted 0 times

...

Raina

7 months 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.

upvoted 0 times

Elke

7 months ago

Actually, for minimizing the time it takes to perform the backup, a tail-log backup would be more efficient.

upvoted 0 times

...

Francesco

7 months ago

C) full

upvoted 0 times

...

Dorsey

7 months ago

Definitely! A tail-log backup is the best option for this scenario.

upvoted 0 times

...

Jeff

7 months ago

A) tail-log

upvoted 0 times

...