it always resolves to 10.1.0.4 which the Private IP of the Private Endpoint in West Europe. But this Private Endpoint will connect to the Storage Account in North Europe as Azure changes the config in the data path to make sure the Private Endpoint connects to the failed over the endpoint. Also, when you failover, the Storage Account becomes LRS and hence the secondary endpoint is no longer active.
With this you don’t need to make any changes to the DNS part of Private Endpoint as it always points to the active Storage region.
