為大家收集整理了《微軟認(rèn)證考試70-432練習(xí)試題2》供大家參考，希望對大家有所幫助！！！
QUESTION 6
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 Security\RequireClientAuthentication server configuration should be set to False
B.The Security\RequireClientAuthentication server configuration should be set to True.
C.The NTLM Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration.
D.The Kerberos Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration
Answer: A
QUESTION 7
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
QUESTION 8
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. 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
QUESTION 9
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 two instances both of
which run on the same computer. One is a SQL Server 2008 instance; another is a SQL Server 2005 instance. There is a database named DB1 in the SQL Server 2008 instance. DB1 uses the Fulltext
indexes. Several records that include the word "root" are added to DB1. An empty resultset is returned when the Fulltext index is queried for the word "root." You must make sure the query can
return records that contain the word "root". What should you do?
A.You should terminate and restart the MSFTESQL service
B.You should rebuild the full-text index
C.The word "root" should be added to the stop list
D.The word "root" should be added to the thesaurus file
Answer: B
QUESTION 10
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 must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what
action should you perform to achieve this goal?
A.You should use the Database Engine Tuning Advisor.
B.In Microsoft SQL Server Management Studio, you should create a maintenance plan
C.You should use the SQL Server Configuration Manager
D.In Microsoft SQL Server Management Studio, you should create a policy
Answer: D
QUESTION 6
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 Security\RequireClientAuthentication server configuration should be set to False
B.The Security\RequireClientAuthentication server configuration should be set to True.
C.The NTLM Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration.
D.The Kerberos Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration
Answer: A
QUESTION 7
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
QUESTION 8
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. 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
QUESTION 9
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 two instances both of
which run on the same computer. One is a SQL Server 2008 instance; another is a SQL Server 2005 instance. There is a database named DB1 in the SQL Server 2008 instance. DB1 uses the Fulltext
indexes. Several records that include the word "root" are added to DB1. An empty resultset is returned when the Fulltext index is queried for the word "root." You must make sure the query can
return records that contain the word "root". What should you do?
A.You should terminate and restart the MSFTESQL service
B.You should rebuild the full-text index
C.The word "root" should be added to the stop list
D.The word "root" should be added to the thesaurus file
Answer: B
QUESTION 10
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 must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what
action should you perform to achieve this goal?
A.You should use the Database Engine Tuning Advisor.
B.In Microsoft SQL Server Management Studio, you should create a maintenance plan
C.You should use the SQL Server Configuration Manager
D.In Microsoft SQL Server Management Studio, you should create a policy
Answer: D