Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.You are developing a Microsoft SQL Server Integration Services (SSIS) package. The package design consists of two differently structured sources in a single data flow. The Sales source retrieves sales transactions from a SQL Server database, and the Product source retrieves product details from an XML file.You need to combine the two data flow sources into a single output dataset.Which SSIS Toolbox item should you use?
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.You are developing a Microsoft SQL Server Integration Services (SSIS) package.You are importing data from databases at retail stores into a central data warehouse. All stores use the same database schema.The query being executed against the retail stores is shown below:The data source property named IsSorted is set to True. The output of the transform must be sorted.You need to add a component to the data flow.Which SSIS Toolbox item should you use?
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.You are developing a Microsoft SQL Server Integration Services (SSIS) package.You need to ensure that the package records the current Log Sequence Number (LSN) in the source database before the package begins reading source tables.Which SSIS Toolbox item should you use?
You have a data warehouse that contains a fact table named Table1 and a Product table named Dim1. Dim1 is configured as shown in the following table.You are adding a second OLTP system to the data warehouse as a new fact table named Table2. The Product table of the OLTP system is configured as shown in the following tableYou need to modify Dim1 to ensure that the table can be used for both fact tables.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
You have a fact table in a data warehouse that stores financial data. The table contains eight column configured as shown in the following table.You need to identify a column that can be aggregated across all dimensions.Which column should you identify?
You are designing a warehouse named DW1.A table named Table1 is partitioned by using the following partitioning scheme and function.Reports are generated from the data in Table1.You need to ensure that queries to DW1 return results as quickly as possible.Which column should appear in the WHERE statement clause of the query?
