Valid DP-200 Dumps shared by ExamDiscuss.com for Helping Passing DP-200 Exam! ExamDiscuss.com now offer the newest DP-200 exam dumps, the ExamDiscuss.com DP-200 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DP-200 dumps with Test Engine here:
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 users You 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.
Correct Answer: C,D
C: ALTER ROLE adds or removes members to or from a database role, or changes the name of a user-defined database role. Members of the db_owner fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server. D: CREATE USER adds a user to the current database. Note: Logins are created at the server level, while users are created at the database level. In other words, a login allows you to connect to the SQL Server service (also called an instance), and permissions inside the database are granted to the database users, not the logins. The logins will be assigned to server roles (for example, serveradmin) and the database users will be assigned to roles within that database (eg. db_datareader, db_bckupoperator). References: https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-role-transact-sql https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql