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

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

QUESTION 36
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 database named DB1 in the instance. DB1 is available to a Windows group which is named WIIKIGO\Supervisors. A Windows user named User1 is a member of the
WIIKIGO\Supervisors group. WIIKIGO\Supervisors is a member of the db_owner role in the DB1 database. You must make sure that the SQL Server instance is available to User1. In the DB1
database, which Transact-SQL statement(s) should you execute?

A.DROP LOGIN "WIIKIGO\User1";
B.EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO\User1';
C.EXEC dbo.sp_revokedbaccess 'WIIKIGO\User1';EXEC dbo.sp_revokelogin 'WIIKIGO\User1';
D.CREATE LOGIN "WIIKIGO\User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO\User1";
Answer: D

QUESTION 37
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There are queries that have an
estimated execution cost less than 3. You intend to configure the instance, make it use a single thread for these queries. In the options below, which sp_configure configuration option should you
set?

A.You should set query governor cost limit
B.You should set cost threshold for parallelism
C.You should set priority boost
D.You should set precompute rank
Answer: B

QUESTION 38
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company
requirement, you intend to perform an installation of an instance of SQL Server Reporting Services (SSRS) to the same machine. Now your company CIO wants version his微软认证(MCSE)