You work in a company named Fabric Ltd. You are the administrator of your company network. Now you’re in charge of a SQL Server 2008 instance which contains a database named DB1. The DB1 database can be accessed by a Windows group named FABRIC\Officials that is a member of the db_owner role in the DB1 database. A Windows user named UserA is a member of the FABRIC\Managers group. You must make sure that User1 can not access the SQL Server instance. Which Transact-SQL statement(s) should you execute in the DB1 database?
A.
DROP LOGIN “FABRIC\UserA”;
B.
EXEC dbo.sp_droprolemember ‘db_owner’, ‘FABRIC\UserA’;
C.
CREATE LOGIN “FABRIC\UserA” FROM Windows;DENY CONNECT SQL TO “FABRIC\UserA”;
D.
EXEC dbo.sp_revokedbaccess ‘FABRIC\UserA’;EXEC dbo.sp_revokelogin ‘FABRIC\UserA’;