Your company uses Microsoft Entra ID for all identity management. You are configuring a new Azure SQL Managed Instance. You need to enable Entra ID authentication for the instance. What must you do first?

Create a database user from an Entra ID group.

Set an Entra ID admin for the Managed Instance.

Enable the Entra ID authentication feature in the Azure portal.

Create a server-level login from an Entra ID user.

A user can connect to Azure SQL Database but receives 'The server principal ... is not able to access the database' error. What is the most likely cause?

The user is not assigned a server role

The user does not have a user account in the database

The user's password is incorrect

The firewall is blocking the connection

You are using SQL Server Management Studio (SSMS) to configure permissions for a user in an Azure SQL Database. The user needs to be able to read and write data in the Sales schema but should not have access to other schemas. Which graphical tool in SSMS should you use to grant these permissions?

Open the user's properties and use the Permissions page to grant SELECT, INSERT, UPDATE, and DELETE on the Sales schema.

Use the Securables page in the database properties to grant permissions to the user.

Use the Server Roles page to add the user to the sysadmin role.

Use the Database Roles page to add the user to the db_datareader and db_datawriter roles.

Microsoft Certified:Azure Database Administrator Associate

Domain 2Objective 1

Configure Database Authentication and Authorization DP-300 Practice Questions (Page 7)

Part of the Implement a secure environment domain, which accounts for 20–25% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~8–16 in this domain), expect 3–5 from this objective — we provide 33 practice questions to prepare you well beyond it. (estimate)

33questions here

7free pages

8concepts

20–25%of the exam

Questions 31–33

31application · medium
Your company uses Microsoft Entra ID for all identity management. You are configuring a new Azure SQL Managed Instance. You need to enable Entra ID authentication for the instance. What must you do first?
Select an answer first
32foundation · easy
A user can connect to Azure SQL Database but receives 'The server principal ... is not able to access the database' error. What is the most likely cause?
Select an answer first
33application · medium
You are using SQL Server Management Studio (SSMS) to configure permissions for a user in an Azure SQL Database. The user needs to be able to read and write data in the Sales schema but should not have access to other schemas. Which graphical tool in SSMS should you use to grant these permissions?
Select an answer first

Finished these 3 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DP-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.

Configure Database Authentication and Authorization DP-300 Practice Questions (Page 7)

Questions 31–33

Your company uses Microsoft Entra ID for all identity management. You are configuring a new Azure SQL Managed Instance. You need to enable Entra ID authentication for the instance. What must you do first?

A user can connect to Azure SQL Database but receives 'The server principal ... is not able to access the database' error. What is the most likely cause?

You are using SQL Server Management Studio (SSMS) to configure permissions for a user in an Azure SQL Database. The user needs to be able to read and write data in the Sales schema but should not have access to other schemas. Which graphical tool in SSMS should you use to grant these permissions?

Keep studying — Implement a secure environment