For a project involving converting natural language to SQL queries, a machine learning group evaluated the performance of three different models. Their experimental results are as follows:
- Model X: Query Execution Success Rate = 0.88, Cost Per Operation = $0.012
- Model Y: Query Execution Success Rate = 0.91, Cost Per Operation = $0.047
- Model Z: Query Execution Success Rate = 0.86, Cost Per Operation = $0.003
Operational requirements stipulate that the Cost Per Operation must not exceed $0.015 AND the Query Execution Success Rate must be greater than 0.87. Which model adheres to these TWO mandatory conditions?
Answer & explanation
Correct answer: C
WHY C: Applying both constraints: Query Execution Success Rate > 0.87: Model X (0.88, pass), Model Y (0.91, pass), Model Z (0.86, fail). Cost Per Operation not above $0.015: Model X ($0.012, pass), Model Y ($0.047, fail), Model Z ($0.003, pass). Model X is the one model that satisfies both constraints simultaneously.
WHY NOT A: Model Y achieves the highest success rate, but its $0.047 cost is more than 3x the $0.015 budget ceiling. It fails the cost constraint and is ineligible.
WHY NOT B: Model Z costs just $0.003 per operation, but its success rate of 0.86 falls below the required 0.87 threshold. It fails the success-rate constraint.
WHY NOT D: Model Y fails the cost constraint ($0.047 > $0.015), so it does not qualify. A single model meets both criteria, which makes team familiarity irrelevant as a selection factor.