Microsoft-TS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance Set 1

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow. The SSIS data flow will transfer data to a SQL Server 2008 database named CKProducts. You want to ensure that the data flow refreshes the existing data in CKProducts with the data in the data flow. What should you do?

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. The SSIS package must contain a Data Flow task with a Fuzzy Grouping transformation that creates data. You received instructions to debug the SSIS package. To this end you need to browse the output data of the Fuzzy Grouping transformation in order to check on the constraints currently on the Fuzzy Grouping transformation. What should you do?

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) instance for Abc.com. The diagram below illustrates a portion of the SSIS package: You need to ensure that a parameter is created that will include important data that is required by the Data Flow Task and the Execute SQL Task. What should you do?

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow that adds the data from a source query to a result table for Abc.com. You want to add the rows that are included in the destination table. What should you do? (Choose all that apply)

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow. The SSIS data flow obtains data from two databases that are hosted on two separate SQL Server 2008 database servers. Each source is based on a SELECT statement that includes an ORDER BY clause. However, you receive the following error message when you connect the paths from the two sources: Data Flow Task: The input is not sorted. The 'input "Merge Join Left Input" (80)' must be sorted. You need to ensure that the data from every query is contained in every row in the data flow. You thus need to determine a way to accomplish this. What should you do?

You work as a database administrator at Abc.com. You are currently creating a SQL Server 2008 Integration Services (SSIS) instance for Abc.com. You use a For Each Loop container to perform data operations on multiple files. You need use a Data Flow task to extract the file contents to a database table. You want to log the results of the transactions into a table using an Execute SQL task. You need to configure the Execute SQL task so that it can run in more than one transaction. What should you do? (Choose all that apply)

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) instance that includes the following components: * An OnError method * A data flow job that is included in a For Loop container * A Flat File result component that uses a Flat File connection controller. You want to log error data from an expression that contains the package version to a Word file whenever an error occurs. What should you do?

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) project for Abc.com. The SSIS project properties are shown below: You need to develop a deployment manifest for the packages in the SSIS project. What should you do?

You work as a database administrator at Abc.com. You are in the process of changing a SQL Server 2008 Integration Services (SSIS) instance for Abc.com. Abc.com makes use of the SSIS instance to retrieve the contents of a Word file and transfer it to database table. You want to make changes to the SSIS instance in order to retrieve the contents of numerous Word files that are located in the same folder. What should you do? (Choose all that apply)

You work as a database administrator at Abc.com. The Abc.com network contains 15 SQL Server 2008 database servers. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package that has to be interpolated on all 15 database servers. However, you are unable to access the file system of the servers. You thus need to modify the package setting attributes while the package is running. What should you do?