You define a remote subscription Of type INSERT in an SAP RANA Smart Data Integration (SOI) real- tine update scenario. Which fields are added to the DataSource automatically? (3)

Question

Options

• ASDI_CHANGE_SEQUENCE
• BSDI_RECORD_SEQUENCE
• CSDI_RECORD_MODE
• DSDI_CHANGE_TYPE
• ESDI_CHANGE_TIME

• A
  5% (1)
• B
  10% (2)
• C
  86% (18)

Explanation

When you define a remote subscription of type INSERT in SAP HANA Smart Data Integration (SDI), three metadata fields are automatically appended to the DataSource to support real-time change tracking: SDI_RECORD_MODE tells the system whether the record represents a before-image or after-image of the changed row; SDI_CHANGE_TYPE captures the DML operation that triggered the event (INSERT, UPDATE, or DELETE); and SDI_CHANGE_TIME records the timestamp of when the change occurred. Together, these three fields give the consumer everything needed to reconstruct or react to a data change event.

Why A and B are wrong: SDI_CHANGE_SEQUENCE and SDI_RECORD_SEQUENCE are not fields automatically injected by the SDI subscription mechanism - they do not exist as standard auto-added metadata columns in this context and are plausible-sounding distractors designed to test whether you've memorized the actual field names.

Memory tip: Use the acronym "CTM" - Change Type, Change Time, Record Mode. These three tell you what operation happened, when it happened, and how to interpret the record. If you can remember CTM, you can eliminate the two sequence-based distractors immediately.

No community discussion yet for this question.