Question 220
A controlled reporting layer must not silently break when a source table drops a column it depends on. The team implemented this change: Define a schema-bound view and test planned DDL changes in CI. Which result would best confirm the change worked?
Explanation
Correct Answer
Incompatible source-column changes fail until dependencies are addressed. SCHEMABINDING can prevent incompatible modifications to referenced objects in supported SQL Server views. Schema binding increases change coordination and does not validate business meaning.
Incorrect Answers
That observation could pass while the problem persists: SCHEMABINDING is the specialized dependency guard; ordinary view definitions do not enforce the DDL contract.
This acceptance test measures the wrong outcome: Bound-view syntax and dependency restrictions must be validated on the actual supported engine and schema.
The suggested success signal is inadequate because Object naming alone does not preserve referenced column definitions; enforce and test binding on actual dependencies. The suggested measurement would appear successful even in a reproducible case where the original failure remains.