Home » Microsoft » 70-765 » How should you complete the script?
HOTSPOT
You have a Microsoft Azure SQL Database server named server1-contoso.database.windows.net in a resource group named RG1.
You need to create an elastic pool.
How should you complete the script? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Explanation/Reference:
Explanation:
Box 1: New-AzureRmSqlServer
Create an Azure SQL Database logical server using the New-AzureRmSqlServer command. A logical server contains a group of databases managed as a group.
Example:
New-AzureRmSqlServer -ResourceGroupName $resourcegroupname `
-ServerName $servername `
-Location $location `etc.
Box 2: New-AzureRmSqlElasticPool
The New-AzureRmSqlElasticPool cmdlet creates an elastic database pool for an Azure SQL Database.
Example:
New-AzureRmSqlElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01" -Edition "Standard"
References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-powershell
https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/new-azurermsqlelasticpool?view=azurermps-6.8.0