If you only have a few storage accounts needing public IPs, adding manual A records in the private DNS zone might be the most straightforward approach.
However,It may not be the best solution in the long run. I would recommend using Azure Private DNS Resolver with custom forwarding rules. This provides a flexible, scalable solution that can be easily managed and modified as your needs change.
You can mark it 'Accept Answer' and 'Upvote' if this helped you
Regards,
Abiola