Which three cmdlets should you use?

You plan to implement a Microsoft Azure SQL database.
You need to create and manage the new database on a new server.
Which three cmdlets should you use? Each correct answer presents part of the solution.

You plan to implement a Microsoft Azure SQL database.
You need to create and manage the new database on a new server.
Which three cmdlets should you use? Each correct answer presents part of the solution.

A.
New-AzureSqlDatabaseServer

B.
New AzureSqlDatabaseServerFirewallRule

C.
New-AzureSqlDatabaseServerContext

D.
New-AzureVM

E.
New-AzureSqlDatabase

Explanation:
https://msdn.microsoft.com/en-us/library/dn546722.aspx

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

spguru

spguru

I think the answer should be B,C,E.

To create a DB you would have to run New-AzureSqlDatabaseServerContext, and I think we can ignore New-AzureSqlDatabaseServer (A) since it says “on a new server”, which makes it safe to assume that the server is already there. Hence, in order to create a DB on existing server, one would need to run the following commands:
New-AzureSqlDatabaseServerFirewallRule (B)
New-AzureSqlDatabaseServerContext (C)
New-AzureSqlDatabase (E)

Reply