PrepAway - Latest Free Exam Questions & Answers

What should you?

You are a database administrator for AIOTestKing.com. 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?

PrepAway - Latest Free Exam Questions & Answers

A.
Configure a Linked Server connection to the application database.

B.
Configure a Remote Server connection to the application database.

C.
Write a query that uses an OPENQUERY command.

D.
Write a query that uses an OPENDATASOURCE command.


Leave a Reply