You have an Azure SQL database named Db1 that runs on an Azure SQL server named SQLserver1. You need to ensure that you can use the query editor on the Azure portal to query Db1. What should you do?
A.
Copy the ADO.NET connection string of Db1 and paste the string to the query editor.
B.
Approve private endpoint connections for SQLserver1.
C.
Modify the Advanced Data Security settings of Db1.
D.
Configure the Firewalls and virtual networks settings for SQLserver1.
1) The query editor uses ports 443 and 1443 to communicate. Ensure you have enabled outbound HTTPS traffic on these ports. You also need to add your outbound IP address to the server's allowed firewall rules to access your databases and data warehouses.
2) If you have a Private Link connection, the Query Editor works without needing to add the Client Ip address into the SQL Database firewall.
For public connections to query editor, you need to add your outbound IP address to the server's allowed firewall rules to access your databases and data warehouses.
https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-query-portal
A connection to the server could not be established. This might indicate an issue with your local firewall configuration or your network proxy settings
Answer is D
What is Azure SQL?
https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview
Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs
So what is "Azure SQL Server" on the question?
This is because the query editor uses port 443 and 1443 to communicate. You will need to ensure you have enabled outbound HTTPS traffic on these ports.
Azure SQL Server vs Azure SQL instances vs Azure SQL Database. The questions does say "that runs on an Azure SQL server" I think that is the assumption they want us to make.
This section is not available anymore. Please use the main Exam Page.AZ-303 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
azurecert2021
Highly Voted 4 years, 7 months agoPradeepWaragoda
3 years, 8 months agoSanjSL
3 years, 8 months agokopper2019
Highly Voted 4 years, 7 months agous3r
4 years, 1 month agojustfordevelopment
Most Recent 3 years, 4 months agoERROR505
3 years, 5 months agomoon2351
3 years, 5 months agoedmacoar123
3 years, 8 months agosyu31svc
3 years, 11 months agoMinhajR
3 years, 11 months agoLinus0
4 years, 1 month agonfett
4 years, 1 month agoJuwon
4 years, 4 months ago777Jason777
4 years, 6 months agolevo017
4 years, 5 months agoddb116
4 years, 2 months agolasgidi
4 years, 7 months ago