You administer a SQL Server 2008 instance for a company named Contoso Ltd. The
instance contains a database named DB1.
A Windows group named CONTOSO\Managers can access the DB1 database.
CONTOSO\Managers is a member of the db_owner role in the DB1 database.
A Windows user named User1 is a member of the CONTOSO\Managers group.
You need to ensure that User1 is unable to access the SQL Server instance.
Which Transact-SQL statement(s) should you execute in the DB1 database?
A.
DROP LOGIN “CONTOSO\User1”;
B.
EXEC dbo.sp_droprolemember ‘ db_owner ‘, ‘CONTOSO\User1’;
C.
EXEC dbo.sp_revokedbaccess ‘CONTOSO\User1’; EXEC dbo.sp_revokelogin
‘CONTOSO\User1’;
D.
CREATE LOGIN “CONTOSO\User1” FROM Windows; DENY CONNECT SQL TO
“CONTOSO\User1”;