You have just been hired as the database administrator at Domain.com. Domain.com currently uses several Microsoft Access databases to store its business information. The Microsoft Access databases are stored on two application servers named Certkiller -SR04 and Certkiller -SR05.
You have been instructed to migrate some of the Microsoft Access databases on Certkiller -SR04 to SQL Server 2005. You must ensure that Domain.com users can access data in the Microsoft Access databases until all the data has been migrated to SQL Server 2005. During the migration process, Domain.com users must be able to run distributed queries against the data in both SQL Server 2005 and Microsoft Access. You install SQL Server 2005 on a member server named Certkiller -SR06. Certkiller -SR06 has limited disk space.
What should you do?
A.
Configure Certkiller -SR04 as a linked server on Certkiller -SR06. Configure the OLE DB Provider for Jet as the data source.
B.
Configure Certkiller -SR04 as a linked server on Certkiller -SR06. Configure the OLE DB Provider for ODBC as a data source.
C.
Configure Certkiller -SR06 as a linked server on Certkiller -SR04. Configure the OLE DB Provider for ODBC as a data source.
D.
Configure Certkiller -SR06 as a linked server on Certkiller -SR04. Configure the OLE DB Provider for Jet as a data source.
Explanation:
To support distributed queries, you must configure the Microsoft Access database server as a linked server on the SQL database server. Microsoft Access requires the OLE DB Provider for Jet to communicate with the linked server.
Incorrect answers:
B: Microsoft Access requires the OLE DB Provider for Jet to communicate with the linked server, not the OLE DB Provider for ODBC.
C, D: You cannot create linked servers in Microsoft Access. You must create them in SQL Server 2005.
Reference:
Microsoft SQL Server 2005 Books Online (2007), Index: linked servers [SQL Server], Access databases