首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which y
You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which y
admin
2009-05-19
46
问题
You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which your company has placed bids.
Company policy requires that bid information be removed permanently from the database one year after the bid closes. You need to comply with this policy and minimize server overhead.
What should you do?
选项
A、Create a Data Transformation Services (DTS) package to remove bids that have a closing data older than one year.
B、Create a trigger to delete any bids that have a closing data older than one year. Bind the trigger to the bids table for all INSERT, UPDATE, and DELETE events.
C、Create a stored procedure to delete any bids that have a closing data order than one year. Use SQL server agent to schedule the stored procedure to run every night.
D、Create a view that contains a WHERE clause to exclude bids that have a closing date older than one year.
答案
C
解析
Explanation: This scenario requires us to remove old information on a regular basis. First we create a stored procedure which removes all rows where the bid information date is older than the current date minus one year. Then we schedule this procedure to run every day. We would then be sure to never have any rows older than a year in the table.
Note: Stored procedures also improve performance as the stored procedure is cached after it is run. This results in a reduction of physical I/O. We can further reduce Server overhead by scheduling the stored procedure to run during off-peak hours.
Incorrect Answers:
A: A Data Transformation Services (DTS) package provides a set of tools that allows us to extract, transform, and consolidate data stored in a variety of formats and in different locations into single or multiple destinations supported by DTS connectivity. This solution is inappropriate, as the data exists on the server and not in numerous locations and would thus be correctly formatted for use on an instance SQL Server 2000.
B: Triggers are a special type of stored procedure that executes automatically when an UPDATE, INSERT, or DELETE statement is run against a table or view. In this scenario however, the datestamp of the data in the database must be checked and the data deleted one year after the bid has closed. This cannot be accomplished through the use of constraints or triggers.
D: Creating a view that excludes the bids that have a closing date older than one year does not address the company policy that requires that bid information be removed permanently from the database one year after the bid closes. This data will still exist in the base tables.
转载请注明原文地址:https://kaotiyun.com/show/VuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Supposeyouorderedahairdryeronlineatthecostof$22,butonlyreceivedanemptypackagebox.Somethingmustbewrong.Wri
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
随机试题
A.α波B.β波C.δ波D.θ波正常成年人睡眠状态下一般出现
铁路营业线临时道口应设置在嘹望条件良好的地点,且()。
我国最重要的行政主体是()。
从压力源到临床相的逻辑过程,可分为()。
小王根据某领导要求,要把一次会议记录的代表发言编发一期《会议简报札》,按照有关规定小王可采取的正确做法是()。
立案监督的内容是公安机关作出的立案决定。()
根据我国宪法规定,乡、镇一级的人民代表大会每届任期()。
马克思主义美学在探讨艺术的本质问题时,首先强调_______。
未来的中国,将是一个更加开放包容、文明和谐的国家。一个国家、一个民族,只有开放包容,才能发展进步。唯有开放,先进和有用的东西才能进得来;唯有包容,吸收借鉴优秀文化,才能使自己充实和强大起来。如果以上说法为真,以下哪项陈述一定为假?
Thereareabout105malesbornforevery100females,butthis【B1】______dropstonearbalanceattheageofmaturity,andamong
最新回复
(
0
)