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

1You 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. According to the company requirement, you have to export all data from the

Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used.What should you do?

A.You should run the bulk copy program utility along with an output file and no format file

B.You should run the SQLCmd utility and save the output to a file

C.You should run the SQL Import and Export Data Wizard and save the output to a file.

D.You should run the bulk copy program utility along with a format file and an output file.

Answer: C

2You 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 DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the

database can be restored to a specific point in time. So what action should you perform to achieve this goal?

A.You should verify that the simple recovery model is used by the database

B.You should verify that the full recovery model is used by the database.

C.You should verify that the checksum page verify option is used by the database

D.You should verify that the bulk-logged recovery model is used by the database

Answer: B

3.你正在开发一个类库。此类库将打开和网络上其他计算机的网络套接字连接(networksocketconnections)。你将部署类库到全局程序集并且许可为完全信任。你写了如下代码去保证socket 连接是可用的：

SocketPermission permission = new SocketPermission(PermissionState.Unrestricted);

permission.Assert();使用这个类库的一些应用并不需要必需的权限去打开网络套接字连接。你需要取消断言(assertion)。你应该使用下面那个代码段：

A. CodeAccessPermission.RevertAssert();

B. CodeAccessPermission.RevertDeny();

C. permission.Deny();

D. permission.PermitOnly();

答案: A

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 2008instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected

in the database. So what action should you perform to achieve this goal?

A.For the database, you should turn on the TRUSTWORTHY database option

B.For the database, the PAGE_VERIFY database option should be set to CHECKSUM

C.For the database, the database compatibility level option should be set to 10.

D.For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.

Answer: B

编辑推荐：

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

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