Question 400
The team deployed this approach: Append the monthly queries after reconciling common column names and types. Original need: A retail ETL must stack sales exported separately for April and May, both with matching column semantics. Which observation establishes the intended result?
Explanation
Correct Answer
This checks the actual result rather than a saved setting. Append adds rows; Merge combines columns through matching keys. A failed implementation may show: Merging April to May by customer ID would combine columns instead of stacking transactions.
Incorrect Answers
Each entity becomes a record and attribute columns contain correct typed values. However, this does not establish the required outcome: row counts equal April plus May and period summaries reconcile.
The quantity column loads under a documented mapping and subsequent steps run. However, this does not establish the required outcome: row counts equal April plus May and period summaries reconcile.
The same country maps to one normalized key and the country's row counts reconcile. However, this does not establish the required outcome: row counts equal April plus May and period summaries reconcile.