可学答题网 > 问答 > MCITP(70-447)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You are a professional


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

  • ATo achieve the goal, a Linked Server connection should be configured to the application database.
  • BTo achieve the goal, a query should be written, and an OPENQUERY command is utilized by the query.
  • CTo achieve the goal, a Remote Server connection to the application database should be configured.
  • DTo achieve the goal, a query should be written, and an OPENDATASOURCE command is utilized by the query.
参考答案
参考解析:
分类:MCITP(70-447)题库
相关推荐

1、You are a professional

You are a professional level SQL Sever 2008 Database Administrator in an international corporation&e...

2、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

3、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

4、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

5、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

6、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...