Câu 19: DP-200: Implementing an Azure Data Solution

You plan to use Microsoft Azure SQL Database instances with strict user access control. A user object must: ✑ Move with the database if it is run elsewhere ✑ Be able to create additional usersYou need to create the user object with correct permissions. Which two Transact-SQL commands should you run? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

1. A. ALTER LOGIN Mary WITH PASSWORD = 'strong_password';
2. B. CREATE LOGIN Mary WITH PASSWORD = 'strong_password';
3. C. ALTER ROLE db_owner ADD MEMBER Mary; — đáp án hiện tại
4. D. CREATE USER Mary WITH PASSWORD = 'strong_password'; — đáp án hiện tại
5. E. GRANT ALTER ANY USER TO Mary;