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.
Modify the Advanced Data Security settings of Db1
B.
Configure the Firewalls and virtual networks settings for SQLserver1
C.
Copy the ADO.NET connection string of Db1 and paste the string to the query editor
D.
Approve private endpoint connections for SQLserver1
Suggested Answer:B🗳️
Reference: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-portal Implement Authentication and Secure Data
It B...
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-portal
Configure network settings:
If you get one of the following errors in the query editor: Your local network settings might be preventing the Query Editor from issuing queries. Please click here for instructions on how to configure your network settings, or A connection to the server could not be established. This might indicate an issue with your local firewall configuration or your network proxy settings, the following important information should help resolve:
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.
When creating a new SQL Database resource (DBaaS) the default network settings won't allow any access. To allow access from your (client) IP follow this steps
- Goto "Firewalls and virtual networks"
- Click on "Add client IP"
Thats it... you can now move to the database and login via the query editor
So, to be sure we need to check the query then if will get error we can configure the firewall. So why need to go to the firewall first, check it if the port is not blocking. I think to be in a short we can just run a small query to be sure.
So as it shows from the link provided we see that:
Configure network settings
If you get one of the following errors in the query editor: Your local network settings might be preventing the Query Editor from issuing queries. Please click here for instructions on how to configure your network settings, or A connection to the server could not be established. This might indicate an issue with your local firewall configuration or your network proxy settings, the following important information should help resolve.
And this means we need to check the query first.
Technically B & D are correct.
From the same article:
"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."
"If you have Private Link connection, The Query Editor works without needing to add the Client Ip address into the SQL Database firewall"
Option B.
The query editor uses ports 443 and 1443 to communicate. Ensure you have enabled outbound HTTPS traffic on these ports. You will also need to add your outbound IP address to the server's allowed firewall rules to access your databases and data warehouses.
This section is not available anymore. Please use the main Exam Page.AZ-300 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.
ant2ant
Highly Voted 5 years, 1 month ago[Removed]
Highly Voted 4 years, 12 months agoSergiySlv
Most Recent 5 years, 1 month agoP0d
5 years, 1 month agoP0d
5 years, 1 month agon0t4u2c
5 years, 1 month agovrana
5 years, 1 month agoipindado2020
4 years, 9 months agoAnujD
5 years, 1 month agotartar
4 years, 9 months ago