You create a Data Store object (advanced) with only the settings "Staging Data Store Object" and "Reporting-Enabled" selected. Which table or combination of tables is used when data is extracted…

Question

Options

• AInbound table only
• BActive Data table only
• CThe union of the Inbound table and the Active Data table
• DChangelog table only

• A
  10% (7)
• B
  3% (2)
• C
  81% (55)
• D
  6% (4)

Explanation

When "Staging Data Store Object" is enabled, incoming records land in the Inbound table (a staging layer awaiting activation); when "Reporting-Enabled" is added, the Active Data table is also populated and kept current. Because both settings are active simultaneously, a data flow extraction must read from both tables unioned together to capture the full, complete dataset - staged records that haven't been activated yet plus already-activated records.

Why the distractors are wrong:

• A (Inbound only): This would miss all previously activated records sitting in the Active Data table.
• B (Active Data only): This would miss newly staged records in the Inbound table that haven't been merged/activated yet.
• D (Changelog only): The Changelog table tracks delta/change records for CDC purposes; neither "Staging" nor "Reporting-Enabled" triggers changelog-based extraction.

Memory tip: Think of the two selected settings as two buckets - "Staging" fills the Inbound bucket, "Reporting-Enabled" fills the Active Data bucket. When you extract, you pour both buckets together. If only one setting were chosen, you'd only get one bucket.

No community discussion yet for this question.