DP-300: Administering Microsoft Azure SQL Solutions

You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that contains two databases named DB1 and DB2. The database and log files for DB1 and DB2 are hosted on managed disks.

You need to perform a snapshot backup of DB1 and DB2.

How should you complete the T-SQL statements?

ALTER Select… CONFIGURATION
SET SUSPEND_FOR_SNAPSHOT_BACKUP = ON
(GROUP = (db1, db2));

BACKUP GROUP db1, db2
TO DISK = 'f:\backup\db.bkm'
WITH Select…, FORMAT;