Microsoft DP-300 Exam - 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

Leatha

4 months ago

A is wrong, it should be a full backup, not differential!

upvoted 0 times

...

Chauncey

4 months ago

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

upvoted 0 times

...

Edda

4 months ago

Definitely going with B, makes the most sense!

upvoted 0 times

...

Fletcher

5 months ago

I thought COPY_ONLY was only for ad-hoc backups?

upvoted 0 times

...

Chan

5 months ago

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

upvoted 0 times

...

Thora

5 months ago

I feel like the NoInit option might be relevant here, but I can't recall the specifics. Did we cover that in our study sessions?

upvoted 0 times

...

Chaya

5 months ago

I'm not entirely sure, but I remember something about not using Differential for a full backup. Could it be option A?

upvoted 0 times

...

Valentine

5 months ago

I think we need to use the COPY_ONLY option since we're backing up from a secondary replica. That sounds familiar from practice questions.

upvoted 0 times

...

Lea

5 months ago

I practiced a similar question, and I think COPY_ONLY is the right choice to avoid affecting the backup chain. I hope I'm right!

upvoted 0 times

...

Titus

5 months ago

I'm a bit confused by the wording of the question. Do we need to remove access for the three profiles, or just make sure the change is in production? I'm not sure which option is the best approach.

upvoted 0 times

...

Chaya

5 months ago

I like the idea of starting with the baseline architecture using a bottom-up approach. That way we can get a good understanding of the current state before defining the target state. Then we can analyze the gaps and determine the roadmap.

upvoted 0 times

...

Golda

5 months ago

Okay, I remember learning about cause and effect diagrams in class. I believe they are used to map out the different factors that can contribute to an outcome, so the correct answer is probably A - determining the flow of a process.

upvoted 0 times

...