You work as the database administrator at Domain.com. The Domain.com network consists of a single Windows Server 2003 domain named Domain.com. All servers on the Domain.com network run Windows Server 2003. The Domain.com departments include a Sales department, a Purchasing department, and an Accounts department. The Domain.com network contains a SQL Server 2000 database server named Certkiller -DB01 and a SQL Server 2005 database server named Certkiller -DB02. Certkiller -DB02 contains a database named CK_Sales that stores sales data for the company.
The Sales department makes extensive use of the CK_Sales database. Domain.com users in the Purchasing department make use of a Microsoft Access database that runs on an application server named Certkiller -SR04 while users in the Accounts departments make use of a SQL Server 2000 database that run Certkiller -DB01. The manager of the Accounts department wants to be able to run distributed queries against the CK_Sales database and the databases in the Purchasing and Accounts departments. You must configure the Certkiller -SR04 and Certkiller -DB01 as linked servers on Certkiller -DB02. You need to select the required data sources to create the linked server definitions.
What should you do? (Choose all that apply.)
A.
Use the OLE DB Provider for Jet as a data source.
B.
Use the SQL Native Client OLE DB Provider as a data source.
C.
Use the OLE DB Provider for ODBC as a data source.
D.
Use the OLE DB Provider for DB2 as a data source.
Explanation:
The Microsoft Access database requires the OLE DB Provider for Jet to communicate with the linked server while the SQL Server 2000 database requires the SQL Native Client OLE DB Provider.
Incorrect answers:
C: SQL Server 6.0 databases require the OLE DB Provider for ODBC but SQL Server 7.0 and later databases require the SQL Native Client OLE DB Provider.
D: The OLE DB Provider for DB2 is required for IBM DB2 databases.
Reference:
Microsoft SQL Server 2005 Books Online (2007), Index: linked servers [SQL Server], about linked servers
Microsoft SQL Server 2005 Books Online (2007), Index: linked servers [SQL Server], Access databases
Microsoft SQL Server 2005 Books Online (2007), Index: linked servers [SQL Server], DB2 databases