HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The data source for
the data flow task is a table that has been configured as a change data capture (CDC) table.
You are using a CDC Source component to obtain the CDC data.
The CDC Source component has the following requirements:
The output must include metadata columns that indicate which source columns have
changed.
The output must return only one change row per source row that is modified in the current
CDC processing range.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate
option or options in the dialog box in the answer area.)
Which CDC processing mode should you select?
HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The data source for
the data flow task is a table that has been configured as a change data capture (CDC) table.
You are using a CDC Source component to obtain the CDC data.
The CDC Source component has the following requirements:
The output must include metadata columns that indicate which source columns have
changed.
The output must return only one change row per source row that is modified in the current
CDC processing range.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate
option or options in the dialog box in the answer area.)
The answer appear to be correct according to this link;
https://msdn.microsoft.com/en-us/library/hh231004(v=sql.110).aspx
CDC Processing Mode
Select the processing mode that best handles your processing needs. The possible options are:
All: Returns the changes in the current CDC range without the Before Update values.
All with old values: Returns the changes in the current CDC processing range including the old values (Before Update). For each Update operation, there will be two rows, one with the before-update values and one with the after-update value.
Net: Returns only one change row per source row modified in the current CDC processing range. If a source row was updated multiple times, the combined change is produced (for example, insert+update is produced as a single update and update+delete is produced as a single delete). When working in Net change processing mode, it is possible to split the changes to Delete, Insert and Update outputs and handle them in parallel because the single source row appears in more than one output.
Net with update mask: This mode is similar to the regular Net mode but it also adds boolean columns with the name pattern __$__Changed that indicate changed columns in the current change row.
Net with merge: This mode is similar to the regular Net mode but with Insert and Update operations merged into a single Merge operation (UPSERT).
is the answer ‘Net with update mask’?
I think its net only or net with merge.
scratch that it should be net only due to the fact “The output must return only one change row per source row that is modified in the current
CDC processing range.”
And what jeff provided:
“Net: Returns only one change row per source row modified in the current CDC processing range. If a source row was updated multiple times, the combined change is produced (for example, insert+update is produced as a single update and update+delete is produced as a single delete). When working in Net change processing mode, it is possible to split the changes to Delete, Insert and Update outputs and handle them in parallel because the single source row appears in more than one output.”
is the answer ‘Net with update mask’?
The answer is C.
Net because one row per change row and update because of metadata columns.