单项选择题
A.Configure an HTTP endpoint for SQL2 on SQL1.
B.Configure SQL2 as a linked server on SQL1.
C.Configure an HTTP endpoint for SQL1 on SQL2.
D.Configure SQL1 as a linked server on SQL2.
多项选择题 Youareadatabaseadministratorforyourcompany.ThecompanyusesaSQLServer2005application.Eachnight,dataisimportedintoadatabase,andthedatabaseisthensettoberead-only.Duringbusinesshours,usersrunpredefinedandadhocqueries.Youneedtomonitortheserversperformanceduringtheday.Whataretwopossiblewaystoachievethisgoal?()
单项选择题 You are a database administrator for your company. A user named Susan belongs to the Windows SalesManagers group. Susan needs a Reporting Services report to display annual sales information by territory. A user named Joe reports to Susan and belongs to the Windows Sales group. He needs a report that is limited to his sales territory, but still displays the same detailed sales data that is on Susan’s report. You need to design a secure solution that meets the reporting needs of the users and that consumes the minimal amount of server resources. What should you do?()
单项选择题 Youareadatabaseadministratorforyourcompany.ThecompanyusesaSQLServer2005computerthatrunsReportingServices.ReportingServicesisusedtoproducehundredsofreportseachday.YoudiscoverthattheReportServerTempDBdatabaseisgrowing.YouneedtominimizethesizeoftheReportServerTempDBdatabase.Whatshouldyoudo?()