Discuss Microsoft DP-300 Exam Topic 1 Question 131

You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica.

You need to initiate a full backup of DB1 on SQL2.

Which statement should you run?

ABACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/
mycontainer/DB1.bak' with (Differential, STATS=5, COMPRESSION);

BBACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/
mycontainer/DB1.bak' with (COPY_ONLY, STATS=5, COMPRESSION);

CBACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/
mycontainer/DB1.bak' with (File_Snapshot, STATS=5, COMPRESSION);

DBACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/
mycontainer/DB1.bak' with (NoInit, STATS=5, COMPRESSION);

Suggested Answer: B

BACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it's executed on secondary replicas. Copy-only backups don't impact the log chain or clear the differential bitmap.

Incorrect Answers:

A: Differential backups are not supported on secondary replicas. The software displays this error because the secondary replicas support copy-only database backups.

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/active-secondaries-backup-on-secondary-replicas-always-on-availability-groups

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Rolf 2 months ago

I agree with D. It ensures we don’t overwrite existing backups.

Celeste 2 months ago

I’m leaning towards B. COPY_ONLY is useful to avoid affecting the backup chain.

Leontine 3 months ago

I think option D is the best choice. NoInit is important for a full backup.

Shawnee 3 months ago

Not sure about that, I thought you needed to use NoInit for full backups.

Erasmo 3 months ago

Definitely B, COPY_ONLY is key here!

Rex 3 months ago

Wait, can you really back up from a secondary like that?

Wynell 3 months ago

I think A is better since it mentions Differential.

Caitlin 4 months ago

Option B is the right choice for a full backup on a secondary replica.

Lavonna 4 months ago

I feel like the answer is D because it allows for a full backup without affecting existing backups, but I’m not completely confident.

Gladys 4 months ago

I vaguely remember that using Differential wouldn't work for a full backup, so I think A is definitely not the answer.

Kirby 4 months ago

I think we practiced something similar where we had to consider the backup type. I feel like NoInit might be the right choice, but I can't recall the specifics.

Marsha 4 months ago

I remember that for a full backup, we usually don't want to use COPY_ONLY, but I'm not sure if it applies here since it's on a secondary replica.

Microsoft DP-300 Exam - Topic 1 Question 131 Discussion