Matching
Matching :
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
Responses:
data flow tasks
control flow
maintenance tasks
workflow tasks
user variable
connection manager
SQL Server tasks
bcp utility
SSIS package
flat file
Correct Answer:
Premises:
Responses:
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
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
Responses:
Related Questions
Q6: The bcp utility can be executed to
Q7: What are two methods you can use
Q8: Which of the following is the correct
Q9: How are data sources defined in a
Q10: Describe SQL Server Data Tools. How can
Q12: What should you use when running the
Q13: What is control flow and how can
Q14: Which of the following is true about
Q15: What factors should a database administrator consider
Q16: What are SSIS packages, how are they