Microsoft
70-458 · Question #143
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…
The correct answer is B. OLE DB. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- ARaw File
- BOLE DB
- CODBC
- DBulk Insert
How the community answered
(26 responses)- A8% (2)
- B73% (19)
- C15% (4)
- D4% (1)
Community Discussion
No community discussion yet for this question.
