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
Should be A,B,E
https://lennilobel.wordpress.com/2014/05/11/using-powershell-to-manage-windows-azure-sql-database/
1
0
+1
0
0
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)
3
0