QuestionQ104

VerifiedMonitor, configure, and optimize database resources

You have an Azure subscription containing the resources shown in the following table.

Question Image

You need to back up db1 to mysqlbackups and then restore the backup to a new database named db2 that is hosted on SQL1. The solution must ensure that db1 is backed up to a stripe set.

Which three Transact-SQL statements should you execute in sequence?

Drag & Drop
Explanation

A SAS-based SQL Server credential is named for the full Azure Blob container URL, and SQL Server automatically uses that credential for backup and restore URLs under that container. Multiple URL destinations in one BACKUP DATABASE command create a striped backup set. The restore must name every stripe and use MOVE to create db2 with its data and log files at the required physical paths.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!