Question 340
Before funding a Gen AI deployment, a sponsor asks about this use case: A travel company needs currency-converted revenue grouped by booking cohort. Which validation would best distinguish a working solution from a persuasive but incomplete demonstration?
Explanation
Correct Answer
“Query-result reconciliation across filters, dimensions, join paths and fiscal-period definitions” is supported by this requirement: A travel company needs currency-converted revenue grouped by booking cohort. 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
“Single total matching while filtered subgroup totals are wrong” would not meet the requirement that a travel company needs currency-converted revenue grouped by booking cohort. 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.
“How many metadata descriptions are stored without query testing” would not meet the requirement that a travel company needs currency-converted revenue grouped by booking cohort. 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 travel company needs currency-converted revenue grouped by booking cohort. 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.