Microsoft
DP-300 · Question #250
You have an Azure SQL database named DB1. A user named User1 has an Azure Active Directory (Azure AD) account. You need to provide User1 with the ability to add and remove columns from the tables in D
Sign in or unlock DP-300 to reveal the answer and full explanation for question #250. The question stem and answer options stay visible for context.
Submitted by tunde_lagos· Mar 6, 2026Implement a secure environment
Question
You have an Azure SQL database named DB1. A user named User1 has an Azure Active Directory (Azure AD) account. You need to provide User1 with the ability to add and remove columns from the tables in DB1. The solution must use the principle of least privilege. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Options
- AAssign the database user the db_owner role.
- BCreate a contained database user.
- CCreate a login and an associated database user.
- DAssign the database user the db_ddladmin role.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Azure AD user#db_ddladmin#contained database user#DDL permissions