Question 290
A data platform architect must resolve the following design constraint: A hospital finance report defines visits by discharge date rather than check-in date. Before accepting the change, what evidence most directly demonstrates that the intended outcome was achieved?
Explanation
Correct Answer
“Query-result reconciliation across filters, dimensions, join paths and fiscal-period definitions” is supported by this requirement: A hospital finance report defines visits by discharge date rather than check-in date. Text-to-SQL needs accurate semantic modeling of measures and relational joins. Verify it using query-result reconciliation across filters, dimensions, join paths and fiscal-period definitions.
Incorrect Answers
“How many metadata descriptions are stored without query testing” would not meet the requirement that a hospital finance report defines visits by discharge date rather than check-in date. Text-to-SQL needs accurate semantic modeling of measures and relational joins. The more reliable approach is to specify business terms, join relationships, time dimensions and validated calculation definitions in the structured semantic layer.
“Text passage hit rate without any SQL execution” would not meet the requirement that a hospital finance report defines visits by discharge date rather than check-in date. Text-to-SQL needs accurate semantic modeling of measures and relational joins. The more reliable approach is to specify business terms, join relationships, time dimensions and validated calculation definitions in the structured semantic layer.
“Single total matching while filtered subgroup totals are wrong” would not meet the requirement that a hospital finance report defines visits by discharge date rather than check-in date. Text-to-SQL needs accurate semantic modeling of measures and relational joins. The more reliable approach is to specify business terms, join relationships, time dimensions and validated calculation definitions in the structured semantic layer.