You work as the network SQL developer at MiracleInfocom .com. All servers on the MiracleInfocom .com network run Microsoft Windows Server 2003 and the database servers run Microsoft SQL Server 2005. The MiracleInfocom .com network contains two servers which hosts the FinancialData database. The second server runs Oracle Relational Database Management System (RDBMS) and hosts the MiracleInfocom Inventory database. The Inventory database is updated frequently by members of the Finance department. The MiracleInfocom .com network users in the Marketing department need to be able to create daily reports that combine information from both the FinancialData and MiracleInfocom Inventory databases to be run hourly. You have received instruction from the CIO to have your solution minimize the effort required for the database developers to run ad hoc queries no data on both SQL servers to test development requirements. The MiracleInfocom .com network users are required to create reports on the SQL server and you want to minimize the disk space used on the SQL Server whilst using the least administrative effort. What should you do?
A. Replication must be configured between the servers and replicate the data from the Oracle to the SQL server
B. A job must be created that performs the restore function and back up the Oracle server logged changes and restore the database changes from the Oracle to the SQL server every hour
C. A SQL Server Integration Services (SSIS) should be created to import the data from the Oracle server and schedule the package to be delivered every hour
D. The Oracle server should be configured as a linked server and join the information in the databases using a view
Answer:D
You work as the network SQL developer at MiracleInfocom .com. All servers on the MiracleInfocom .com network run Microsoft Windows Server 2003 and the database servers run Microsoft SQL Server 2005. The MiracleInfocom .com network contains two servers which hosts the FinancialData database. The second server runs Oracle Relational Database Management System (RDBMS) and hosts the MiracleInfocom Inventory database. The Inventory database is updated frequently by members of the Finance department. The MiracleInfocom .com network users in the Marketing department need to be able to create daily reports that combine information from both the FinancialData and MiracleInfocom Inventory databases to be run hourly. You have received instruction from the CIO to have your solution minimize the effort required for the database developers to run ad hoc queries no data on both SQL servers to test development requirements. The MiracleInfocom .com network users are required to create reports on the SQL server and you want to minimize the disk space used on the SQL Server whilst using the least administrative effort. What should you do?
A. Replication must be configured between the servers and replicate the data from the Oracle to the SQL server B. A job must be created that performs the restore function and back up the Oracle server logged changes and restore the database changes from the Oracle to the SQL server every hour C. A SQL Server Integration Services (SSIS) should be created to import the data from the Oracle server and schedule the package to be delivered every hour D. The Oracle server should be configured as a linked server and join the information in the databases using a view