You are a BI developer for a financial firm.
You are developing a SQL Server 2008 Integration Services (SSIS) instance to load 13
million records into TABLE_C three times daily from TABLE_A and TABLE_B,
TABLE_A is in DATABASE_A hosted on SERVER_A, TABLE_B is in DATABASE_B hosted
on
SERVER_B, TABLE_C is in DATABASE_C hosted on SERVER_C
You are logged on to SERVER_C, You have read-only permissions on SERVER_A and
SERVER_B, These two servers are on different domains with individual firewall settings.
You need to load the records into TABLE_C by performing an inner join on TABLE_A and
TABLE_B,
What should you do?
A.
Configure SERVER_A and SERVER_B as linked servers.
B.
Install the SSIS instance on both SERVER_A and SERVER_B
C.
Write store procedures to pull data from SERVER_A and SERVER_B
D.
Install the SSIS instance on SERVER_C and develop an SSIS package with the merge
join component.