Microsoft Azure Data Fundamentals — Question 39

When you create an Azure SQL database, which account can always connect to the database?

Answer options

• A. the Azure Active Directory (Azure AD) account that created the database
• B. the server admin login account of the logical server
• C. the Azure Active Directory (Azure AD) administrator account
• D. the sa account

Correct answer: B

Explanation

The server admin login account of the logical server is always able to connect to the Azure SQL database, as it has overarching permissions. The Azure AD account that created the database and the Azure AD administrator account may also have access, but they are not guaranteed without proper configuration. The 'sa' account is not applicable in Azure SQL Database as it is specific to SQL Server on-premises installations.