YouworkinacompanywhichisnamedWiikigoCorp.Thecompanyuses

单项选择题

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. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （）

A.You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances.
B.You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances.
C.You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances.
D.You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances.

相关考题

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Youaregoingtousethedatacollectortogatherperformancedataperiodicallyonallinstances.Youmuststoreallcollecteddatainthesamedatabase.Thisdatabaseishostedonasingleinstance.Everyfivehours,youhavetocollectandloadperformancedatainthemanagementdatawarehouse.Whichdatacollectionprocessshouldyouimplement?（）

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Theserverhostsdatabasesforseveralmission-criticalapplications.MicrosoftSQLServerManagementStudioexecutesqueriesandithassomeeffect.NowyouintendtolimittheeffectbyusingtheResourceGovernor.YoumustmakesurethatqueriesinitiatedthroughSQLServerManagementStudioislessthan20percentofCPUutilization,besidesthis,youmustmakesurethatqueriesinitiatedbythemission-criticalapplicationscanconsume100percentofCPUutilizationwhenrequired.Sowhatactionshouldyouperformtoachievethisgoal?（）

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Accordingtothecompanyrequirement,youmigrateanapplicationfromMicrosoftSQLServer2000toMicrosoftSQLServer2008.YouhavetomonitortheSQLServerinstance,andrecordtheuseoffeatureswhichwillbediscontinued.Whatshouldyoudo?（）

MCTS(70-432)