Skip to main content
  1. Public practice questions
  2. AZ-900 Practice Exams | Azure Fundamentals
  3. Domain 2-Describe Azure architecture and services | AZ-900 Practice Exam | 399 Questions

Question 335 — Domain 2-Describe Azure architecture and services | AZ-900 Practice Exam | 399 Questions

Your company has deployed an Azure SQL Database with a public endpoint. The security team has flagged this as a concern due to potential public exposure, even though authentication is required. You are asked to ensure that only resources within your Azure Virtual Network and corporate office can access the database while completely disabling public access.

Which two actions should you take? (Select two answers)

  1. Enable a private endpoint for the Azure SQL Database.

  2. Configure an NSG rule to allow inbound traffic from the corporate office’s public IP.

  3. Set up a service endpoint for the Azure SQL Database.

  4. Disable the public endpoint for the Azure SQL Database.

  5. Deploy an Azure VPN Gateway and require users to connect before accessing the database.

Correct answers

  1. Enable a private endpoint for the Azure SQL Database.

  2. Disable the public endpoint for the Azure SQL Database.

Explanations

Correct:
Enable a private endpoint for the Azure SQL Database.
Private endpoints allow access to an Azure-managed service over a private IP address, eliminating public exposure.

Disable the public endpoint for the Azure SQL Database.
Once the private endpoint is enabled, disabling the public endpoint ensures that access is truly private.

Wrong:
Configure an NSG rule to allow inbound traffic from the corporate office’s public IP.
NSG rules do not secure access at the database level and still expose the service to public internet traffic.

Set up a service endpoint for the Azure SQL Database.
While service endpoints allow secure traffic from a VNet, they do not remove public exposure.

Deploy an Azure VPN Gateway and require users to connect before accessing the database.
This would allow access, but it does not eliminate public exposure of the SQL Database.