We have Azure storage queue triggered Azure function, in order to enable High Availability of the Azure function during main storage account outage on RegionA where the queue resides, want to enable the Azure function to listen to another queue which belongs to stand-by storage account on RegionB
In order to achieve the above behavior, thought of modifying queue trigger Azure function to be a event grid triggered Azure function where the event grid to get notified for any new incoming messages on either of the queues of main or stand-by storage account. Is this solution advisable or any other better way to High availability of queue trigger Azure function?