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.