You need to open the firewall ports for use with SQL Server environment.
In table below, identify the firewall port that you must use for each service.
NOTE: Make only one selection in each column.

You plan to create a database in Microsoft Azure to manage sales data for an organization.
You need to create an Azure SQL Database that meets standard naming requirements.
Which names should you use? To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.

You administer a Microsoft SQL Server 2014 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.)

You need to display rows from the Orders table for the Customers row having the CustomerId value set to 1 in the following XML format.

Which Transact-SQL query should you use?

• A. SELECT OrderId, OrderDate, Amount, Name, CountryFROM OrdersINNER JOIN CustomersON Orders.CustomerIdCustomers.CustomerIdWHERE Customers.CustomerId= 1FOR XML AUTO, ELEMENTS
• B. SELECT OrderId, OrderDate, Amount, Name, CountryFROM OrdersINNER JOIN CustomersON Orders.CustomerId = Customers.CustomerIdWHERE Customers.CustomerId = 1FOR XML RAW, ELEMENTS
• C. SELECT Name, Country, Orderld, OrderDate, AmountFROM OrdersINNER JOIN CustomersON Orders.CustomerId= Customers.CustomerIdWHERE Customers.CustomerId= 1FOR XML AUTO, ELEMENTS
• D. SELECT Name AS `@Name', CountryAS `@Country', OrderId, OrderDate, AmountFROM OrdersINNER JOIN CustomersON Orders.CustomerId= Customers.CustomerIdWHERE Customers.CustomerId= 1FOR XML PATH (`Customers')
• E. SELECT Name, Country, Crderld, OrderDate, AmountFROM OrdersINNER JOIN CustomersON Orders.CustomerId= Customers.CustomerIdWHERE Customers.CustomerId= FOR XML AUTO, ELEMENTS
• F. SELECT OrderId, OrderDate, Amount, Name, CountryFROM OrdersINNER JOIN CustomersON Orders.CustomerId = Customers-CustomerIdWHERE Customers.CustomerId = 1FOR XML RAW
• G. SELECT Name AS `Customers/Name', CountryAS `Customers/Country', OrderId, OrderDate, AmountFROM OrdersINNER JOIN CustomersON Orders.CustomerId= Customers.CustomerIdWHERE Customers.CustomerId= 1FOR XML PATH (`Customers'
• H. SELECT OrderId, OrderDate, Amount, Name, CountryFROM OrdersINNER JOIN CustomersON Orders.CustomerId = Customers.CustomerIdWHERE Customers.CustomerId = 1FOR XML AUTO

Background
You are managing a multi-tenant environment hosted within Windows Azure. All changes to the database are pushed to a template database which is stored as a Microsoft Azure SQL database named ContosoTemplate which is stored on the virtual SQL Server named SQL1. You also have a virtual SQL Server named SQL2.
You are provisioning an Azure SQL Database instance named DB1. No Azure firewall rules have been created.
You plan to deploy the following databases to an elastic pool: EDB2, EDB3, EDB4, EDB5, and EDB6. All of the databases in the pool have the same peak usage period.
You migrate a SQL Server instance named SRV1 to an Azure DS-13 series virtual machine (VM). The VM has two premium disks that are allocated as a storage pool.
You plan to deploy a new Azure SQL Database named DB7 to support an application for your Human Resources (HR) department.
You need to create a server-level firewall rule for DB1.
Which Azure PowerShell cmdlet should you run? To answer, select the appropriate Azure PowerShell cmdlet in the answer area.