PrepAway - Latest Free Exam Questions & Answers

Which destination component should you use?

You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a
Windows Azure SQL Database database into a SQL Server database.
The SSIS package has the following requirements:
 Every night, a very large amount of data is imported into the staging
database.
 Package processing time must be minimized.
 The package must run on its own dedicated server when it is deployed
to production.
 Transaction log activity when data is imported must be minimized.
You need to design the package to meet the requirements.
Which destination component should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
DataReader

B.
OLE DB

C.
ADO.NET

D.
SQL Server


Leave a Reply