首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the database administrator of a SQL Server 2000 computer. The server contains your company’s Accounts database. Hundreds
You are the database administrator of a SQL Server 2000 computer. The server contains your company’s Accounts database. Hundreds
admin
2009-05-19
39
问题
You are the database administrator of a SQL Server 2000 computer. The server contains your company’s Accounts database. Hundreds of users access the database each day.
Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.
What should you do?
选项
A、Enable the torn page detection database option for each database.
B、Disable write caching on all disk controllers.
C、Ensure that write caching disk controllers have battery backups.
D、Create a database maintenance plan to check database integrity and make repairs each night.
答案
C
解析
Explanation: The scenario states that power interruptions have occurred in the past. By buying a battery backup solution for the disk controllers the power interruption problem would be prevented.
Incorrect Answers:
A: Torn page detection is a reactive solution which would slow down performance since restores would have to be made. It would better to use a preventive solution.
Note: Torn page detection: If a torn page is detected, the database must be restored from backup because it will be physically inconsistent.
B: Caching is very import for performance. Disabling write-caching would be a bad idea.
D: Repairing the database every night is not a good solution. Database errors cannot be accepted. It is better to prevent the problem instead of trying to fix it after it has happened.
转载请注明原文地址:https://kaotiyun.com/show/FuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
Writeanessayof160-200wordsbasedonthefollowingdrawings.Inyouressay,youshould1)describethedrawingsbriefly,
Whileyouenjoythesunlight,itcastsyourshadowontheground.Therehasbeenadiscussionrecentlyontheissueinanewspap
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
随机试题
下列属于东汉散文作家的有【】
我国实施关税配额管理的商品主要是()
表示CT空间分辨率的单位是
不属于建筑限高范围内的建筑物是()。
某设备采购合同中约定,甲方向乙方订购五台设备。合同履行时,甲乙双方约定将其中两台设备交付给丙,但乙一直未向丙交付该设备,则( )。
聘任制的优点是()。
阅读材料回答下列几题:作为一种文化载体的民间传说或神话并非完全出于古人的想象,而往往以某些史前事件为事实依据。“女娲补天”神话的起源应是源于远古时期一次影响深远的灾害。最近,中南民族大学罗漫提出,著名的神话“女娲炼五色石以补苍天”,是一则典型的以
Atschoolwewentoveroursocialnetworkingguidelines.【C1】______theobvious—don’tbeinappropriatewithstudentsthroughtext
以下选项中正确的定义语句是
【B1】【B7】
最新回复
(
0
)