If a SQL Database is set up with a "public endpoint" without further configuration, which type of user can connect to the database?

Disable ads (and more) with a premium pass for a one time $4.99 payment

Distinguish yourself with the Microsoft Certified: Azure Data Fundamentals certification. Enhance your skills with flashcards and multiple choice questions with explanations and hints. Prepare effectively for your certification exam!

When a SQL Database is set up with a "public endpoint," it means that the database server is accessible over the internet. However, for users to actually connect to the SQL Database, they must be allowed through the firewall, which constitutes one of the primary security measures in Azure.

By default, Azure SQL Databases have a built-in firewall that denies all connections except for those that are explicitly permitted. This means that unless the firewall settings are configured to allow specific IP addresses or ranges, any user on the internet will not be able to connect to the database, even if it has a public endpoint.

Therefore, the statement that no users can connect unless the firewall is configured is accurate, making it the correct answer in this context. This concept highlights the importance of firewall rules in protecting access to data within cloud services, ensuring that only authorized users can connect to sensitive databases, even when providing publicly accessible endpoints.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy