Exam 9: Data Integration

An application programming ____________ defines the communication protocol between two software applications that need to interact with each other.

Which basic data integration tool provides step-by-step instructions but has a limited range of data transformation capabilities?

Which type of task should you add to an SSIS package if you need to perform operations on schema objects?

ODBC is an API that is designed to facilitate the interactions between a client application and a database management system, but it is platform-specific.

Which of the following is NOT a method that can be used to execute an Integration Services package?

Describe the SQL Server Import and Export Wizard. What are its advantages and limitations?

The BULK INSERT statement inserts records from an external data file source into a SQL Server table.

Which of the following is NOT a method to leverage the bulk copy interface?

___________ tasks allow custom code to be executed to extend the functionality of the basic set of tasks.

What is a workflow task? Provide an example.

Which of the following is a legacy data integration tool with a graphical designer that had a limited range of functionality?

Why would you use a format file used with the bcp utility?

Which type of SSIS package task permits the package to interact with other applications?

What kind of task should be added to an SSIS package if you want to download a data file from an FTP site?

An SSIS ___________ groups together a set of one or more tasks into a single object that can be executed using the SQL Server Integration Services service.

Which of the following can be used for bidirectional data transfers and is a stand-alone application that is run from a command prompt?

Aside from extracting and loading data, the process of data integration involves which of the following?

Which of the following may be found in a database table that performs a secondary set of operations when data is inserted, deleted, or updated?