mcAfee Secure Website
23

Databricks Certified Generative AI Engineer Associate Bundle

Exam Code: Certified Generative AI Engineer Associate

Exam Name Certified Generative AI Engineer Associate

Certification Provider: Databricks

Corresponding Certification: Databricks Certified Generative AI Engineer Associate

Certified Generative AI Engineer Associate Training Materials $19.99

Reliable & Actual Study Materials for Certified Generative AI Engineer Associate Exam Success

The Latest Certified Generative AI Engineer Associate Exam Questions as Experienced in the Actual Test!

  • 24
    Questions & Answers

    Certified Generative AI Engineer Associate Questions & Answers

    123 Questions & Answers

    Includes questions types found on actual exam such as drag and drop, simulation, type in, and fill in the blank.

  • exam =30
    Study Guide

    Certified Generative AI Engineer Associate Study Guide

    230 PDF Pages

    Study Guide developed by industry experts who have written exams in the past. They are technology-specific IT certification researchers with at least a decade of experience at Fortune 500 companies.

exam =32

Certified Generative AI Engineer Associate Practice Tests

Guarantee

Satisfaction Guaranteed

Pass4sure has a remarkable Databricks Candidate Success record. We're confident of our products and provide no hassle product exchange. That's how confident we are!

99.3% Pass Rate
Total Cost: $154.98
Bundle Price: $134.99

Purchase Individually

  • exam =34
    Questions & Answers

    Questions & Answers

    123 Questions

    $124.99
    exam =35
  • exam =36
    Study Guide

    Study Guide

    230 PDF Pages

    $29.99

Databricks Certified Generative AI Engineer Associate Practice Test 29

Question 280

What long-term control is MOST directly justified by this Databricks GenAI situation? A deployed chatbot silently uses a different embedding model from the retrieval index built in development.

  1. Never rely on interactive notebook state or unpinned runtime packages when promoting a served model.
  2. Do not equate registering a model with approving its business safety or access to all governed tables.
  3. Require approval/rollback for prompt and index changes that alter user-facing model behavior.
  4. Record source index versions and external dependencies with the model artifact to support rollback.

Explanation

Correct Answer

D:

Correct. A deployable RAG application needs tracked model code, retriever config, embedding model, dependency versions, signature and example input. In the given situation — A deployed chatbot silently uses a different embedding model from the retrieval index built in development. — the targeted safeguard action is: Record source index versions and external dependencies with the model artifact to support rollback. It preserves an enduring engineering or governance boundary after the current issue is fixed.

Incorrect Answers

A:

Not the strongest safeguard choice for this specific question. Never rely on interactive notebook state or unpinned runtime packages when promoting a served model. This action primarily relates to MLflow pyfunc packaging for pre- and post-processing: A custom MLflow pyfunc model wraps request parsing, retriever/model invocation and output formatting inside a reproducible predict interface. However, the described case — A deployed chatbot silently uses a different embedding model from the retrieval index built in development. — is testing RAG production bundle metadata and dependencies. It does not directly establish the safeguard outcome or constraint that the question requires; it may still be useful in a different stage or incident.

B:

Not the strongest safeguard choice for this specific question. Do not equate registering a model with approving its business safety or access to all governed tables. This action primarily relates to Unity Catalog registered model version and privileges: MLflow-logged models can be registered in Unity Catalog, with governed names, permissions and traceable version lineage. However, the described case — A deployed chatbot silently uses a different embedding model from the retrieval index built in development. — is testing RAG production bundle metadata and dependencies. It does not directly establish the safeguard outcome or constraint that the question requires; it may still be useful in a different stage or incident.

C:

Not the strongest safeguard choice for this specific question. Require approval/rollback for prompt and index changes that alter user-facing model behavior. This action primarily relates to CI/CD pipelines for retrieval and agent components: Production promotions should test source index, prompt, model packaging and tool behavior independently before release. However, the described case — A deployed chatbot silently uses a different embedding model from the retrieval index built in development. — is testing RAG production bundle metadata and dependencies. It does not directly establish the safeguard outcome or constraint that the question requires; it may still be useful in a different stage or incident.

Question 281

What information should the engineer inspect before choosing a remedy? An order assistant answers shipping questions without using the provided account_id, mixing orders across customers.

  1. Inspect parsed intent, extracted keys, authorization check and actual query filter predicates.
  2. Inspect request/response sensitive spans, redaction logs, moderation findings and business exceptions.
  3. Inspect trace context passages, token distribution, coverage of necessary conditions and retrieval rank.
  4. Inspect tool-call traces, retrieved source text and permission decisions for instruction-origin confusion.

Explanation

Correct Answer

A:

Correct. User intent and structured fields such as account_id should drive authorized SQL lookups or retrieval filters, not be ignored in free text. In the given situation — An order assistant answers shipping questions without using the provided account_id, mixing orders across customers. — the targeted diagnose action is: Inspect parsed intent, extracted keys, authorization check and actual query filter predicates. It inspects the stage or constraint most likely to explain the observed failure before changing the system.

Incorrect Answers

B:

Not the strongest diagnose choice for this specific question. Inspect request/response sensitive spans, redaction logs, moderation findings and business exceptions. This action primarily relates to PII masking and output moderation as complementary guardrails: Input redaction and output checks serve distinct purposes; retain only necessary identifiers and validate actions separately. However, the described case — An order assistant answers shipping questions without using the provided account_id, mixing orders across customers. — is testing Query-field driven prompt and retrieval filters. It does not directly establish the diagnose outcome or constraint that the question requires; it may still be useful in a different stage or incident.

C:

Not the strongest diagnose choice for this specific question. Inspect trace context passages, token distribution, coverage of necessary conditions and retrieval rank. This action primarily relates to Chunk quality evaluation and boundary splitting: Retrieval failure can arise from overly small chunks that omit needed context or overly large chunks that dilute relevance. However, the described case — An order assistant answers shipping questions without using the provided account_id, mixing orders across customers. — is testing Query-field driven prompt and retrieval filters. It does not directly establish the diagnose outcome or constraint that the question requires; it may still be useful in a different stage or incident.

D:

Not the strongest diagnose choice for this specific question. Inspect tool-call traces, retrieved source text and permission decisions for instruction-origin confusion. This action primarily relates to Prompt-injection defenses for retrieved context: Retrieved content is lower-trust data; embedded instructions must not trigger privileged tool calls or override assistant rules. However, the described case — An order assistant answers shipping questions without using the provided account_id, mixing orders across customers. — is testing Query-field driven prompt and retrieval filters. It does not directly establish the diagnose outcome or constraint that the question requires; it may still be useful in a different stage or incident.

Question 282 (Select TWO)

Select TWO: the immediate change and one ongoing control for this Databricks GenAI case. A LangChain workflow sends a dictionary of question and context to a prompt that expects only input, raising a key error.

  1. Map runnable outputs to matching prompt-variable names and validate the input dictionary contract.
  2. Evaluate capable long-context models on legal clauses and latency/cost acceptance thresholds.
  3. Pin dependency and prompt schemas across releases so library updates do not silently break chain invocation.
  4. Keep component roles explicit so updates to a generation model do not silently alter retrieval vectors.

Explanation

Correct Answers

A:

Correct (immediate corrective action). Map runnable outputs to matching prompt-variable names and validate the input dictionary contract. In this scenario, A LangChain workflow sends a dictionary of question and context to a prompt that expects only input, raising a key error. The governing mechanism is: Composable runnable chains pass typed values between retrieval, prompt and model stages; each binding must preserve expected input keys. One selected option addresses the immediate workflow, while the other guards the same failure mode after deployment. Both satisfy the TWO-part requirement.

C:

Correct (continuing risk control). Pin dependency and prompt schemas across releases so library updates do not silently break chain invocation. In this scenario, A LangChain workflow sends a dictionary of question and context to a prompt that expects only input, raising a key error. The governing mechanism is: Composable runnable chains pass typed values between retrieval, prompt and model stages; each binding must preserve expected input keys. One selected option addresses the immediate workflow, while the other guards the same failure mode after deployment. Both satisfy the TWO-part requirement.

Incorrect Answers

B:

Not the strongest safeguard choice for this specific question. Evaluate capable long-context models on legal clauses and latency/cost acceptance thresholds. This action primarily relates to Model selection by quality latency and budget: Select the smallest suitable model that meets a task's accuracy and latency constraints under realistic workload, not marketing rank. However, the described case — A LangChain workflow sends a dictionary of question and context to a prompt that expects only input, raising a key error. — is testing LangChain runnable composition and invocation. It does not directly establish the safeguard outcome or constraint that the question requires; it may still be useful in a different stage or incident.

D:

Not the strongest safeguard choice for this specific question. Keep component roles explicit so updates to a generation model do not silently alter retrieval vectors. This action primarily relates to Specialized model versus general LLM: Embedding, reranking, extraction and generative models solve different stages and should be evaluated for their actual role. However, the described case — A LangChain workflow sends a dictionary of question and context to a prompt that expects only input, raising a key error. — is testing LangChain runnable composition and invocation. It does not directly establish the safeguard outcome or constraint that the question requires; it may still be useful in a different stage or incident.

Question 283

What long-term control is MOST directly justified by this Databricks GenAI situation? A search result includes fake 'system message' text requesting the assistant reveal private SQL results.

  1. Retain a sampling and redaction policy for traces rather than logging raw secrets in production.
  2. Retest prompt injection protections whenever new retrieval connectors or tools are introduced.
  3. Do not tune chunk length on one successful demo; measure evidence recall and grounded answer performance.
  4. Never trust an LLM-extracted customer identifier without server-side permission validation.

Explanation

Correct Answer

B:

Correct. Retrieved content is lower-trust data; embedded instructions must not trigger privileged tool calls or override assistant rules. In the given situation — A search result includes fake 'system message' text requesting the assistant reveal private SQL results. — the targeted safeguard action is: Retest prompt injection protections whenever new retrieval connectors or tools are introduced. It preserves an enduring engineering or governance boundary after the current issue is fixed.

Incorrect Answers

A:

Not the strongest safeguard choice for this specific question. Retain a sampling and redaction policy for traces rather than logging raw secrets in production. This action primarily relates to MLflow tracing in an Agent Framework workflow: MLflow tracing records agent steps, tool calls and latency; integration must retain child spans and inputs without leaking secrets. However, the described case — A search result includes fake 'system message' text requesting the assistant reveal private SQL results. — is testing Prompt-injection defenses for retrieved context. It does not directly establish the safeguard outcome or constraint that the question requires; it may still be useful in a different stage or incident.

C:

Not the strongest safeguard choice for this specific question. Do not tune chunk length on one successful demo; measure evidence recall and grounded answer performance. This action primarily relates to Chunk quality evaluation and boundary splitting: Retrieval failure can arise from overly small chunks that omit needed context or overly large chunks that dilute relevance. However, the described case — A search result includes fake 'system message' text requesting the assistant reveal private SQL results. — is testing Prompt-injection defenses for retrieved context. It does not directly establish the safeguard outcome or constraint that the question requires; it may still be useful in a different stage or incident.

D:

Not the strongest safeguard choice for this specific question. Never trust an LLM-extracted customer identifier without server-side permission validation. This action primarily relates to Query-field driven prompt and retrieval filters: User intent and structured fields such as account_id should drive authorized SQL lookups or retrieval filters, not be ignored in free text. However, the described case — A search result includes fake 'system message' text requesting the assistant reveal private SQL results. — is testing Prompt-injection defenses for retrieved context. It does not directly establish the safeguard outcome or constraint that the question requires; it may still be useful in a different stage or incident.

Question 284

What validation would most convincingly show the correction works? A LangChain pipeline returns an SDK message object while its API gateway expects a plain answer string.

  1. Run a fixed request through each stage and assert the final API schema and reference grounding.
  2. Execute a small sample query then validate throughput, cost, failed rows and result parsing.
  3. Test model invocation under realistic throughput and verify output schema, quota and governance constraints.
  4. Load the registered bundle in a clean environment and validate retrieval-to-generation behavior end to end.

Explanation

Correct Answer

A:

Correct. A minimal chain composes a retriever, prompt, LLM and output parser, preserving required variables and failure states. In the given situation — A LangChain pipeline returns an SDK message object while its API gateway expects a plain answer string. — the targeted verify action is: Run a fixed request through each stage and assert the final API schema and reference grounding. It tests an observable outcome using realistic inputs rather than relying on a working demo alone.

Incorrect Answers

B:

Not the strongest verify choice for this specific question. Execute a small sample query then validate throughput, cost, failed rows and result parsing. This action primarily relates to SQL ai_query for governed batch inference: `ai_query()` invokes an available serving endpoint from SQL; suitability depends on supported runtimes, endpoint and workload. However, the described case — A LangChain pipeline returns an SDK message object while its API gateway expects a plain answer string. — is testing Simple prompt-retrieval-generation chain assembly. It does not directly establish the verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.

C:

Not the strongest verify choice for this specific question. Test model invocation under realistic throughput and verify output schema, quota and governance constraints. This action primarily relates to Foundation Model API versus custom serving choices: Databricks Foundation Model APIs offer managed access to supported models; custom serving is suitable for specialized models or control needs. However, the described case — A LangChain pipeline returns an SDK message object while its API gateway expects a plain answer string. — is testing Simple prompt-retrieval-generation chain assembly. It does not directly establish the verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.

D:

Not the strongest verify choice for this specific question. Load the registered bundle in a clean environment and validate retrieval-to-generation behavior end to end. This action primarily relates to RAG production bundle metadata and dependencies: A deployable RAG application needs tracked model code, retriever config, embedding model, dependency versions, signature and example input. However, the described case — A LangChain pipeline returns an SDK message object while its API gateway expects a plain answer string. — is testing Simple prompt-retrieval-generation chain assembly. It does not directly establish the verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.

Question 285

After revising the application, which test BEST demonstrates the intended behavior? A low-cost support search uses short chunks but the proposed model multiplies embedding dimensions by eight.

  1. Run equivalent retrieval tests including storage and refresh cost for candidate encoders.
  2. Run paired representative requests and record quality versus p95 latency and cost tradeoffs.
  3. Verify matched query and document vectors use the approved version and retrieval improves on held-out examples.
  4. Check embedding dimensions or extracted-field validation against task-specific acceptance tests.

Explanation

Correct Answer

A:

Correct. Embedding width affects index storage and computation, and larger dimensions do not automatically improve task relevance. In the given situation — A low-cost support search uses short chunks but the proposed model multiplies embedding dimensions by eight. — the targeted verify action is: Run equivalent retrieval tests including storage and refresh cost for candidate encoders. It tests an observable outcome using realistic inputs rather than relying on a working demo alone.

Incorrect Answers

B:

Not the strongest verify choice for this specific question. Run paired representative requests and record quality versus p95 latency and cost tradeoffs. This action primarily relates to Model selection by quality latency and budget: Select the smallest suitable model that meets a task's accuracy and latency constraints under realistic workload, not marketing rank. However, the described case — A low-cost support search uses short chunks but the proposed model multiplies embedding dimensions by eight. — is testing Embedding dimensions latency and index storage. It does not directly establish the verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.

C:

Not the strongest verify choice for this specific question. Verify matched query and document vectors use the approved version and retrieval improves on held-out examples. This action primarily relates to Embedding model swap and reindex compatibility: Changed embedding dimensions or model semantics typically require re-embedding and index consistency before comparing search quality. However, the described case — A low-cost support search uses short chunks but the proposed model multiplies embedding dimensions by eight. — is testing Embedding dimensions latency and index storage. It does not directly establish the verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.

D:

Not the strongest verify choice for this specific question. Check embedding dimensions or extracted-field validation against task-specific acceptance tests. This action primarily relates to Specialized model versus general LLM: Embedding, reranking, extraction and generative models solve different stages and should be evaluated for their actual role. However, the described case — A low-cost support search uses short chunks but the proposed model multiplies embedding dimensions by eight. — is testing Embedding dimensions latency and index storage. It does not directly establish the verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.

Question 286 (Select TWO)

Choose TWO measures: one specific correction and one lasting safeguard. An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline.

  1. Treat index freshness as a monitored dependency of source-document correctness.
  2. Use `ai_query()` against a supported endpoint in a controlled batch-inference query with result checks.
  3. Compare storage-optimized versus standard options, supported limits and actual query latency before selection.
  4. Use budget limits and retry semantics when applying per-row model calls to large tables.

Explanation

Correct Answers

B:

Correct (immediate corrective action). Use `ai_query()` against a supported endpoint in a controlled batch-inference query with result checks. In this scenario, An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. The governing mechanism is: `ai_query()` invokes an available serving endpoint from SQL; suitability depends on supported runtimes, endpoint and workload. One selected option addresses the immediate workflow, while the other guards the same failure mode after deployment. Both satisfy the TWO-part requirement.

D:

Correct (continuing risk control). Use budget limits and retry semantics when applying per-row model calls to large tables. In this scenario, An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. The governing mechanism is: `ai_query()` invokes an available serving endpoint from SQL; suitability depends on supported runtimes, endpoint and workload. One selected option addresses the immediate workflow, while the other guards the same failure mode after deployment. Both satisfy the TWO-part requirement.

Incorrect Answers

A:

Not the strongest safeguard choice for this specific question. Treat index freshness as a monitored dependency of source-document correctness. This action primarily relates to Databricks Vector Search index from governed Delta data: A vector index serves embeddings of chunked records maintained in a Unity Catalog governed Delta source table. However, the described case — An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. — is testing SQL ai_query for governed batch inference. It does not directly establish the safeguard outcome or constraint that the question requires; it may still be useful in a different stage or incident.

C:

Not the strongest safeguard choice for this specific question. Compare storage-optimized versus standard options, supported limits and actual query latency before selection. This action primarily relates to Standard versus storage-optimized Vector Search index: Index choice trades capacity, update speed, latency and storage economics; availability and feature support may vary by cloud/region. However, the described case — An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. — is testing SQL ai_query for governed batch inference. It does not directly establish the safeguard outcome or constraint that the question requires; it may still be useful in a different stage or incident.

Question 287

A Databricks engineer is correcting the following workflow: A support search returns five unrelated policy pages while the correct refund clause is at rank 20. Which change best addresses the documented requirement?

  1. Build a relevance-labeled query set and measure recall@k and rank quality on actual returned chunks.
  2. Parse and chunk documents, write keyed chunk rows with provenance to a governed Delta table, then index them.
  3. Split by clause and heading boundaries with a token-aware fallback to preserve the rule and exception together.
  4. Index child sections with links to parent passages and expand context after child retrieval.

Explanation

Correct Answer

A:

Correct. Measure hit recall, precision, MRR or nDCG on labeled query-to-relevant-chunk pairs before tuning retrieval. In the given situation — A support search returns five unrelated policy pages while the correct refund clause is at rank 20. — the targeted implement action is: Build a relevance-labeled query set and measure recall@k and rank quality on actual returned chunks. This directly meets the stated workflow constraint instead of addressing an adjacent capability.

Incorrect Answers

B:

Not the strongest implement choice for this specific question. Parse and chunk documents, write keyed chunk rows with provenance to a governed Delta table, then index them. This action primarily relates to Delta and Unity Catalog pipeline for chunk tables: A governed retrieval corpus stores chunk text, IDs, source lineage and metadata in managed Delta/Unity Catalog tables before indexing. However, the described case — A support search returns five unrelated policy pages while the correct refund clause is at rank 20. — is testing Retrieval recall precision and ranking diagnostics. It does not directly establish the implement outcome or constraint that the question requires; it may still be useful in a different stage or incident.

C:

Not the strongest implement choice for this specific question. Split by clause and heading boundaries with a token-aware fallback to preserve the rule and exception together. This action primarily relates to Semantic boundaries versus fixed-window chunks: Headings, paragraphs and tables can require structure-aware splitting rather than arbitrary token windows. However, the described case — A support search returns five unrelated policy pages while the correct refund clause is at rank 20. — is testing Retrieval recall precision and ranking diagnostics. It does not directly establish the implement outcome or constraint that the question requires; it may still be useful in a different stage or incident.

D:

Not the strongest implement choice for this specific question. Index child sections with links to parent passages and expand context after child retrieval. This action primarily relates to Parent-child retrieval and hierarchical structure: Parent-child retrieval indexes targeted sections but expands to their broader parent context for generation. However, the described case — A support search returns five unrelated policy pages while the correct refund clause is at rank 20. — is testing Retrieval recall precision and ranking diagnostics. It does not directly establish the implement outcome or constraint that the question requires; it may still be useful in a different stage or incident.

Question 288

A deployment approval is requested for this case: A troubleshooting assistant retrieves a part number but omits the note that the part is discontinued. Which acceptance test should reviewers require?

  1. A/B test chunk segmentation on frozen questions and verify evidence sufficiency and prompt-budget compliance.
  2. Test mismatched user and account values and confirm zero unauthorized retrieval and correct contextual answers.
  3. Use the same quality rubrics for pre-release gates and production monitoring with separate datasets.
  4. Rerun a controlled experiment and confirm metrics match within expected stochastic tolerance.

Explanation

Correct Answer

A:

Correct. Retrieval failure can arise from overly small chunks that omit needed context or overly large chunks that dilute relevance. In the given situation — A troubleshooting assistant retrieves a part number but omits the note that the part is discontinued. — the targeted verify action is: A/B test chunk segmentation on frozen questions and verify evidence sufficiency and prompt-budget compliance. It tests an observable outcome using realistic inputs rather than relying on a working demo alone.

Incorrect Answers

B:

Not the strongest verify choice for this specific question. Test mismatched user and account values and confirm zero unauthorized retrieval and correct contextual answers. This action primarily relates to Query-field driven prompt and retrieval filters: User intent and structured fields such as account_id should drive authorized SQL lookups or retrieval filters, not be ignored in free text. However, the described case — A troubleshooting assistant retrieves a part number but omits the note that the part is discontinued. — is testing Chunk quality evaluation and boundary splitting. It does not directly establish the verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.

C:

Not the strongest verify choice for this specific question. Use the same quality rubrics for pre-release gates and production monitoring with separate datasets. This action primarily relates to Offline evaluation versus ongoing production monitoring: Offline test datasets catch regressions pre-release; production monitoring detects drift, real-user failures and evolving prompts. However, the described case — A troubleshooting assistant retrieves a part number but omits the note that the part is discontinued. — is testing Chunk quality evaluation and boundary splitting. It does not directly establish the verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.

D:

Not the strongest verify choice for this specific question. Rerun a controlled experiment and confirm metrics match within expected stochastic tolerance. This action primarily relates to Experiment tracking and version reproducibility: MLflow experiments should retain prompt, model, dataset, parameters and evaluation outputs to support a defensible comparison. However, the described case — A troubleshooting assistant retrieves a part number but omits the note that the part is discontinued. — is testing Chunk quality evaluation and boundary splitting. It does not directly establish the verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.

Question 289

Which measured result would verify that the pipeline is now fit for its purpose? A policy assistant begins making incorrect claims after the source index updates, but no live records show which index answered.

  1. Benchmark per-answer cost and quality on representative traffic before promoting optimizations.
  2. Query sampled live traces and demonstrate a complaint can be reproduced and scored on an offline test.
  3. Re-evaluate previously disputed cases and confirm inter-rater agreement improves after calibration.
  4. Run paired experiments with consistent evaluation data and evaluate cost-quality Pareto tradeoffs.

Explanation

Correct Answer

B:

Correct. Inference tables and agent monitoring capture production request/response signals and traces for quality investigations. In the given situation — A policy assistant begins making incorrect claims after the source index updates, but no live records show which index answered. — the targeted verify action is: Query sampled live traces and demonstrate a complaint can be reproduced and scored on an offline test. It tests an observable outcome using realistic inputs rather than relying on a working demo alone.

Incorrect Answers

A:

Not the strongest verify choice for this specific question. Benchmark per-answer cost and quality on representative traffic before promoting optimizations. This action primarily relates to Databricks usage and token cost controls: Reduce LLM spend through token budgets, caching, smaller appropriate models and AI Gateway quotas while preserving acceptance quality. However, the described case — A policy assistant begins making incorrect claims after the source index updates, but no live records show which index answered. — is testing Inference tables and Agent Monitoring feedback loop. It does not directly establish the verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.

C:

Not the strongest verify choice for this specific question. Re-evaluate previously disputed cases and confirm inter-rater agreement improves after calibration. This action primarily relates to Human SME feedback rubric and reviewer calibration: Domain experts should use a shared rubric, calibrate disagreements and maintain adjudicated examples to improve model evaluation. However, the described case — A policy assistant begins making incorrect claims after the source index updates, but no live records show which index answered. — is testing Inference tables and Agent Monitoring feedback loop. It does not directly establish the verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.

D:

Not the strongest verify choice for this specific question. Run paired experiments with consistent evaluation data and evaluate cost-quality Pareto tradeoffs. This action primarily relates to Model selection from quantitative task metrics: Select candidate LLMs by measured task success, latency, safety and token cost, not parameter count or leaderboard rank. However, the described case — A policy assistant begins making incorrect claims after the source index updates, but no live records show which index answered. — is testing Inference tables and Agent Monitoring feedback loop. It does not directly establish the verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.

Question 290

The Generative AI team observes: An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. Which implementation decision is MOST appropriate?

  1. Restrict endpoint CAN QUERY access to approved principals and test permission boundaries.
  2. Use an available Foundation Model API endpoint with compatible authentication, task API and quotas.
  3. Combine semantic index search with model/tenant metadata filters and select source chunks for grounding.
  4. Use `ai_query()` against a supported endpoint in a controlled batch-inference query with result checks.

Explanation

Correct Answer

D:

Correct. `ai_query()` invokes an available serving endpoint from SQL; suitability depends on supported runtimes, endpoint and workload. In the given situation — An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. — the targeted implement action is: Use `ai_query()` against a supported endpoint in a controlled batch-inference query with result checks. This directly meets the stated workflow constraint instead of addressing an adjacent capability.

Incorrect Answers

A:

Not the strongest implement choice for this specific question. Restrict endpoint CAN QUERY access to approved principals and test permission boundaries. This action primarily relates to Model Serving endpoint permissions and caller identity: Access to a serving endpoint is governed by workspace rights and identity; caller authorization is distinct from data-source permissions. However, the described case — An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. — is testing SQL ai_query for governed batch inference. It does not directly establish the implement outcome or constraint that the question requires; it may still be useful in a different stage or incident.

B:

Not the strongest implement choice for this specific question. Use an available Foundation Model API endpoint with compatible authentication, task API and quotas. This action primarily relates to Foundation Model API versus custom serving choices: Databricks Foundation Model APIs offer managed access to supported models; custom serving is suitable for specialized models or control needs. However, the described case — An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. — is testing SQL ai_query for governed batch inference. It does not directly establish the implement outcome or constraint that the question requires; it may still be useful in a different stage or incident.

C:

Not the strongest implement choice for this specific question. Combine semantic index search with model/tenant metadata filters and select source chunks for grounding. This action primarily relates to Vector Search retrieval workflow and query integration: Semantic retrieval uses an embedding model to query a compatible index, returns ranked passages and metadata for grounded generation. However, the described case — An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. — is testing SQL ai_query for governed batch inference. It does not directly establish the implement outcome or constraint that the question requires; it may still be useful in a different stage or incident.