Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 1 Question 131 Discussion

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?
B) BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (COPY_ONLY, STATS=5, COMPRESSION);
A) BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (Differential, STATS=5, COMPRESSION);
C) BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (File_Snapshot, STATS=5, COMPRESSION);
D) BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (NoInit, STATS=5, COMPRESSION);

Microsoft DP-300 Exam - Topic 1 Question 131 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 131
Topic #: 1
[All DP-300 Questions]

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?

Show Suggested Answer Hide Answer
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

by Charolette at Jun 16, 2026, 10:21 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Rolf
23 days ago
I agree with D. It ensures we don’t overwrite existing backups.
upvoted 0 times
...
Celeste
29 days ago
I’m leaning towards B. COPY_ONLY is useful to avoid affecting the backup chain.
upvoted 0 times
...
Leontine
1 month ago
I think option D is the best choice. NoInit is important for a full backup.
upvoted 0 times
...
Shawnee
1 month ago
Not sure about that, I thought you needed to use NoInit for full backups.
upvoted 0 times
...
Erasmo
1 month ago
Definitely B, COPY_ONLY is key here!
upvoted 0 times
...
Rex
2 months ago
Wait, can you really back up from a secondary like that?
upvoted 0 times
...
Wynell
2 months ago
I think A is better since it mentions Differential.
upvoted 0 times
...
Caitlin
2 months ago
Option B is the right choice for a full backup on a secondary replica.
upvoted 0 times
...
Lavonna
2 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.
upvoted 0 times
...
Gladys
2 months ago
I vaguely remember that using Differential wouldn't work for a full backup, so I think A is definitely not the answer.
upvoted 0 times
...
Kirby
3 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.
upvoted 0 times
...
Marsha
3 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.
upvoted 0 times
...

Save Cancel