Home » Microsoft » 70-475 v.2 » What should you create?
You deploy a Microsoft Azure SQL database.
You create a job to upload customer data to the database.
You discover that the job cannot connect to the database and fails.
You verify that the database runs successfully in Azure.
You need to run the job successfully.
What should you create?
A. a virtual network rule
B. a network security group (NSG)
C. a firewall rule
D. a virtual network
Correct Answer: C
Explanation/Reference:
If the application persistently fails to connect to Azure SQL Database, it usually indicates an issue with one of the following:
Firewall configuration. The Azure SQL database or client-side firewall is blocking connections to Azure SQL Database.
Network reconfiguration on the client side: for example, a new IP address or a proxy server.
User error: for example, mistyped connection parameters, such as the server name in the connection string.
References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-troubleshoot-common-connection-issues