Administering Relational Databases on Microsoft Azure (DP-300) Test 2
© examsiri.com
Question : 34 of 40
Marks:
+1,
-0
DRAG DROP
You have an Azure subscription that contains the resources shown in the following table.
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? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
Select and Place:
Statements :
1.
2.
You have an Azure subscription that contains the resources shown in the following table.
| Name | Type | Description |
|---|---|---|
| SQL1 | SQL Server on Azure Virtual Machines | Not applicable |
| db1 | Microsoft SQL Server database | Hosted on SQL1 |
| mysqlbackups | General purpose v2 storage account | Not applicable |
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? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
Select and Place:
Statements :
1.
2.
3.
4.
5.
6.
Go to Question: