You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of Oracle relational database management system (RDBMS) server. This server is used to store your company’s financial information. The financial information is updated frequently throughout the day. You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day. You want to create reports on the SQL Server computer by using the minimum amount of disk space. What should you do?
A.
Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.
B.
Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.
C.
Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.
D.
Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.