Microsoft Exam DP-300 Topic 2 Question 11 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 11
Topic #: 2

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);

Show Suggested 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 Chanel at May 03, 2022, 08:27 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!