Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and Azure hosted customer-owned/partner services over a private endpoint in your virtual network.
Traffic between your virtual network and the service travels the Microsoft backbone network.
Exposing your service to the public internet is no longer necessary
Reference:
https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link- private-endpoint-connectivity/ba-p/1235573