What are the different scenarios when a self hosted IR be used within an ADF?
Can there be a scenario wherein the SHIR be used for creating a linked service accessing an Azure SQL database or Azure blob storage?