為大家收集整理了《微軟認證考試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 histories of all deployed
reports can be kept. As a technical support, what should you do to ensure this?
A.You should use the http.sys listener to install the SSRS instance.
B.You should configure the SSRS database, make it use Native mode
C.You should configure the SSRS database, make it use SharePoint integrated mode
D.You should use the Internet Information Services default Web site to install the SSRS instance
Answer: C
QUESTION 39
You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For
a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications
have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database
administrative effort as possible?
A.You should install SQL Server 2008 as a named instance, and make the new application to use the new instance.
B.You should install SQL Server 2008 as the default instance, and make the new application to use the default instance.
C.You should upgrade the SQL Server 2005 application to use SQL Server 2008.
D.You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
Answer: A
QUESTION 40
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. You intend to configure
FILESTREAM data, enabling FILESTREAM for file I/O streaming access and allowing remote client computers to have streaming access to FILESTREAM data.
You must make sure that FILESTREAM data is enabled.
In the options below, which service should you configure?
A.You should configure Distributed File System
B.You should configure SQL Server
C.You should configure SQL Server Full Text
D.You should configure SQL Server VSS Writer
Answer: B
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 histories of all deployed
reports can be kept. As a technical support, what should you do to ensure this?
A.You should use the http.sys listener to install the SSRS instance.
B.You should configure the SSRS database, make it use Native mode
C.You should configure the SSRS database, make it use SharePoint integrated mode
D.You should use the Internet Information Services default Web site to install the SSRS instance
Answer: C
QUESTION 39
You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For
a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications
have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database
administrative effort as possible?
A.You should install SQL Server 2008 as a named instance, and make the new application to use the new instance.
B.You should install SQL Server 2008 as the default instance, and make the new application to use the default instance.
C.You should upgrade the SQL Server 2005 application to use SQL Server 2008.
D.You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
Answer: A
QUESTION 40
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. You intend to configure
FILESTREAM data, enabling FILESTREAM for file I/O streaming access and allowing remote client computers to have streaming access to FILESTREAM data.
You must make sure that FILESTREAM data is enabled.
In the options below, which service should you configure?
A.You should configure Distributed File System
B.You should configure SQL Server
C.You should configure SQL Server Full Text
D.You should configure SQL Server VSS Writer
Answer: B