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

1.你开发了一个名为 FileService 的服务。你部署这个服务到你网络上的多个服务器上。你实现了如下代码段：

01 public void StartService(string serverName){

02 ServiceController crtl = new

03 ServiceController("FileService");

04 if (crtl.Status == ServiceControllerStatus.Stopped){

05 }

06 }

你需要开发一个服务管理程序，如果服务FileService停止了，则启动它。服务管理程序启动FileService服务，要求以serverName 作为输入参数来标识服务器。你应该增加下面哪两行代码到上面的代码段?

A. 在03和04行之间插入代码段：crtl.ServiceName = serverName;

B. 在03和04行之间插入代码段：crtl.MachineName = serverName;

C. 在03和04行之间插入代码段：crtl.Site.Name = serverName;

D. 在04和05行之间插入代码段：crtl.Continue();

E. 在04和05行之间插入代码段：crtl.Start();

F. 在04和05行之间插入代码段：crtl.ExecuteCommand(0);

答案: B,E

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 2008instance. 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

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 2008instance. 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 traceflags.

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

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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written

to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write

access to the file server. Which account type should you use?

A.You should use local Service account

B.You should use network Service account

C.You should use domain account

D.You should use local System account

Answer: C

编辑推荐：

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

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