Explains data products in a warehouse
Marts and semantic models as products with processes, consumers, owner and SLA, each answering its questions once (DMBOK2 ch. 11).
Can AI do this?
AI does this well Most of the tested AI models master this. 3 of 4 models in the current benchmark master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 98% | Mastered |
| gemini-3.5-flash-lite | Low cost | 28% | Not shown |
| gpt-6-luna | Low cost | 99% | Mastered |
| claude-haiku-5-5 | Low cost | 97% | Mastered |
Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.
What it looks like in practice
Expected result: Marts and semantic models as products with processes, consumers, owner and SLA, each answering its questions once (DMBOK2 ch. 11).
How it is assessed: Answers a written question on the warehouse data products correctly
Related knobits
Needed for
- W-305 Recognises a data product with no owner or consumer
- W-306 Recognises two data products answering one question differently
All 14 knobits of Design the bus matrix and data products.
Source: Practice the stage 3 reference and review checklist rest on