Microsoft Exam DP-300 Topic 1 Question 80 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 80
Topic #: 1

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 Alecia at Nov 24, 2023, 09:18 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Roosevelt

8 months ago

You got that right, my friend. Although, I have to say, a log backup might be an interesting option too. Depends on how much data we're talking about, you know? Gotta weigh the pros and cons.

upvoted 0 times

...

Emilio

8 months ago

Definitely tail-log. Gotta love those quick backups, am I right? Saves us time for the more important things in life, like debating the merits of different backup types over a good cup of coffee.

upvoted 0 times

...

I agree, a tail-log backup seems like the way to go. It'll capture the latest changes to the database and minimize the backup time. Plus, it'll be a good complement to the full backup we already have.

upvoted 0 times

Jamie

7 months ago

I think a log backup might not be needed since we already did a full backup.

upvoted 0 times

...

Melodie

7 months ago

D) log

upvoted 0 times

...

Rima

8 months ago

Yeah, a tail-log backup will help minimize the backup time and complement the full backup.

upvoted 0 times

...

Elena

8 months ago

A) tail-log

upvoted 0 times

...

Olive

8 months ago

Shouldn't we go with a full backup to ensure we have all the data?

upvoted 0 times

...

Laurel

8 months ago

C) full

upvoted 0 times

...

Augustine

8 months ago

Great choice! A tail-log backup will capture the latest changes to the database.

upvoted 0 times

...

Merilyn

8 months ago

A) tail-log

upvoted 0 times

...

Vincent

8 months ago

Hmm, this is an interesting one. The master database is in full recovery model, so a full backup would be overkill. A differential backup would also take longer than needed. I think the best option here is a tail-log backup.

upvoted 0 times

...

Microsoft Exam DP-300 Topic 1 Question 80 Discussion

Contribute your Thoughts:

Roosevelt

Emilio

Sylvie

Jamie

Melodie

Rima

Elena

Olive

Laurel

Augustine

Merilyn

Vincent