Study tips 70-463

How should youdesign the data flow outputs?

Which three steps should you perform in sequence?

You need to ensure that the Merge Join transformation works correctly without additional transformations

Which page of the Lookup TransformationEditor should you select to configure the query?

How should you use a MERGE T-SQL statement to accomplish this goal?

How should you develop the data flow?

Which settings should you select?

Which data import command and recovery model shouldyou choose?

How should you configure the transaction properties?

Which four actions should you perform in sequence?