SQL Database/Data Warehouse

Question 1

Provide access to a developer that needs to run queries on a Azure SQL Database with a single database

Answer 1

Create a server-level firewall rule and ensure that outbound TCP port 1433 is open on the developer’s computer.
You should not ensure that inbound TCP port 1433 is open on the developer’s computer because it exposes to malicious attacks.

Question 2

Point-to-Site connection

Answer 2

Used when you need to access Azure SQL Database managed instance from a computer. This connection is a VPN connection that allows you to access the private IP address used by managed instance

Question 3

ExpressRoute

Answer 3

Is used to extend on-premises private network to Azure over a connectivity provider.

Question 4

Pricing Azure Data Warehouse

Answer 4

Billed by cluster hour and storage used. The compute costs are separated by the storage so that it can be paused when not in use.