Microsoft
70-448 · Question #218
70-448 Question #218: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #218. The question stem and answer options stay visible for context.
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.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.