exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 6 question 1 discussion

Actual exam question from Microsoft's DP-200
Question #: 1
Topic #: 6
[All DP-200 Questions]

You have to create a new single database instance of Microsoft Azure SQL database. You must ensure that client connections are accepted via a workstation.
The workstation will use SQL Server Management Studio to connect to the database instance.
Which of the following Powershell commands would you execute to create and configure the database? (Choose three.)

  • A. New-AzureRmSqlElasticPool
  • B. New-AzureRmSqlServerFirewallRule
  • C. New-AzureRmSqlServer
  • D. New-AzureRmSqlServerVirtualNetworkRule
  • E. New-AzureRmSqlDatabase
Show Suggested Answer Hide Answer
Suggested Answer: BCE 🗳️
The Microsoft documentation clearly gives the steps to create and configure the database. Please note the below snippet shows the new powershell commands, but you can also use the older Azure PowerShell commands.

Since this is clearly given in the documentation, all other options are incorrect.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/scripts/sql-database-create-and-configure-database-powershell

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
jaykumarjkd99
3 years, 9 months ago
correct
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...