You administer a database that has User A, B and C.
* User A must be able to create new tables and stored procedures,
* User B must be able to select, update, delete and insert data.
* User C must be able to provide windows logins to the database
To which role or roles should you add to UserB?
Select all that apply db_accessadmin db_ddladmin db_datawriter db_datareader db_owner.
A network administrator creates a virtual machine from a template that has SQL Server installed.
You need to ensure that you can create SQL Server databases on the new virtual machine.
Which two actions should you perform to complete the server configuration? Each correct answer presents part
of the solution. Execute the SP_ADDSERVER statement. Edit the Instance Names registry key Execute the SP_SERVER_DIAGNOSTICS statement. Execute the SP_DROPSERVER statement. Run setup.exe and specify the upgrade option.