功能测试
首页 > 微软认证 > 正文

最新的70-432题库免费下载!(killtest题库网提供)

发布-admin | 查看- | 发表时间-2010-8-14

MCITP认证之70-432考试题库由我们专业IT认证讲师及产品专家精心打造,包括了当前最新的全真试题,全部附有正确答案。题库的覆盖率在96%以上,能保证考生一次通过考试!
网站上的题库都会根据考试认证厂商的动态变化而及时作出更新的,。确保考生拿到的题库都是最新最全的!
部分70-432题库分享如下:
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. 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

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

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. 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 trace flags. 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
你可以根据自己的需要登录Killtest题库网下载题库!
 

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

最新文章
最近评论
Copyright 2010 killtest.com.cn Some Rights Reserved. 浙ICP备10016241号 | DESIGN BY Seanloo.cn