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

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

2.你正在创建一个将被用于多个应用的、名为 Company1 的强类型程序集。Company1 在整个开发周期中会经常的重新编译。你需要保证，程序集在每次重新编译后使用它的应用都能正确的运行。为此，你将配置开发 Company1 的计算机，使每个应用都能使用 Company1 的最新编译版本。你应该通过下面哪两个步骤完成?(每个答案代表解决方案的一部分)

A. 创建一个指向强类型程序集编译输出目录的DEVPATH 环境变量，。

B. 在machine.config配置文件中增加：

C. 在machine.config配置文件中增加：

language="en-US" version="*.*.*.*" />

D. 为使用强类型程序集的每个应用的配置文件增加：

E. 为使用强类型程序集的每个应用的配置文件增加：

language="en-US" version="*.*.*.*" />

答案: A, B

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 you are in charge of a SQL Server 2008

instance. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. The Orderthings table is partitioned on the OrderId column. The first partition

contains integer values greater than 100,000, while the second partition contains integer values between 1 and 100,000. You have to add a new partition. The new partition should contain integer

values greater than 200,000. What should you do?

A.A new partition function should be created

B.You should change the existing partition scheme

C.You should use a Merge clause to change the existing partition function

D.You should use a Split clause to change the existing partition function

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. There is a database which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products.

The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on

the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. So what action should

you perform to achieve this goal?

A.On the Products table, you should create a view.

B.On the RadioSize column, you should create a clustered index

C.On the RadioSize column, you should create a filtered index

D.On the RadioSize column, you should create a unique clustered index

Answer: C

编辑推荐：

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

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