Sprint 02 — Diagnostic Answer Key
1 — B. Data Owner
Final business-domain accountability and escalated business decision authority are the Owner clues. A Business Steward may develop definitions/rules, while technical and analytical roles support execution/analysis.
Source: Owner vs Steward roles.
2 — D. Physical Data Model
DBMS/technology-specific tables, columns, datatypes, indexes and physical implementation detail identify the PDM. The LDM remains technology-independent; a metamodel models Metadata objects.
Source: Chapter 5 modeling distinctions.
3 — A. Data Dictionary
Datatype/nullability/length/uniqueness are structural element properties. Glossary = business meaning; catalog = discovery/location; lineage = origin/movement/transformation/use.
Source: Glossary vs Dictionary vs Catalog.
4 — C. Monitoring
Recurring trending and threshold alerts over time are monitoring. Profiling is a technique for inspecting patterns; initial assessment establishes baseline; remediation changes causes.
Source: Profiling vs Assessment vs Monitoring.
5 — B. Reference Data Management
The problem is permissible/classifying country-code values and mappings, not persistent Customer/Product identity.
Source: Reference vs Master.
6 — D. Staging
Transient intermediate preparation before downstream load is Staging. ODS retains integrated current/near-current data; DW preserves durable analytical history; Mart is a targeted analytical slice.
Source: Staging vs ODS vs DW vs Mart.
7 — A. Database Operations Support
Backup/recovery/restore and keeping the operating data service reliable are Operations Support. Technology Support focuses more on selecting/installing/configuring/maintaining the DB/storage technology itself.
Source: Chapter 6 Deep Card A.
8 — C. Vulnerability
The exploitable weakness is a vulnerability. A threat is a potential harmful actor/event; risk combines uncertainty/likelihood and impact relative to value; entitlement is access exposure.
Source: Chapter 7 Security Deep Cards.
9 — B. Orchestration
Order, dependencies, triggers, retry/recovery and sequencing are orchestration. Mapping defines source/value/structure-to-target relationships.
Source: Chapter 8 Deep Card F.
10 — D. Neutral Zone
The old state is no longer intact, the new state is not normal, and experimentation/mixed behavior is occurring—classic Neutral Zone.
Source: Chapter 17 Bridges lesson.
Sprint analysis
Record score, total time, >75-second items, lookups, answer changes and confidence.
Then classify any miss: - role/accountability; - model level; - Metadata artifact; - DQ lifecycle; - Reference/Master; - DW/BI architectural role; - Storage/Operations responsibility; - Security vocabulary; - Integration mapping/orchestration; - change-transition phase; - or ordinary misread/time pressure.
Only repeated real patterns should later feed personalized repair.