单项选择题

AsupportengineerreportsthatinsertingnewsalestransactionsinaSQLServer2005databaseresultsinanerror.Youinvestigatetheerror.Youdiscoverthatinoneofthedatabases,adeveloperhasaccidentallydeletedsomedatainatablethatiscriticalfortransactionprocessing.Thedatabaseusesthefullrecoverymodel.Youneedtorestorethetable.Youneedtoachievethisgoalwithoutaffectingtheavailabilityofotherdatainthedatabase.Whatshouldyoudo?（）
A.Backupthecurrenttransactionlog.Restorethedatabasewithadifferentnameandstopatthepointjustbeforethedataloss.Copythetablebackintotheoriginaldatabase.
B.Backupthecurrenttransactionlog.Restorethedatabasetothepointjustbeforethedataloss.
C.Restorethedatabasefromtheexistingbackupfilestoatimejustbeforethedataloss.
D.Restorethedatabasetothepointofthelastfullbackup.

A.Youinvestigatetheerror.Youdiscoverthatinoneofthedatabases,adeveloperhasaccidentallydeletedsomedatainatablethatiscriticalfortransactionprocessing.Thedatabaseusesthefullrecoverymodel.Youneedtorestorethetable.Youneedtoachievethisgoalwithoutaffectingtheavailabilityofotherdatainthedatabase.Whatshouldyoudo?（）
A.Backupthecurrenttransactionlog.Restorethedatabasewithadifferentnameandstopatthepointjustbeforethedataloss.Copythetablebackintotheoriginaldatabase.
B.Backupthecurrenttransactionlog.Restorethedatabasetothepointjustbeforethedataloss.
C.Restorethedatabasefromtheexistingbackupfilestoatimejustbeforethedataloss.
D.Restorethedatabasetothepointofthelastfullbackup.

你可能感兴趣的试题

单项选择题

Youneedtocleanseandstandardizethedataonpotentialsurveyparticipantspriortoinsertingitintothestagingdatabase.Whatshouldyoudo?（）

A.ImportthedataintoastagingtablebyusingtheOPENROWSETBULKstatement.ExecuteaTransact-SQLstoredproceduretocleansethedataandtoinsertthedataintothedatabase.
B.ImportthedataintoastagingtablebyusingtheBULKINSERTstatement.ExecuteaTransact-SQLstoredproceduretocleansethedataandtoinsertthedataintothedatabase.
C.CreateaSQLServerIntegrationServices（SSIS）packagetoimport，standardize，andcleansethedata.
D.CreateaCLRstoredproceduretoimportthedataintoastagingtable，tocleanseandstandardizethedata，andtoinsertthedataintothedatabase.

单项选择题

YouneedtoimplementanauthenticationmethodonSQL4.TheTravelOnlinedatabasewillbeaccessedthroughaWebservicesapplication.Youneedtomaketheauthenticationmethodassecureaspossible.Whatshouldyoudo？（）

A.CreateanHTTPendpointwithNTLMauthentication，andcreateaserviceprincipalname（SPN）.
B.CreateanHTTPendpointwithdigestauthentication，andcreateaserviceprincipalname（SPN）.
C.CreateanHTTPendpointwithintegratedauthentication，andcreateaserviceprincipalname（SPN）.
D.CreateanHTTPendpointwithKerberosauthentication.