70-448 · Question #218
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…
The correct answer is D. Install the SSIS instance on SERVER_C and develop an SSIS package with the merge join component. See the full explanation below for the reasoning.
Question
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?
Options
- AConfigure SERVER_A and SERVER_B as linked servers.
- BInstall the SSIS instance on both SERVER_A and SERVER_B.
- CWrite store procedures to pull data from SERVER_A and SERVER_B.
- DInstall the SSIS instance on SERVER_C and develop an SSIS package with the merge join component.
How the community answered
(19 responses)- B5% (1)
- C11% (2)
- D84% (16)
Community Discussion
No community discussion yet for this question.