试题详情
单项选择题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database.  Which action should be performed to achieve the goal？（）

A、To achieve the goal， a Linked Server connection should be configured to the application database.

B、To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.

C、To achieve the goal， a Remote Server connection to the application database should be configured.

D、To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.

  • D

  • 关注下方微信公众号，在线模考后查看

热门试题