black

MCITP(70-444)

登录

单项选择题

You are a database administrator for your company. The company has two SQL Server 2005 computers named SQL1 and SQL2. SQL1 is located on the local network. SQL2 is located at a vendors site and is connected by using a VPN over the Internet. You need to write heterogeneous queries on SQL1 that access data from both SQL1 and SQL2. To ensure that your queries are functional, you must configure access to the vendors site. What should you do?()

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?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064