Question 1

What type of component should you use if you need to convert numeric data to string data as the data flows between the source and destination?

Accepted Answer

A) script 
B) file system task 
C) data flow 
D) transformation 
A) script 
B) file system task 
C) data flow 
D) transformation D

Question 2

SSIS is a component of SQL Server that can be used to ___________ many different types of external data sources.

Accepted Answer

integrate

Question 3

What is the drawback to using a linked server for integrating an external data source?

Accepted Answer

A) it enables a data source to be queried directly from within SQL Server 
B) it enables a client application to efficiently perform bulk copy operations 
C) it doesn't work well for dynamic data sources 
D) you must configure it using the bcp utility 
A) it enables a data source to be queried directly from within SQL Server 
B) it enables a client application to efficiently perform bulk copy operations 
C) it doesn't work well for dynamic data sources 
D) you must configure it using the bcp utility C

Question 4

SQL Server Data Tools have a selection of predefined project ___________ that include the Integration Services Business Intelligence project for designing Integration Services packages.

Accepted Answer

The answer of SQL Server Data Tools have a selection...

Question 5

Which of the following are the basic building blocks of an SSIS package?

Accepted Answer

A) processes 
B) flows 
C) functions 
D) tasks 
A) processes 
B) flows 
C) functions 
D) tasks

Question 6

The bcp utility can be executed to insert records from an external data file source into a SQL Server table.

Accepted Answer

A) True 
 B)False

Question 7

What are two methods you can use to execute an Integration Services package?

Accepted Answer

Using SQL Server Data Tools and the Debu

Question 8

Which of the following is the correct syntax for using the BULK INSERT statement?

Accepted Answer

A) BULK INSERT . . WITH ' ' FROM ( ) 
B) BULK INSERT FROM . . WITH ' ' OPTIONS 
C) BULK INSERT . . FROM ' ' WITH ( ) 
D) BULK INSERT WITH . . FROM ' ' OPTIONS 
A) BULK INSERT . . WITH ' ' FROM ( ) 
B) BULK INSERT FROM . . WITH ' ' OPTIONS 
C) BULK INSERT . . FROM ' ' WITH ( ) 
D) BULK INSERT WITH . . FROM ' ' OPTIONS

Question 9

How are data sources defined in a data flow task?

Accepted Answer

Data sources are defined using

Question 10

Describe SQL Server Data Tools. How can it be used to create SSIS packages?

Accepted Answer

SQL Server Data Tools have a selection o

Question 11

Match between columns
                        Premises: tasks that perform operations on schema objects and data on a SQL server
a storage unit within an SSIS package that can hold both static values or whose values can be set at run time
a text file that contains data
tasks that move data between a source and a destination
the order in which each task in an SSIS package is executed
tasks that perform essential database maintenance functions
tasks that permit an SSIS package to interact with other applications
a stand-alone application that is run from a command prompt and that can be used for bidirectional data transfer
an object within an SSIS package that stores the configuration information necessary to connect to an individual data source
a collection of one or more tasks grouped together as a series of logical steps

Accepted Answer

The Answer of data flow tasks and control flow and is...

Question 12

What should you use when running the bcp utility if you want to import only certain columns and run the command interactively?

Accepted Answer

A) copy exclusion 
B) import filter 
C) schema view 
D) format file 
A) copy exclusion 
B) import filter 
C) schema view 
D) format file

Question 13

What is control flow and how can it be altered in an SSIS package?

Accepted Answer

The order in which each task is executed

Question 14

Which of the following is true about packages created with SQL Server Data Tools?

Accepted Answer

A) you need to manually create a folder named "SSIS packages" 
B) the default package name is default.dtsx 
C) projects can contain multiple Integration Services packages 
D) the user interface is a command prompt 
A) you need to manually create a folder named "SSIS packages" 
B) the default package name is default.dtsx 
C) projects can contain multiple Integration Services packages 
D) the user interface is a command prompt

Question 15

What factors should a database administrator consider when selecting the appropriate data integration tools for a given situation?

Accepted Answer

When selecting the appropriate data inte

Question 16

What are SSIS packages, how are they stored, and what are their basic building blocks?

Accepted Answer

An SSIS package groups together a set of

Question 17

A package configuration file can be generated from with SQL Server Data Tools for each environment a package will run in.

Accepted Answer

A) True 
 B)False

Question 18

What should be used if you want an email alert to be sent to you if an error occurs in the SSIS package?

Accepted Answer

A) user variable 
B) event handler 
C) connection manager 
D) maintenance task 
A) user variable 
B) event handler 
C) connection manager 
D) maintenance task

Question 19

How does SQL Server 2012 support ODBC for bulk copy operations?

Accepted Answer

SQL Server provides support for ODBC thr

Question 20

Configuring a linked server which enables a data source to be queried directly from within SQL Server works well for static data sources.

Accepted Answer

A) True 
 B)False

What type of component should you use if you need to convert numeric data to string data as the data flows between the source and destination?

SSIS is a component of SQL Server that can be used to ___________ many different types of external data sources.

What is the drawback to using a linked server for integrating an external data source?

SQL Server Data Tools have a selection of predefined project ___________ that include the Integration Services Business Intelligence project for designing Integration Services packages.

Which of the following are the basic building blocks of an SSIS package?

The bcp utility can be executed to insert records from an external data file source into a SQL Server table.

What are two methods you can use to execute an Integration Services package?

Which of the following is the correct syntax for using the BULK INSERT statement?

How are data sources defined in a data flow task?

Describe SQL Server Data Tools. How can it be used to create SSIS packages?

What should you use when running the bcp utility if you want to import only certain columns and run the command interactively?

What is control flow and how can it be altered in an SSIS package?

Which of the following is true about packages created with SQL Server Data Tools?

What factors should a database administrator consider when selecting the appropriate data integration tools for a given situation?

What are SSIS packages, how are they stored, and what are their basic building blocks?

A package configuration file can be generated from with SQL Server Data Tools for each environment a package will run in.

What should be used if you want an email alert to be sent to you if an error occurs in the SSIS package?

How does SQL Server 2012 support ODBC for bulk copy operations?

Configuring a linked server which enables a data source to be queried directly from within SQL Server works well for static data sources.

Introduction to SQL Server 2012

Deploying SQL Server 2012

Architecture and Configuration

Creating SQL Server 2012 Databases

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Monitoring SQL Server 2012

Filters

Exam 9: Data Integration

What type of component should you use if you need to convert numeric data to string data as the data flows between the source and destination?

SSIS is a component of SQL Server that can be used to ___________ many different types of external data sources.

What is the drawback to using a linked server for integrating an external data source?

SQL Server Data Tools have a selection of predefined project ___________ that include the Integration Services Business Intelligence project for designing Integration Services packages.

Which of the following are the basic building blocks of an SSIS package?

The bcp utility can be executed to insert records from an external data file source into a SQL Server table.

What are two methods you can use to execute an Integration Services package?

Which of the following is the correct syntax for using the BULK INSERT statement?

How are data sources defined in a data flow task?

Describe SQL Server Data Tools. How can it be used to create SSIS packages?

What should you use when running the bcp utility if you want to import only certain columns and run the command interactively?

What is control flow and how can it be altered in an SSIS package?

Which of the following is true about packages created with SQL Server Data Tools?

What factors should a database administrator consider when selecting the appropriate data integration tools for a given situation?

What are SSIS packages, how are they stored, and what are their basic building blocks?

A package configuration file can be generated from with SQL Server Data Tools for each environment a package will run in.

What should be used if you want an email alert to be sent to you if an error occurs in the SSIS package?

How does SQL Server 2012 support ODBC for bulk copy operations?

Configuring a linked server which enables a data source to be queried directly from within SQL Server works well for static data sources.

Introduction to SQL Server 2012

Deploying SQL Server 2012

Architecture and Configuration

Creating SQL Server 2012 Databases

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Monitoring SQL Server 2012

Filters