70-432 认证考试题库分享-3

TS:MS SQL Server@ 2008,Implementation and Maintenance
科目编号：70-432
科目名称：TS:MS SQL Server@ 2008,Implementation and Maintenance
考题数目：171 Q&As
更新日期：2009-11-24

TS:MS SQL Server@ 2008,Implementation and Maintenance 认证作为全球IT领域专家 Microsoft 热门认证之一，是许多大中IT企业选择人才标准的必备条件。 如果你正在准备 70-432 考试，为 Microsoft TS:MS SQL Server@ 2008,Implementation and Maintenance认证做最后冲刺，又苦于没有绝对权威的考试真题模拟，Pass4side 希望能助你成功。

70-432 认证考试题库分享
1. You work in a company which is named Wiikigo Corp. The company uses SQL Server 200 You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. Which service should you configure?
A. You should configure SQL Server VSS Writer
B. You should configure Distributed File System
C. You should configure SQL Server
D. You should configure SQL Server Full Text
Answer: C

2. 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 an Internet Information Services application. This application will use anonymous access to access the SSAS instance. You must make sure that the application can access the SSAS instance. What should you do?
A. The SecurityRequireClientAuthentication server configuration should be set to False
B. The SecurityRequireClientAuthentication server configuration should be set to True.
C. The NTLM Security Support Provider Interface (SSPI) provider should be added to the SecuritySecurityPackageList server configuration.
D. The Kerberos Security Support Provider Interface (SSPI) provider should be added to the SecuritySecurityPackageList server configuration
Answer: A

3. 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 for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do?
A. You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance
B. You should upgrade the SQL Server 2005 application to use SQL Server 2008
C. You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance
D. You should install SQL Server 2008 as a named instance, and make the new application use the new instance.
Answer: D

4. 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. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?
A. A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand.
B. A policy should be created. The policy targets the name of the stored procedure that is evaluated on change.
C. A condition should be created. The condition targets the name of the stored procedure that is evaluated on change
D. A condition should be created. The condition targets the name of stored procedure that is evaluated on demand.
Answer: B

5. 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. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal?
A. You should backup the master database
B. You should backup the default.trc file
C. You should backup the SQL Server registry hive.
D. You should backup the resource database
Answer: C