Home / GenAI Engineer practice test / Application Development / Question

Databricks Generative AI Engineer Associate · free practice question

For a project involving converting natural language to SQL queries, a machine learning group evaluated the performance of three different models. Their…

Exam-style question on Application Development from the free GenAI Engineer practice test, with the answer and a full explanation below.

Updated November 11, 2026

Application Development

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?

  1. AModel Y, because it achieves the highest Query Execution Success Rate of the three evaluated models.
  2. BModel Z, because it has by far the lowest Cost Per Operation of the three evaluated models.
  3. CModel X, because it alone exceeds a 0.87 success rate and stays within the $0.015 cost limit.
  4. DModel X and Model Y, because both meet the two requirements and team familiarity can decide.
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.

Take the full GenAI Engineer practice test free →

Would you pass today?

This question is one of 45 in the free, timed Databricks Generative AI Engineer Associate practice test. Take it and get a section-by-section score.

Start the free test →