Câu 43: 70-767: Implementing a SQL Data Warehouse

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question. You are designing a data warehouse and the load process for the data warehouse. You have a source system that contains two tables named Table1 and Table2. All the rows in each table have a corresponding row in the other table. The primary key for Table1 is named Key1. The primary key for Table2 is named Key2. You need to combine both tables into a single table named Table3 in the data warehouse. The solution must ensure that all the nonkey columns in Table1 andTable2 exist in Table3. Which component should you use to load the data to the data warehouse?

1. A. the Slowly Changing Dimension transformation
2. B. the Conditional Split transformation
3. C. the Merge transformation
4. D. the Data Conversion transformation
5. E. an Execute SQL task
6. F. the Aggregate transformation
7. G. the Lookup transformation — đáp án hiện tại