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?
A.
Raw File
B.
ODBC
C.
Bulk Insert
D.
OLE DB
This is utter nonsense. It could be D or B, but for the fact that B is currently broken and only uploads one row at a time as a destination. OLE was supposed to be deprecated in 2014, but it’s now 2016 and they still can’t get ODBC to work like a real connection so the answer to connecting to Sql Server is going to be ole db forever. So the underlying question is did you know that microsoft is incompetent so you have to pick ole db over odbc through out the whole test