You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）A.Configure a Linked Server connection to the application database.B.Write a query that uses an OPENDATASOURCE command.C.Write a query that uses an OPENQUERY command.D.Configure a Remote Server connection to the application database.

单项选择题

You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database.
What should you？（）

A.Configure a Linked Server connection to the application database.
B.Write a query that uses an OPENDATASOURCE command.
C.Write a query that uses an OPENQUERY command.
D.Configure a Remote Server connection to the application database.

相关考题

单项选择题 Youareadatabaseadministratorforyourcompany.ThecompanyhastwoSQLServer2005computersnamedSQL1andSQL2.SQL1islocatedonthelocalnetwork.SQL2islocatedatavendorssiteandisconnectedbyusingaVPNovertheInternet.YouneedtowriteheterogeneousqueriesonSQL1thataccessdatafrombothSQL1andSQL2.Toensurethatyourqueriesarefunctional，youmustconfigureaccesstothevendorssite.Whatshouldyoudo？（）

多项选择题 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？（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064

MCITP(70-444)