DP-200 Exam QuestionsBrowse all questions from this exam

DP-200 Exam - Question 122


DRAG DROP -

You plan to create a new single database instance of Microsoft Azure SQL Database.

The database must only allow communication from the data engineer's workstation. You must connect directly to the instance by using Microsoft SQL Server

Management Studio.

You need to create and configure the Database. Which three Azure PowerShell cmdlets should you use to develop the solution? To answer, move the appropriate cmdlets from the list of cmdlets to the answer area and arrange them in the correct order.

Select and Place:

Exam DP-200 Question 122
Show Answer
Correct Answer:
Exam DP-200 Question 122

Step 1: New-AzureSqlServer -

Create a server.

Step 2: New-AzureRmSqlServerFirewallRule

New-AzureRmSqlServerFirewallRule creates a firewall rule for a SQL Database server.

Can be used to create a server firewall rule that allows access from the specified IP range.

Step 3: New-AzureRmSqlDatabase -

Example: Create a database on a specified server

PS C:\>New-AzureRmSqlDatabase -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01

References:

https://docs.microsoft.com/en-us/azure/sql-database/scripts/sql-database-create-and-configure-database-powershell?toc=%2fpowershell%2fmodule%2ftoc.json

Discussion

1 comment
Sign in to comment
Hotjo
Jun 14, 2021

Seems to be Correct Ans drop your subjection also

hello_there_
Jun 25, 2021

Is there a reason the order of the create db and create firewall rule can't be switched?

lgtiza
Jun 28, 2021

Yes, I think it can be switched, but it's just more natural that if you just created the server you configure the firewall rule with happens also at server level.

lgtiza
Jun 28, 2021

Yes, I think it can be switched, but it's just more natural that if you just created the server you configure the firewall rule with happens also at server level.