Question 560
An analyst is troubleshooting this business scenario: A supplier feed suddenly changes a column from OrderQty to Quantity, breaking an automated query. The attempt does not achieve the expected result. Which specific failure best explains the gap?
Explanation
Correct Answer
This defect explains why the required behavior failed. Schema drift requires repair of dependent transformations, not blind deletion. The corrective action is: Inspect the applied-step error, update the renamed-field dependency and validate schema change behavior.
Incorrect Answers
Duplicating the staging query and editing only one version causes divergent fixes. The stated evidence instead indicates: Deleting the broken rename step without checking downstream references can corrupt measures.
Attempting to connect using the SQL Server connector will not parse a REST JSON response. The stated evidence instead indicates: Deleting the broken rename step without checking downstream references can corrupt measures.
Treating a duplicate lookup as one-to-many during enrichment can inflate fact rows. The stated evidence instead indicates: Deleting the broken rename step without checking downstream references can corrupt measures.