Secure 75% Off All Exam Bundles This Black Friday! Use coupon code below to save! - Ends in 0d 00h 00m 00s - Coupon code: 75only

Databricks Context-Engineer-Associate Databricks Certified Context Engineer Associate Exam Practice Test

Databricks Certified Context Engineer Associate Questions and Answers

Question 1

A context engineer manages a personalized travel planning agent deployed on Databricks. The agent uses Databricks Agent Memory backed by Lakebase to retain durable user preferences across independent conversations.

Memory entries are organized using actor_id, session_id, and path.

During an earlier conversation, User42 stated that they preferred economy-class flights. The application persisted this preference in the memory store using:

actor_id: User42

path: /preferences/flight-class.md

content: Prefers economy-class flights.

session_id: Unset

Three months later, User42 explicitly changes their preference to business-class flights for future travel. The agent must retain the updated preference across all subsequent sessions without creating competing entries that could cause contradictory recommendations.

The application must also ensure that User42 ' s preference does not affect memories belonging to other users.

Which memory-management operation should the context engineer configure?

Options:

A.

Append the new business-class preference as another memory entry under a unique path, retaining both preferences so semantic retrieval can select whichever entry is most relevant to future travel requests.

B.

Use memory_store.put() with the existing actor_id and memory path, leaving session_id unset, to replace the previously stored preference with the newly confirmed business-class preference.

C.

Create a new memory entry using the latest session identifier and the existing preference path, allowing the agent to retrieve the updated value through session-scoped memory search.

D.

Retain the original economy-class preference in the durable memory store and place the new business-class preference exclusively in the current conversation ' s short-term session context.

Question 2

A context engineer is debugging a long-running data pipeline orchestration agent that runs multi-step workflows using registered Databricks tools such as run_job, query_catalog, and validate_schema. After compaction occurs at turn 40, the agent starts re-invoking tools it successfully called earlier in the session and ignores results that downstream steps depend on. Inspection of the compacted context shows that the summarization prompt was instructed to retain only the final state of each pipeline stage. The current compaction prompt reads: “Summarize the current pipeline state in a few sentences and include only what is necessary.”

Which revision to the compaction prompt addresses the coherence failure while keeping token cost low?

Options:

A.

Replace “include only what is necessary” with: “Include the reasoning chain and internal thinking text produced before each tool invocation.”

B.

Replace “include only what is necessary” with: “Include a compact record of each tool called, its key arguments, and its returned result.”

C.

Append: “For each tool invocation, include the full input payload and every response field returned by the tool.”

D.

Append: “Retain the user ' s original task description and all clarifying questions asked during the session.”

Question 3

A context engineer is investigating a multi-agent pipeline on Databricks where a coordinating agent breaks down a document analysis task and dispatches subtasks to three specialized sub-agents. After deployment, the sub-agents produce outputs that are internally consistent but contradict one another and do not reflect earlier inferences made at the pipeline level. The sub-agents have access to the same retrieval index, the embedding model is verified as current, and individual sub-agent outputs are accurate when tested in isolation with full context supplied manually.

What is a reasonable root cause of the downstream failures?

Options:

A.

The coordinating agent’s temperature parameter is set too high, introducing non-determinism into the subtask decomposition and producing inconsistent dispatch instructions.

B.

Each sub-agent is dispatched with only its individual task message and lacks access to the coordinator’s earlier reasoning, tool outputs, and decisions.

C.

The retrieval index used by the sub-agents is misconfigured, so they are querying a different corpus than the coordinating agent, leading to contradictory but locally consistent outputs.

D.

The embedding model used for retrieval was not trained on the document domain, causing sub-agents to retrieve irrelevant chunks and produce contradictory summaries.

Question 4

A context engineer is preparing to deploy a per-tenant Databricks agent for a SaaS retail analytics platform. Each platform customer is provisioned with their own Unity Catalog catalog, retail_ & lt;customer & gt;, and within each tenant catalog, data is organized by business domain rather than by origin.

The sales schema contains the customer’s POS transaction and returns tables, which the customer’s source systems write to throughout the day, alongside the daily_sales_by_store, hourly_revenue_by_category, and top_skus_weekly summary tables that a nightly Lakeflow Jobs pipeline produces by reading those POS tables. The inventory schema contains stock-level and inbound-shipment tables written continuously by ingestion, alongside demand_forecast_7d and reorder_suggestions tables produced by the SaaS’s ML pipelines. The customer schema contains customer master records and contact tables, all populated by ingestion.

The SaaS deploys one agent per customer through Model Serving, and each agent has its own service principal. Before any agent endpoint is registered, the governance requirements are that an agent for a given customer must be able to retrieve data only from that customer’s catalog and never from another customer’s catalog, and that within its own customer’s catalog, the agent must be able to retrieve only from tables populated directly by the customer’s ingestion pipelines, never from nightly summaries, forecasts, or other tables produced by SaaS pipelines.

Which governance approach should the context engineer implement for each tenant’s agent before registration?

Options:

A.

Provision a single agent service principal shared across all tenants because per-tenant service principals are operationally heavy at the SaaS’s expected scale. Grant the shared service principal USE CATALOG on every retail_ < customer > catalog and table-level SELECT only on the ingestion-fed tables in each catalog. Configure the agent’s retrieval tool to inject the requesting customer’s catalog name into every query so the agent

B.

For each tenant’s agent service principal, grant USE CATALOG on that tenant’s retail_ < customer > catalog and USE SCHEMA together with SELECT on the sales, inventory, and customer schemas. Apply a Unity Catalog tag source=ingest to every ingestion-fed table across the tenant catalogs and configure each agent’s retrieval logic to issue queries only against tables carrying that tag.

C.

For each tenant’s agent service principal, grant USE CATALOG only on that tenant’s retail_ < customer > catalog and USE SCHEMA together with SELECT on the sales, inventory, and customer schemas, relying on the per-tenant catalog boundary to scope retrieval to the customer’s data.

D.

For each tenant’s agent service principal, grant USE CATALOG only on that tenant’s retail_ < customer > catalog and, within that catalog, grant USE SCHEMA on each domain schema together with table-level SELECT only on the tables populated by the customer’s ingestion pipelines. Leave the nightly summary, forecast, and other SaaS-produced tables in those schemas ungranted.

Question 5

A context engineer is examining MLflow experiment tracking results comparing two system prompt configurations for a Databricks agent designed to assist with contract review. Configuration P uses a role declaration, a full task instruction, and a dedicated edge-case handling section that explains in prose how the agent should respond to ambiguous or overlapping clause types, averaging 205 tokens per call and 81% clause-classification accuracy. Configuration Q retains the role declaration, removes the prose edge-case handling section, shortens the task instruction to a concise directive, and adds three few-shot examples, each showing how the agent should classify a distinct edge-case clause type, averaging 340 tokens per call and 93% clause-classification accuracy. The token budget increases by 135 tokens per call between Configuration P and Configuration Q. Latency rises from 290 ms to 380 ms.

Which conclusion is supported by these experiment tracking results?

Options:

A.

The token increase is justified by the 12-percentage-point accuracy gain, and the shortened task instruction is the specific prompt element driving the performance improvement.

B.

The token increase is justified by the 12-percentage-point accuracy gain, and the few-shot edge-case examples are the specific prompt element driving the performance improvement.

C.

The token increase is not justified because removing the prose edge-case handling section and replacing it with examples introduces ambiguity that accuracy gain does not sufficiently offset.

D.

The token increase is justified by the accuracy gain, but the improvement is attributable to the larger token budget because the removed edge-case handling section and added few-shot examples represent an equivalent token exchange.

Question 6

A context engineer is building a retail agent with Agent Bricks Custom Agents. The agent has two registered tools: a SQL query tool that queries a live inventory database, and a vector search tool that searches a static product catalog vector index for product descriptions, specifications, and categories. Both tools are configured correctly, function properly, and return valid results when called.

At runtime, when users ask questions such as “Is this item in stock?”, the agent consistently calls the product catalog tool and provides a plausible availability answer without checking the live inventory database. The product catalog tool is not intended to answer live stock availability questions.

Which context engineering issue explains this behavior?

Options:

A.

The product catalog vector index was built from a periodic snapshot, so it may contain stale product metadata.

B.

The tool descriptions and routing guidance are too ambiguous to distinguish live inventory availability questions from static product catalog search.

C.

The inventory tool’s description does not explicitly mention “stock,” “in stock,” or “availability,” even though it correctly queries real-time inventory when called.

D.

The agent prompt does not require source-of-truth checks before generating a final answer, so the agent treats any plausible retrieved context as sufficient.

Question 7

A context engineer is investigating why a Genie space serving the sales operations team gives inconsistent answers to revenue questions. When business users ask the same QUESTION NO: across different sessions, for example, “What was Q3 EMEA revenue?”, Genie returns different figures. The space is configured over a Unity Catalog managed table of transaction-level data.

On reviewing the space, the engineer finds:

The underlying table has comprehensive table and column comments.

The space’s text instructions describe how revenue should be computed, including currency conversion against a daily FX-rate table, accrual-timing rules, and intercompany-elimination logic.

The space includes several sample questions covering quarterly and regional revenue patterns.

In the query history, Genie composes a new SQL statement for the revenue calculation in each session, and the FX-conversion and elimination steps differ from run to run.

Which change will most reliably stabilize the space’s answers to this team’s revenue questions?

Options:

A.

Encapsulate the canonical revenue calculation in a parameterized Unity Catalog SQL function and register it in the space as a trusted asset.

B.

Add a complete example SQL query that performs the full revenue calculation to the space so Genie can learn the pattern.

C.

Expand the text instructions with step-by-step pseudocode for the revenue calculation, giving Genie a more explicit procedure to follow when generating SQL.

D.

Define a SQL expression for revenue in the space’s knowledge store so Genie has a reusable definition of the metric.

Question 8

A context engineer is building a regulatory compliance agent on Databricks that connects to an external compliance management platform through an MCP Service registered in Unity Catalog.

The MCP server exposes the following tools:

search_compliance_records: Retrieves existing compliance records without modifying them.

get_submission_status: Checks the status of previously submitted reports.

submit_regulatory_report: Sends a finalized regulatory report to an external authority.

delete_compliance_record: Permanently deletes an existing compliance record.

The agent serves compliance officers who are authorized to retrieve records and submit reports. However, organizational policy requires explicit human approval before every regulatory report submission.

The agent must continue executing read-only tools without interruption. It must also prevent unauthorized destructive operations and maintain an auditable record of tool invocations.

The engineering team has confirmed that the MCP tools function correctly. The remaining requirement is to enforce the approval and authorization rules at the platform governance layer rather than relying exclusively on instructions inside the agent ' s system prompt.

Which approach should the context engineer implement?

Options:

A.

Add instructions to the system prompt requiring the agent to ask the user for confirmation before invoking submit_regulatory_report, and instruct the agent never to invoke delete_compliance_record.

B.

Increase the model ' s reasoning effort so the agent evaluates the consequences of each MCP invocation before deciding whether user approval is necessary.

C.

Configure the MCP Service with appropriate Unity Catalog permissions and tool restrictions, and attach an input-phase service policy that requires approval for submit_regulatory_report while allowing authorized read-only calls.

D.

Remove all tools capable of modifying external systems from the MCP server and require compliance officers to submit regulatory reports through an independent manual process.

Question 9

An AI engineer is developing a multimodal agent for a media company’s archive team. The archive contains thousands of titles spanning two decades (full episodes, raw interviews, and unedited B-roll), ingested as monolithic files. Producers use the agent to answer visual content questions about archival footage, such as whether a specific asset contains a usable exterior shot of a landmark. When a producer asks this type of question, the agent’s retrieval tool loads the full asset into context so the model can examine it, even though only a small portion of the asset is relevant. After a few such retrievals, the context window fills. The engineer needs to reduce context pressure through proactive design changes rather than relying on compaction.

Which proactive context management strategy should the engineer use to address this problem?

Options:

A.

Route each retrieved asset through a summarization step using a vision language model to produce a brief visual digest, passing only that digest into the agent’s context window.

B.

Add explicit instructions to the agent’s system prompt directing it to retrieve only the smallest necessary portion of each asset, so the model proactively limits what it loads.

C.

Configure the agent to invoke a text-only search of the catalog metadata before retrieving any footage, so it can answer from the catalog when possible without loading media.

D.

Preprocess each archival asset into a scene-level metadata layer so the agent can identify the relevant segment from the metadata and retrieve only that portion for examination.

Question 10

A context engineer is evaluating a Databricks customer support agent that handles complex multi-turn conversations involving subscription changes, billing adjustments, and service cancellation requests.

The agent uses Lakebase-backed session storage to maintain conversation history. MLflow 3 tracing is enabled, and each inference trace includes a session identifier.

During testing, the engineer observes the following behavior:

Turn 1: The customer requests cancellation of an existing subscription.

Turn 2: The agent correctly identifies the subscription and explains the cancellation procedure.

Turn 4: The customer specifies that cancellation must occur at the end of the current billing cycle.

Turn 6: The agent retrieves the relevant cancellation policy and correctly answers a billing question.

Turn 8: The agent generates a final confirmation stating that the subscription will be canceled immediately, overlooking the customer ' s earlier instruction to cancel at the end of the billing cycle.

Individual response evaluations show high correctness and relevance scores. However, the operations team suspects that the agent is failing to preserve important information across conversational turns.

The engineer needs an evaluation mechanism that detects failures involving information introduced earlier in a conversation, rather than scoring each response independently.

Which MLflow evaluation approach should the context engineer implement?

Options:

A.

Run the built-in Correctness scorer independently on each response trace, increasing the number of test questions to improve statistical confidence in the results.

B.

Evaluate only the final response against the latest retrieved policy document, since the agent ' s correctness should depend primarily on the most recent authoritative source.

C.

Increase the number of MLflow traces collected per conversation and compare average token usage, tool-call count, and latency between successful and unsuccessful sessions.

D.

Group traces by their conversation session identifiers and run MLflow ' s multi-turn KnowledgeRetention judge to evaluate whether information introduced in earlier turns is correctly maintained throughout the conversation.

Question 11

A context engineer is building an AI application that tracks every prompt sent to a large language model, the retrieved context chunks passed to it, and the final generated response. The application must capture token usage, latency metrics, and user feedback scores associated with each inference run. The engineer needs a unified system that versions prompt templates alongside model artifacts, links evaluation results to specific runs, and provides a query interface so downstream dashboards can compare performance across experiment iterations, all without building a custom logging backend.

Which Databricks product should the context engineer use to meet these requirements?

Options:

A.

Unity Catalog, to register prompt templates as catalog assets, enforce access policies on inference logs, and track lineage between input datasets and model outputs.

B.

Lakebase, to store inference run records in a transactional database, version prompt templates as rows, and query latency metrics through a relational interface.

C.

MLflow 3, to log full inference traces, version prompt templates as registered model artifacts, and query evaluation results across experiment runs without a custom logging backend.

D.

MCP, to expose the LLM inference endpoint and prompt templates as a standardized tool schema that agent frameworks can discover and invoke at runtime.

Question 12

A context engineer is troubleshooting a Databricks agent responsible for a multi-month clinical trial data processing pipeline. The agent uses a fixed sequential chaining strategy, running each processing stage in a predetermined order regardless of which stages have already completed successfully. When upstream data sources are delayed or partially available, the agent restarts the entire chain from the beginning, discarding all previously completed stage outputs. Logs show that stages with no dependency on the delayed source are being blocked unnecessarily, and total pipeline runtime has grown to an unacceptable length because of repeated full restarts on partial failures.

Which two changes should the context engineer make to resolve the observed failure pattern?

Choose two

Options:

A.

Replace the fixed sequential chain with a dependency-graph-aware strategy that allows independent stages to execute without waiting for unrelated delayed stages.

B.

Increase the agent’s retry limit and timeout thresholds so the sequential chain has more time to wait for delayed upstream data before failing.

C.

Replace the agent’s task planner with a reactive event-driven model that triggers each stage only when a new data file lands in the source directory.

D.

Switch to a parallel decomposition strategy so all stages execute simultaneously, eliminating the sequential bottleneck caused by delayed upstream sources.

E.

Introduce checkpointing so that successfully completed stages are persisted and the agent resumes from the last valid checkpoint rather than restarting the full chain.

Question 13

A context engineer is developing a Databricks agent that autonomously manages a multi-day incident response workflow. The agent processes a continuous stream of structured log entries, tool call results, and short status updates. Recent messages tend to guide decisions, while earlier messages are often superseded by newer updates during the workflow. The engineer is considering whether to implement a hard-coded sliding-window trimming heuristic that drops messages older than a fixed turn count, or to invest in a semantic compaction approach that summarizes and condenses prior context before dropping it.

Which characteristic of this agent’s information relevance pattern justifies using the hard-coded sliding-window trimming heuristic instead of a semantic compaction approach?

Options:

A.

The agent receives frequent short status updates that individually appear low-value, but collectively encode a progression of state changes that a fixed trim threshold would maintain.

B.

The agent accumulates long-range dependencies across turns, in a way that semantic compaction would lose the granularity of faster than a fixed trim.

C.

Message relevance declines in a consistent and predictable way over time, allowing a fixed-size window to retain the necessary context without additional processing.

D.

Hard-coded trimming heuristics are typically used when managing context size constraints, independent of specific relevance patterns for one particular use case.

Question 14

A context engineer is assessing a Databricks agent that coordinates a multi-week pharmaceutical supply chain compliance workflow across dozens of distribution centers. The agent uses a flat task decomposition strategy, dividing the entire workflow into a single-level list of atomic tasks that are dispatched and tracked independently. The workflow contains clusters of tightly coupled sub-tasks, such as per-facility inspection records that must all complete before a regional compliance certificate can be issued, and the agent repeatedly fails to coordinate these cluster-level completions correctly. Logs show that the agent loses track of intermediate group states, issues compliance certificates prematurely on incomplete facility data, and cannot recover gracefully when individual facility inspection tasks fail.

Which two changes should the context engineer make to resolve the observed failure?

Choose two

Options:

A.

Switch to a parallel decomposition strategy that executes all facility inspection and certificate tasks simultaneously, relying on eventual consistency to merge partial results into the final compliance record.

B.

Add a retry loop at the top-level agent that restarts the entire flat task list from the beginning whenever any single facility inspection task fails, ensuring no partial state persists across runs.

C.

Replace the flat task decomposition with a hierarchical decomposition strategy that groups related facility inspection sub-tasks under a parent node, enabling group-level completion tracking before dependent tasks proceed.

D.

Introduce explicit dependency gates at each cluster boundary so the compliance certificate task is dispatched only after all facility inspection tasks in the group have reached a confirmed completed state.

E.

Replace the workflow with a fixed sequential chaining strategy that executes every facility inspection one at a time before issuing any certificate, eliminating all concurrency from the pipeline.

Question 15

A context engineer manages a Genie space for a finance team. Users repeatedly ask the same shape of QUESTION NO: with different fiscal periods: “What is the total open pipeline by region for FY26 Q1?”, “...for FY26 Q2?” “...for the last quarter?”. The SQL pattern Genie generates is identical across these questions (same JOIN, GROUP BY, and aggregation, with only the fiscal-period filter changing), and the team requires that responses to these recurring questions be labeled Trusted in the chat UI. The engineer must register an asset that reuses the same vetted SQL pattern with the user-supplied fiscal period.

Which curation choice should the engineer make?

Options:

A.

A parameterized example SQL query with a typed (Date or String) fiscal-period parameter, so Genie can reuse the SQL pattern with the user-supplied value each time the QUESTION NO: is asked.

B.

A Unity Catalog SQL function that defines open_pipeline as a reusable measure, with Genie composing the surrounding per-period and per-region SQL around the function call each turn.

C.

A general instructions text block that describes the desired SELECT, JOIN, WHERE, and GROUP BY structure so Genie can regenerate the SQL on every turn from that description.

D.

Multiple static example SQL queries (one for each commonly asked fiscal period: FY26 Q1, FY26 Q2, last quarter), so Genie matches each user QUESTION NO: to its corresponding vetted example.