You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. A new Domain.com security policy requires allows members of a Windows group
name CK_Prod to build new links to the SQL Server instance that should occurs between the
business hours of 10:00 and 22:00. Furthermore, the other Domain.com users are not allowed to
connect the database at any time. At the bottom the Transact-SQL statements:
CREATE TABLE Security.RestrictedTester(
ProductID int NOT NULL IDENTITY(1,1),
GroupTest sysname NOT NULL,
RestrictedTesterTimeStart time NOT NULL,
RestrictedTesterTimeStop time NOT NULL,CONSTRAINT RestrictedTester _pk PRIMARY KEY
CLUSTERED(Id));
INSERT INTO Security.RestrictedTester
(GroupTest,RestrictedTesterTimeStart,RestrictedTesterTimeStop)VALUES (‘ CK_Prod’,
CAST(’10:00′ AS time),CAST(’22:00′ AS time));
You have received instructions from management to run the new Domain.com security policy
which is reserved in the RestrictedTester table.
What should you do?
A.
You should consider developing a Microsoft SQL Server 2005 Reporting Services (SSRS) that
will result in the SQL Server Windows service to stop during non-business hours.
B.
You should consider developing a SQL Server Agent job that will result in the SQL Server
Windows service to stop during non-business hours.
C.
You should consider developing a logon trigger which could not permit the connection to
CK_Prod during non-business hours.
D.
You should consider developing a Microsoft SQL Server 2005 Integration Services (SSIS) that
will result in the SQL Server Windows service to stop during non-business hours.