Exam DP-300 topic 6 question 54 discussion

Actual exam question from Microsoft's DP-300

Question #: 54
Topic #: 6

DRAG DROP
-

You have an Azure virtual machine named Server1 that contains an instance of Microsoft SQL Server 2022 named SQL1.

SQL1 contains two databases named DB1 and DB2.

You need to take a snapshot backup of DB1 and DB2. The backup must NOT disrupt the backup chain and must NOT affect other databases.

Which three Transact-SQL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.

Show Suggested Answer

Suggested Answer:

by 04db10c at June 29, 2024, 11:57 a.m.

Comments

Submit Cancel

Christian_garcia_martin

3 days, 17 hours ago

box 2 and 3 are correct . For box 1 need to be COPY_ONLY - ALTER SERVER CONFIGURATION SET SUSPEND_FOR_SNAPSHOT_BACKUP = ON (GROUP = (db1, db2), MODE = COPY_ONLY);

upvoted 1 times

...

2f5c7cd

8 months ago

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-transact-sql-snapshot-backup?view=sql-server-ver16#workflow

upvoted 1 times

voodoo_sh

6 months, 2 weeks ago

Provided answer is wrong imho. Should be: C. ALTER SERVER CONFIGURATION SET SUSPEND_FOR_SNAPSHOT_BACKUP = ON (GROUP = (db1, db2), MODE = COPY_ONLY); A. BACKUP GROUP db1, db2 TO DISK = 'D:\Temp\db.bkm' WITH METADATA_ONLY, FORMAT; E. ALTER SERVER CONFIGURATION SET SUSPEND_FOR_SNAPSHOT_BACKUP = OFF;

upvoted 1 times

...

04db10c

11 months, 2 weeks ago

Key is "The backup must NOT disrupt the backup chain and must NOT affect other databases." hence we need a copy only bak. Answer D, A and E

upvoted 1 times

04db10c

11 months, 2 weeks ago

Sorry just realized Snapshot back is similar like copy only backup and will not impact the exisiting log chain, , Hence answer is correct

upvoted 3 times

...