I have applications running in two separate VNETs (in same subscription) that need to connect to a third party DB service using Private Link. I have created two private end points specific to each VNET however not sure how to setup the Private DNS Zone. Since the DNS Zone is global, how do I reference the record referencing the db DNS entry? While adding this record , it requires IP for the private end point. In my case I have two private end points.
Appreciate your feedback!
If you have two separate, non-peered/connected VNets, you would create two separate private DNS Zones and link them with the respective VNet (each with only one VNet). You would not use public (global) DNS zones, as you don't want to resolve them outside of your private networks.
If two private DNS zones provide the same domain, they need to be in different resource groups.
Maybe the hub and spoke network architecture is interesting for you, if you need to scale for many applications.