Question 1

Which type of user authenticates with Azure AD for Azure SQL Database?

Accepted Answer

Contained database user

Answer

Service principal (without Azure AD integration)

Answer

Server administrator

Answer

Local Windows user

Question 2

What is the first step to configure Azure AD authentication for an Azure SQL Database?

Accepted Answer

Create an Azure AD administrator for the database.

Answer

Create contained database users.

Answer

Migrate the database to a different resource group.

Answer

Enable Azure AD authentication in the database settings.

Question 3

How do you connect to an Azure SQL Database using Azure AD authentication with SQL Server Management Studio (SSMS)?

Accepted Answer

Select "Azure Active Directory - Password" in the authentication dropdown and enter the Azure AD user name.

Answer

Utilize a third-party authentication tool.

Answer

Connect through a virtual machine joined to the Azure AD domain.

Answer

Use the server login and password created during database provisioning.

Question 4

Which identity type cannot be used for Azure AD authentication with Azure SQL Database?

Accepted Answer

Azure AD guest user

Answer

Azure AD user from a managed domain

Answer

Local SQL Server login

Answer

Service principal with Azure AD integration

Question 5

What are the benefits of using Azure AD authentication for Azure SQL Database? (Choose two)

Accepted Answer

Improved security and centralized identity management

Answer

Increased database performance

Answer

Reduced database administration overhead

Answer

Easier data migration between databases

Question 6

What tool can be used to manage Azure AD authentication permissions for contained database users in Azure SQL Database?

Accepted Answer

Azure Active Directory portal

Answer

Azure PowerShell

Answer

SQL Server Management Studio

Answer

Azure SQL Database query editor

Question 7

Which client application authentication method is NOT supported for Azure AD authentication with Azure SQL Database?

Accepted Answer

Password grant

Answer

Managed Identity

Answer

Integrated Windows Authentication

Answer

Client certificate authentication

Question 8

What happens if a contained database user mapped to an Azure AD identity is disabled in Azure AD?

Accepted Answer

The user can still access the database with a different login.

Answer

The user loses access to the database.

Answer

Azure AD authentication is automatically disabled for the database.

Answer

The database becomes unavailable.

Question 9

How can a service application connect to an Azure SQL Database using Azure AD authentication?

Accepted Answer

By using a client secret from an Azure AD app registration.

Answer

By leveraging Azure Bastion for secure remote access.

Answer

With the credentials of a contained database user.

Answer

Through a linked server connection from another database.

Question 10

What is a limitation of Azure AD authentication for Azure SQL Database?

Accepted Answer

It cannot be used with on-premises SQL Server instances.

Answer

It does not support role-based access control.

Answer

It requires complex configuration changes.

Answer

It is incompatible with existing database applications.

Related quizzes

Related quizzes