Question 120
During a Gen AI proof-of-value review, the team reports: Supply planning wants actual versus forecast unit cost by warehouse from relational purchase data. Which technical approach should be preferred for this described workload?
Explanation
Correct Answer
“Define governed semantic business measures and relationships for Cortex Analyst, then validate generated SQL against expected data questions” is supported by this requirement: Supply planning wants actual versus forecast unit cost by warehouse from relational purchase data. Text-to-SQL for business metrics needs semantic constraints and checked structured query results. Verify it using execution-correct SQL and reconciled metric results on a held-out set of natural-language business questions.
Incorrect Answers
“Index KPI descriptions as a search corpus and let a language model invent numeric totals” would not meet the requirement that supply planning wants actual versus forecast unit cost by warehouse from relational purchase data. Text-to-SQL for business metrics needs semantic constraints and checked structured query results. The more reliable approach is to define governed semantic business measures and relationships for Cortex Analyst, then validate generated SQL against expected data questions.
“Export operational tables into free-form prose and rely on text summarization for exact totals” would not meet the requirement that supply planning wants actual versus forecast unit cost by warehouse from relational purchase data. Text-to-SQL for business metrics needs semantic constraints and checked structured query results. The more reliable approach is to define governed semantic business measures and relationships for Cortex Analyst, then validate generated SQL against expected data questions.
“Have the model directly generate unrestricted SQL over every raw schema without semantic definitions” would not meet the requirement that supply planning wants actual versus forecast unit cost by warehouse from relational purchase data. Text-to-SQL for business metrics needs semantic constraints and checked structured query results. The more reliable approach is to define governed semantic business measures and relationships for Cortex Analyst, then validate generated SQL against expected data questions.