HOTSPOT
You create a Microsoft SQL Server Integration Services (SSIS) package as shown in the SSIS Package exhibit.
(Click the Exhibit button.)
The package uses data from the Products table and the Prices table. Properties of the Prices source are shown in the OLE DB Source Editor exhibit (Click the Exhibit Button.) and the Advanced Editor for Prices exhibit (Click the Exhibit button.)
You join the Products and Prices tables by using the ReferenceNr column.
You need to resolve the error with the package.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.Hot Area:
supplies data to the Merge and Merge Join transformations: set to True. order, and the sequence in which multiple columns are sorted. This property must be set for each column of sorted data. source or the upstream transformation.
Answer: 
Explanation:
There are two important sort properties that must be set for the source or upstream transformation that
The Merge Join Transformation requires sorted data for its inputs.
The IsSorted property of the output that indicates whether the data has been sorted. This property must be
The SortKeyPosition property of output columns that indicates whether a column is sorted, the column’s sort
If you do not use a Sort transformation to sort the data, you must set these sort properties manually on the
References: https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/sort-data-forthe-merge-and-merge-join-transformations