微软认证考试70-432练习试题7[1]

【网络综合 - 微软认证(MCSE)试题】
无忧考网为大家收集整理了《微软认证考试70-432练习试题7》供大家参考，希望对大家有所帮助！！！

QUESTION 31 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a Windows group named Wiikigo\Service. According to the security policy, members of this group are allowed to set up new connections to the SQL Server instance. But this is can only be done during office time from 8:00-20:00. Other users may connect to the SQL Server instance any time. You write the following Transact-SQL statements. CREATE TABLE Security.RestrictedLogonHours ( Id int NOT NULL IDENTITY(1,1), GroupName sysname NOT NULL, RestrictedTimeStart time NOT NULL, RestrictedTimeStop time NOT NULL, CONSTRAINT RestrictedLogonHours_pk PRIMARY KEY CLUSTERED(Id) ); INSERT INTO Security.RestrictedLogonHours ( GroupName, RestrictedTimeStart, RestrictedTimeStop ) VALUES ( 'WIIKIGO\Service', CAST('07:00' AS time), CAST('19:00' AS time) ); You need to implement the company security policy which is stored in the RestrictedLogonHours table. What should you do? A.You should create a SQL Server Agent job. The job causes the SQL Server Windows service to pause during non-business hours. B.You should create a logon trigger. The trigger disallows the connection to the WIIKIGO\Service group during non-business hours C.You should create a SQL Server Agent job. The job periodically looks for and kills connections made by the WIIKIGO\Service group during non-business hours. D.You should create a policy. The policy uses a condition based on the Server Audit facet and disallows the connection to the WIIKIGO\Service group during non-business hours Answer: B QUESTION 32 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. T微软认证(MCSE)