Exam DP-203 topic 2 question 20 discussion

I think "disjoint" should be True, so that data can be sent to all matching conditions. In this way the "all" output can get the data from every department, which ensures that "data can also be processed by the entire company".

As per the link provided in the explanation disjoint:false looks correct. I believe you must go through the link https://docs.microsoft.com/en-us/azure/data-factory/data-flow-conditional-split and choose you answer for disjoint wisely . I will go with "False"

Guys, Guys, Guys..... The clue is in the options given. If default: true was the right answer, then options A and F would be the same. Either of them could have fulfilled the criteria. If only one of them is right (and that is what we expect) then the order matters. And order only matters when default: false. This also means that 'all' is slightly misleading. Refer back to the question: it does not imply all of the data needs to be available, just that the 'entire company can process'. Which is still okay if the 'all' had everything but ecommerce, retail and wholesale. Final point: If default: true was the right answer, options B and C would be the same. Either of the them could have worked. Conclusion: default: false.

disjoint: true: If set to true, the row will be sent to all matching conditions. This means that a single row can appear in multiple output streams if it matches multiple conditions. disjoint: false: If set to false, the row will be sent to the first matching condition only. Once a row matches a condition, it will not be evaluated against subsequent conditions.

Guys Disjoint is True 110% and I will tell you why. disjoint: false means that rows will be directed to the first branch whose condition is satisfied, and subsequent conditions are ignored. This might not fulfill the requirement because you want to process data for multiple departments, and with disjoint: false, a row would go to the first department branch it satisfies, ignoring the other departments. Disjoint TRUE is more appropriate because it fulfills the requirement of processing data for individual departments (Ecommerce, retail, and wholesale) while also handling data for the entire company. Because all rows will match 2 conditions: 1st conditon. They will have one of the three depts 2nd Condition. They will match the all condition That's why it MUST BE TRUE.

False is correct

I think the disjoint should be 'False' By setting "disjoint true" for activities in a pipeline, you are essentially indicating that these activities are independent and can be executed concurrently. This can help improve the overall performance and efficiency of the pipeline by allowing for parallel execution of activities that do not have any interdependencies.

CleanData split(dept==‘ecommerce’, dept==‘retail’, dept==‘wholesale’) ~> SplitByDept@(disjoint: false) This will split the data by department and allow for processing of data for the entire company as well as for individual departments.

disjoin = true if you want all , if disjoint = false, nothing in ALL split

Disjoint=False

disjoint=false The below example is a conditional split transformation named SplitByYear that takes in incoming stream CleanData. This transformation has two split conditions year < 1960 and year > 1980. disjoint is false because the data goes to the first matching condition rather than all matching conditions. Every row matching the first condition goes to output stream moviesBefore1960. All remaining rows matching the second condition go to output stream moviesAFter1980. All other rows flow through the default stream AllOtherMovies. from https://learn.microsoft.com/en-us/azure/data-factory/data-flow-conditional-split

Given answer correct

The given answer is 100000% crct, don't confuse with others

Given answer is 100% correct

Everyone is discussing about disjoint. But if disjoint is true then there is no ordering required of ecommerce,retail,wholesale, all .so we can fill 1st option with 2 or 3 and 3rd option with 1 or 6.

I think it should be disjoint is True based on microsofts example. it states that when disjoint is false each row will only go to the first matching condition. However in the example I believe each row will go to its matching department plus an aggregate stream that takes in every value regardless. Hence disjoint should be true

Definetely Disjoint=Trues as per Microsoft doc