A.1:1
B.1:2
C.2:3
D.3:2
第1题
A.nvarchar(100)NULL
B.nvarchar(max)NOTNULL
C.nvarchar(100)NOTNULL
D.nvarchar(100)SPARSENULL
第2题
Whichtwo SQL Server componentsshould you use?()
第3题
A.UsetheSQLServerSurfaceAreaConfigurationtooltoimportthesecuritytemplate.
B.UsetheLocalSecurityPolicyeditortoimportthesecuritytemplateintotheLocalSecurityPolicyobject.
C.ConfigureTaskSchedulertoimportthesecuritytemplatebyusingSecedit.exe.Configurethetasktoruneveryhalfhour.
D.ConfigureTaskSchedulertoruntheMicrosoftBaselineSecurityAnalyzertooleveryhalfhour.
第4题
A.CreateaGroupPolicyobject(GPO)thatisconfiguredforsuccessandfailureauditingoftheAuditaccountlogoneventssetting.AskthedomainadministratortolinktheGPOtotheobjectcontainingSQL1.
B.ConfiguretheSQLServerserviceonSQL1toauditallsuccessfulandfailedlogonattempts.
C.EditthelocalsecuritypolicyofSQL1.Then,configuresuccessandfailureauditingontheAuditlogoneventssetting.
D.RuntheSQLServerProfileranduseastandarddefaulttemplate.
第5题
A.UsetheSQLServer2005ManagementStudiotoreviewthepermissionsofthedefaultdatabaseobjects.
B.Querythesys.server_permissionstableonServer1.
C.Executethesp_helploginssystemstoredprocedureforeachofthedefaultusersthattheMedDATAapplicationcreates.
D.Querythesys.database_permissionsandsys.database_principalstablesintheMedDBdatabase.
第6题
A.MicrosoftSQLServer2005MobileEdition
B.MicrosoftSQLServer2005ExpressEdition
C.MicrosoftSQLServer2005StandardEdition
D.MicrosoftSQLServer2005WorkgroupEdition
第7题
A.Applyamany-to-manyrelationshipbetweentheTransactionmeasuregroupandthePersondimensionintheWoodgroveSSASdatabase.
B.ApplyaConditionalSplittransformationintheTransactiondataintheSSISpackage.
C.DeletetheAccountHoldertableintheWoodgroveDWdatabase.
D.ApplyaforeignkeyrelationshipbetweenthePersontableandtheTransactiontableintheWoodgroveDWdatabase.
第8题
A.ReplacethenamedquerywithanSQLview.
B.Setthetransactionisolationleveltoserializableinthenamedquery.
C.Setthesourcedatabasetousesnapshotisolation.
D.Setthetransactionisolationleveltorepeatablereadinthenamedquery.
第9题
A.Customeventhandlers
B.Dataflowerroroutput
C.SSISlogproviderforSQLServer
D.ExecuteSQLtaskswithfailureprecedenceconstraints
第10题
A.UsePercentageSamplinginSSIS.
B.UseaNeuralNetworkDataminingalgorithm.
C.CreateanSSASKeyPerformanceIndicatorforeachaccount.
D.MonitortransactionsbyusingSQLServerProfiler.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!