题目内容

You are adatabase solutionsarchitect.Your company plansto develop asolution by using a SQLServer2008instance.The solutionhasthefollowingbusinessrequirements:ImportdatafromvariousdatasourcessuchasMicrosoftOfficeExcel,Microsoft SQL Server2000,MicrosoftSQLServer2005,andCSVfiles.Profilethesourcedatabeforeitisimported.Providecollaborationandofflinecapabilitiestomobileusers.Allowmobileuserstouseheterogeneousdatastores.YouneedtoconfiguretheappropriateSQLServercomponentstoaccomplishthebusinessrequirements.Youwanttoachievethisgoalbyusingtheminimum amountofadministrativeeffort.
Whichtwo SQL Server componentsshould you use？（）

查看答案

搜索结果不匹配？点我反馈

更多问题

YouaretheadministratorofaMicrosoftWindowsServer2003computernamedSQL1.SQL1runsSQLServer2005andisamemberofaMicrosoftActiveDirectorydomainnamedContoso.com.Thedomainisconfiguredwithallofthedefaultsettings.SeveralmembersoftheinformationsecurityteamhaverequestedaccesstoSQL1.TheinformationsecurityteamusestheMicrosoftWindowsXPProfessional，Linux，andMacintoshoperatingsystemstoperformvulnerabilityassessments.Theinformationsecurityteammembersaskyoutocreatetwonewlogonaccountsfortheiruse.Theywouldlikethelogonaccountstohavethefollowingusernamesandpasswords：Username\passwordforfirstaccount：pentest\P@ssw0rdUsername\passwordforsecondaccount：hacktest\passwordYouneedtoprovidetheinformationsecurityteamwiththerequestedaccesstoSQL1.
WhichTransact-SQLscriptshouldyouuse？（）

YouaretheadministratorofaSQLServer2005computernamedSQL1.AllserversrunMicrosoftWindowsServer2003andbelongtoaMicrosoftActiveDirectorydomain.Thecompanyswrittensecuritypolicymandatesstrongpasswordsforalldomain，local，andapplicationaccounts.TheappropriatedomainpasswordpolicyhasbeendeployedthroughtheuseofaGroupPolicyobject（GPO）.Manyofthecompany’scomputersrunMS-DOS-basedorUNIX-basedoperatingsystems.ThesecomputersrequirevaryinglevelsofaccesstoadatabasenamedServicesonSQL1.YouneedtoensurethatthesecomputerscanaccesstheServicesdatabasewithoutviolatingthecompany’swrittensecuritypolicy.
Whatshouldyoudo？（）

生态系统的自我调节能力取决于生产者和分解者的数量及种类。（)

（)一直是湖南外资的主要来源地。

A. 台湾
B. 香港
C. 美国
D. 日本