找考题网-背景图
单项选择题

A.In the cluster quorum drive, install the encryption c……

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 in a high security environment, you manage a SQL Server 2008 cluster. You intend to configure and use encrypted connections for the clustered virtual SQL Server. You have to install a certificate. The cetification will be used for encryption. What should you do?（）  

A.In the cluster quorum drive, install the encryption certificate 
B.In the SQL Server shared disk, install the encryption certificate 
C.in the cluster group, install the encryption certificate. 
D.On each individual node, install the encryption certificate

<上一题 目录 下一题>
热门试题

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.TheDworksdatabasehastheProductstable.NowyouhavetoreplicatetheProductstabletotheSQLServerinstancesatremotelocations,soyoucreateaMergeReplicationtopologyandaPublicationtodothis.The Publicationhasa21-dayretentionperiod.Thereisauserwhogoesonabusinesstrip,30dayslaterhecomesbackandfindsthatdatainhisdatabaseisnotthelatest.TheWindowsEventlogstatesthefollowingerrormessage: Replication:expiredsubscriptiondropped. Youmustgetthelatestdataintheuser'sdatabaseandmakesurethatfuturedatachangesareappropriatelyreplicated.Sowhatactionshouldyouperformtoachievethisgoal?（）

A.You should recreate the publication 
B.You should upload unsynchronized changes. 
C.You should reinitialize the publication and generate a new snapshot at once. 
D.You should upload unsynchronized changes, and then reinitialize the publication

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.YouarelogshippingtheAdventureworksdatabasetoaremoteSQLServer2008instance.TheprimarySQLServerinstancerequiredarestartduringtheweekend.Butyounoticethatlogshippinghasstoppedworkingaftertheweekend.YouhavetochecklogshippingoftheAdventureworksdatabaseandfindouttheproblem.Whatshouldyoudo?（）

A.You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. 
B.You should identify whether the SQL Server Agent is started on the primary server. 
C.You should identify whether the AdventureWorks database uses the Simple recovery model. 
D.You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Ontwocluster-readynodes,youintendtoperformaninstallationofaSQLServer2008mission-criticalcluster.Constantavailabilityisneededbythemission-criticalcluster.YouhavetoconfiguretheSQLServerclustertofailoverandreducetheservicedisruptiontotheleast.Whichfailoveroptionshouldyouuse?（）

A.You should allow failback only during non-business hours 
B.You should immediately allow failback
C.You should prevent automatic failback 
D.You should allow failback only during business hours

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Thereisareportwhichisoftenexecutedduringbusinesstime.Thereisastoredprocedurethatisusedasthedatasourceforthereport.Yougetareportfromuserssayingthattheyreceivethedatareturnedbythereportbutthedataisinconsistent.Asthetechnicalsupport,youcheckandfindthatphantomreadscausethisproblem.Youmustmakesurethatconsistentdataisreturnedbythereportwhilenotaffectingotherusers.Sowhatactionshouldyouperformtoachievethisgoal?（）

A.You should configure the database for Read Committed Snapshot isolation. 
B.You should modify the stored procedure to use the Snapshot isolation level 
C.You should configure the database for Auto Update Statistics asynchronously 
D.You should modify the stored procedure to use the Repeatable Read isolation level

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Nowaccordingtothecompanyrequirement,youaredesigningaconsolidatedrepositoryofperformancedata.Youmustmakesurethatthefourrequirementsbelowaremet:thedatacollectorisusedtogatherperformanceinformation;asingledatabasestoresperformanceinformationforallinstances;performanceinformationthatisolderthan15daysisdeleted;reducetheadministrativeefforttomanageperformancetotheleast.Sowhatactionshouldyouperformtoachievethisgoal?（）

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.