Module 13 Knowledge Check
5 questions. Pass mark 4 out of 5. Answer every question before checking the answer key below, then retry after reading the feedback.
1. A complete evidence memo must state the limitation because…
- A. It fills space
- B. A reader cannot judge the number's fitness for their decision without knowing what it excludes
- C. It is required by SQL
- D. It improves performance
2. Which belongs in the memo's Source line?
- A. The chart colour
- B. Tables, filters, date range, and status rules used
- C. The analyst's opinion
- D. The runtime
3. Recording the grain in the memo matters because…
- A. It is traditional
- B. It tells the reader what one row - and therefore the count - actually represents
- C. It speeds the query
- D. It is optional
4. Your capstone dataset will feed an AI assistant. What extra step is required?
- A. None
- B. Confirm permissions, provenance, and freshness fields are present and correct
- C. Rename the columns
- D. Sort by id
5. Reconciling your final figure against a second independent source is worthwhile because…
- A. It doubles the work for no gain
- B. Agreement raises confidence and disagreement reveals a real assumption difference
- C. It is required by law
- D. It speeds up review
---
Answer Key and Explanations
Check these only after attempting every question.
1. B - A reader cannot judge the number's fitness for their decision without knowing what it excludes
The limitation line is the one reviewers value most and authors most often skip.
2. B - Tables, filters, date range, and status rules used
Someone must be able to reconstruct the exact population you measured.
3. B - It tells the reader what one row - and therefore the count - actually represents
Most disputed numbers turn out to be grain disagreements, not arithmetic errors.
4. B - Confirm permissions, provenance, and freshness fields are present and correct
Data that will be quoted back to users needs access control and traceability, not just accuracy.
5. B - Agreement raises confidence and disagreement reveals a real assumption difference
Two methods agreeing is far stronger evidence than one method repeated.
Practical Check
Apply this module to your own work: complete the module activity for *Capstone: Analysis-Ready Dataset and SQL Evidence Memo*, then write one sentence naming what your result shows and one naming what it does not.
Strong Answer Pattern
A strong answer names the task, the evidence used, the check performed, and the remaining limitation. It avoids "proved", "guaranteed", or "always" unless the evidence genuinely supports it.