Home » Microsoft » 70-473 v.2 » Which cmdlets should you use in the Azure PowerShell script?
DRAG DROP
You plan to prepare the environment for the planned new customers.
You need to deploy a base copy of DB1 for each customer in Azure.
Which cmdlets should you use in the Azure PowerShell script? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Correct Answer:
Explanation/Reference:
Explanation:
Box 1: Get-AzureRmSqlDatabase
The Get-AzureRmSqlDatabase cmdlet gets one or more Azure SQL databases from an Azure SQL Database Server.
Partial syntax:
Get-AzureRmSqlDatabase
[[-DatabaseName] <String>]
[-ServerName] <String>
[-ResourceGroupName] <String>
Box 2: Restore-AzureRmSqlDatabase
The Restore-AzureRmSqlDatabase cmdlet restores a SQL database from a geo-redundant backup, a backup of a deleted database, a long term retention backup, or a point in time in a live database. The restored database is created as a new database.
Partial syntax:
Restore-AzureRmSqlDatabase
[-FromLongTermRetentionBackup]
-ResourceId <String>
-ServerName <String>
-TargetDatabaseName <String>
[-Edition <String>]
[-ServiceObjectiveName <String>]
[-ElasticPoolName <String>]
[-AsJob]
[-LicenseType <String>]
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Reference:
https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/get-azurermsqldatabase?view=azurermps-6.7.0
https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/restore-azurermsqldatabase?view=azurermps-6.7.0