nerdexam
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

70-458 question #143 exhibit

Options

  • ARaw File
  • BOLE DB
  • CODBC
  • DBulk Insert

How the community answered

(26 responses)
  • A
    8% (2)
  • B
    73% (19)
  • C
    15% (4)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 70-458 Practice