设为首页收藏本站language→→ 语言切换

鸿鹄论坛

 找回密码
 论坛注册

QQ登录

先注册再绑定QQ

查看: 3644|回复: 30
收起左侧

[分享] Test4actual 最新更新 Microsoft TS 70-432

  [复制链接]
发表于 2011-9-5 11:17:07 | 显示全部楼层 |阅读模式
科目编号:70-432
认证名称:TS:MS SQL Server@ 2008,Implementation and Maintenance


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

有需要的朋友请下载附件:


游客,如果您要查看本帖隐藏内容请回复

 楼主| 发表于 2011-9-5 11:17:14 | 显示全部楼层
沙发 2011-9-5 11:17:14 回复 收起回复
回复 支持 反对

使用道具 举报

 成长值: 1270
发表于 2011-10-6 10:33:18 | 显示全部楼层
dddddddddddddd
板凳 2011-10-6 10:33:18 回复 收起回复
回复 支持 反对

使用道具 举报

发表于 2011-11-2 13:57:47 | 显示全部楼层
谢谢
地板 2011-11-2 13:57:47 回复 收起回复
回复 支持 反对

使用道具 举报

发表于 2011-11-28 10:07:18 | 显示全部楼层
3Q 就快考试了 找了好久啊
5# 2011-11-28 10:07:18 回复 收起回复
回复 支持 反对

使用道具 举报

发表于 2011-11-28 10:09:53 | 显示全部楼层
呃 还有密码。。。
6# 2011-11-28 10:09:53 回复 收起回复
回复 支持 反对

使用道具 举报

发表于 2012-4-18 20:38:34 | 显示全部楼层
7# 2012-4-18 20:38:34 回复 收起回复
回复 支持 反对

使用道具 举报

发表于 2012-5-5 16:24:42 | 显示全部楼层
来顶上去了哦。。。
8# 2012-5-5 16:24:42 回复 收起回复
回复 支持 反对

使用道具 举报

发表于 2012-6-3 10:56:19 | 显示全部楼层
受人玫瑰,手有余香
9# 2012-6-3 10:56:19 回复 收起回复
回复 支持 反对

使用道具 举报

发表于 2012-6-3 11:00:03 | 显示全部楼层
为什么删除我?
10# 2012-6-3 11:00:03 回复 收起回复
回复 支持 反对

使用道具 举报

发表于 2012-6-4 06:48:10 | 显示全部楼层
请问下,解压密码是什么??
11# 2012-6-4 06:48:10 回复 收起回复
回复 支持 反对

使用道具 举报

发表于 2012-6-4 09:24:14 | 显示全部楼层
12# 2012-6-4 09:24:14 回复 收起回复
回复 支持 反对

使用道具 举报

发表于 2012-6-12 13:29:35 | 显示全部楼层
....解压密码!!!!
13# 2012-6-12 13:29:35 回复 收起回复
回复 支持 反对

使用道具 举报

发表于 2012-7-9 14:27:00 | 显示全部楼层
看看是否齐全
14# 2012-7-9 14:27:00 回复 收起回复
回复 支持 反对

使用道具 举报

发表于 2012-9-1 11:19:31 | 显示全部楼层
thank you
15# 2012-9-1 11:19:31 回复 收起回复
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 论坛注册

本版积分规则

QQ|Archiver|手机版|小黑屋|sitemap|鸿鹄论坛 ( 京ICP备14027439号 )  

GMT+8, 2024-3-29 05:42 , Processed in 0.082283 second(s), 9 queries , Redis On.  

  Powered by Discuz!

  © 2001-2024 HH010.COM

快速回复 返回顶部 返回列表