when you need to use a federated solution with your on-premises active directory

Scenario :

we have on-premises data center and an azure subscription. an azure sql database is in place that supports Azure AD authentication. The database developers need to authenticate to the database using microsoft sql server management studio.

They need to authenticate using their on-premise active directory account. which of the following authentication type should they use in microsoft sql server management studio to connect, ensuring the solution minimizes the authentication prompts ?

Active Directory - Integrated 


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?tabs=azure-powershell#configure-your-client-computers