首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
54
问题
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
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Whileyouenjoythesunlight,itcastsyourshadowontheground.Therehasbeenadiscussionrecentlyontheissueinanewspap
Supposeyouarethepersonnelmanagerofacompanyandyou’vedecidedtheapplicantnamedZhangWeiisthebestcandidateforth
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
在用户管理组administrators中删除lusi用户。
随机试题
微分方程的通解为().
A.尿后滴血B.中段血尿C.初血尿,伴腰痛D.鲜血尿,伴有大小不等血块E.暗红色血尿,伴条状血块提示膀胱出血
片面强调“知识改变命运”的价值取向,使得理想、信念教育难以入脑入心。大学内外把大学歪曲成名利场,这种认识对高等教育造成了严重的误解和挤压。对此,高校要重建大学精神,整顿学风、校风。更重要的是从小学、中学就要突破应试教育的偏向,培养有正确追求、人格健全的新人
项目可行性研究中,投资方案财务评价应根据方案现金流量预测结果编制财务报表,包括()。
华夏公司发行面值为1000元的债券,票面利率为12%,5年期,每年付息一次。债券以1050元溢价发行,发行费率为5%,所得税税率为25%,则该债券的资金成本为( )元。
现在经常出现这样的现象:120急救车出车救援。但没有车给其让路。导致救援受阻。对于这种现象你怎么看?
Abasicfeatureofall_________isthecapabilitytolocaterecordsinthefilequickly.
A、 B、 C、 BWealllikesugaranswersdoanyofyoulikesugarinyourcoffee.Choice(A)confusesthesimilarso
UnderwhatcircumstanceswouldBobreplacehim?
Trytoimaginewhatitisliketolivewithoutelectricity.Itisboring,【C1】______onething—notelevision,noMP3player,novi
最新回复
(
0
)