ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 252 - DP-300 discussion

Report
Export

You have an Azure SQL database named DB1.

A user named User 1 has an Azure AD account.

You need to provide User1 with the ability to add and remove columns from the tables m DBV 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

A.
Assign the database user the db.ddladmm role.
Answers
A.
Assign the database user the db.ddladmm role.
B.
Assign the database user the db.owner role.
Answers
B.
Assign the database user the db.owner role.
C.
Create a contained database user.
Answers
C.
Create a contained database user.
D.
Create a login and an associated database user.
Answers
D.
Create a login and an associated database user.
Suggested answer: A, D
asked 02/10/2024
Antonio Agustin Mirano
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first