单项选择题

Youneedtoprovideadhocreportingcapabilitiestofulfillbusinessrequirements.Whatshouldyoudo?（）

A.CreateaSQLServerReportingServices（SSRS）report.EnablecustomerstomodifythereportbyusingReportBuilder.
B.CreateanASP.NETapplicationthatwillenablecustomerstoviewandmodifyreportsbycallingtheSQLServerReportingServices（SSRS）API.
C.CreateanASP.NETapplicationthatwillenablecustomerstoviewandmodifyreportsbyusingaSQLServerReportingServices（SSRS）ActiveXcontrol.
D.CreateaSQLServerReportingServices（SSRS）ReportModel.EnablecustomerstomodifyreportsbasedonthemodelbyusingReportBuilder.

你可能感兴趣的试题

单项选择题

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.