Home › Certifications › Databricks Generative AI Engineer › Data Preparation and Retrieval Quality
40 multiple-choice questions and 15 flashcards on Data Preparation and Retrieval Quality, about 13% of the Databricks Generative AI Engineer bank. Every one carries a written rationale.
Data Preparation and Retrieval Quality is one of 8 chapters in CoStudy's Databricks Generative AI Engineer bank, and it holds 40 of the bank's 300 multiple-choice questions — roughly 13% of the total. That proportion is not arbitrary: chapters follow the certifying body's published exam outline, and the number of questions in each is set by that domain's published weight, so the share of your practice time this chapter takes matches the share of the real exam it accounts for.
Studying by chapter is worth doing once you have a diagnostic score. A single overall percentage tells you whether you are close; it does not tell you which domain is dragging. Working a weak chapter in isolation, and re-testing it in isolation, is the fastest way to move a score that has stalled — and it is why the mock exams in CoStudy report by domain rather than as one number.
5 questions drawn from this chapter, with the full rationale shown — the controlling principle behind the right answer, and why each wrong option tempts and fails.
A team reports recall at k=5 of 0.62 and precision at k=5 of 0.55. Which interpretation is MOST defensible?
Answer: B — About a third of questions never see the right passage
B) Correct — recall of 0.62 means the supporting passage is absent for about 38 percent of questions, and no generator can answer those correctly, so retrieval is the binding constraint. A) With recall that low the generator is being blamed for missing evidence it never received. C) Set size is a fair general concern but nothing in the numbers indicates it, and the recall gap is large enough to act on. D) The relationship between precision and recall values does not by itself imply a top-k setting; raising k usually raises recall and lowers precision.
A team evaluates retrieval and finds recall at k=10 is 0.94 but the generator still answers poorly. Adding which stage is MOST likely to close the gap?
Answer: A — A cross-encoder re-ranker over the top candidates, passing the best few onward
A) Correct — high recall with poor answers is the signature of a precision problem: the right chunk is present but buried, and a re-ranker reorders candidates so the strongest evidence leads. B) Recall is already near ceiling, so spending on a bigger embedder targets the metric that is not the bottleneck. C) Raising top-k adds more distracting context and typically worsens an ordering problem. D) Summarizing all ten chunks propagates the noise into the summary and can drop the specific detail the answer needs.
For chunking, what does overlap solve?
Answer: D — It preserves context across chunk boundaries
D) Correct — repeating tokens at the seam keeps an entity mentioned near a split retrievable from either neighboring chunk. A) Overlap increases the token count. B) It increases stored data. C) Embedding more text is marginally slower.
What is the impact of duplicate documents in the corpus on RAG quality?
Answer: D — Near-identical chunks crowd out top-K, biasing context and raising cost
D) Correct - duplicates occupy multiple top-K slots, so the context repeats itself and genuinely different evidence is pushed out; deduplicate at ingestion. A) More copies of one fact inflate its apparent support rather than improving coverage. B) Duplicates are embedded repeatedly, so cost goes up. C) The index stores what you write; it does not silently collapse duplicates.
Optimal RAG chunk size range is typically:
Answer: C — 200-1,000 tokens with a small overlap window
C) Correct — this range balances retrieval precision against enough surrounding context, and modest overlap preserves continuity at boundaries. A) Too small to carry meaning. B) Too large, so retrieval returns mostly irrelevant text. D) Single sentences strip the context the model needs.
4 cards from the 15 in this chapter.
What is the purpose of chunk overlap, and what is the cost of setting it too high?
Overlap repeats tokens at chunk boundaries so an idea split across a boundary still appears whole in at least one chunk. Too much overlap inflates index size, embedding cost and duplicate retrieval hits, which crowds out diverse context.
Common RAG failure modes?
Poor retrieval (wrong docs), too few/many chunks, conflicting sources, model ignoring context, hallucination, latency overruns.
Retrieved chunks are individually relevant but the model answers without needed surrounding context. What chunking technique addresses this?
Parent-document or context-enrichment retrieval: embed small precise child chunks for matching, but return the larger parent section to the LLM. This keeps retrieval precision while restoring the context the answer needs.
Why chunk documents?
Foundation models have limited context windows; small focused chunks improve retrieval relevance + reduce hallucination.
These are a sample. The full Data Preparation and Retrieval Quality chapter runs 55 items with per-chapter progress tracking, on the web and in the iOS app.
Open Databricks Generative AI Engineer in CoStudy →