我们考吧网为了帮助考生朋友们加强基础知识的巩固，加强练习试题的训练，有效的提高学习效率，我们考吧网整理了一些关于微软认证模拟试题，希望对本次的考试有所帮助，汇编的模拟试题如下：同时也希望你本次顺利通关。想了解更多职称计算机咨询，就请继续关注我们考吧网。

1.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

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 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

3.你是公司 A 的一个开发人员。你创建了一个名为 Company1 的程序集。Company1 包含了一个 public 方法。全局程序集中包含了另一个名为 Company2 的程序集。你必须保证，public 方法只能够被 Company2 调用。你需要使用下面哪个权限类?

A. GacIdentityPermission

B. PublisherIdentityPermission

C. DataProtectionPermission

D. StrongNameIdentityPermission

答案: D

4.You work in a Organization which is named Wiikigo Corp. The Organization uses SQL Server 2008. You are the administrator of the Organization database. Now you are in charge of a SQL Server

2008 instance. Look at the following query:

SELECT s.*, i.*

FROM SensitiveTbl AS s

INNER JOIN InsensitiveTbl AS iON i.

OrganizationName = s.OrganizationName

You use the above query to join two tables on a column named OrganizationName.

The following error is returned when you execute the query.

"Msg 468, Level 16, State 9, Line 17

Cannot resolve the collation conflict between 'SQL_Latin1_General_CP1_CS_AS' and 'SQL_Latin1_General_CP1_CI_AS' in the equal to operation."

The ON clause of the query has to be modified so that it can perform a case-sensitive joinsuccessfully.

What should you do?

A.ON LOWER(i.OrganizationName) = LOWER(s.OrganizationName)

B.ON UPPER(i.OrganizationName) = UPPER(s.OrganizationName)

C.ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CS_AS

D.ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CI_AS

Answer: C

编辑推荐：

2013年《微软认证》MCITP考试精选模拟试题汇总一  

2013年微sql认证精选模拟试题汇总