18 pts
Data modeling from product flows
Model a course progress system for SkillSkore. Include core entities, owner/source of truth, important read models, and one correctness rule around assessment attempts or certificates.
This assessment verifies the Data and Storage Foundations module. Passing it contributes up to 9 points in the 18-26 score band.
Questions
5
Limit
70m
Pass
85%
Score
+9
18 pts
Model a course progress system for SkillSkore. Include core entities, owner/source of truth, important read models, and one correctness rule around assessment attempts or certificates.
16 pts
A user profile system needs get profile by userId, update profile, list public creators by category, enforce ownership permissions, and support creator discovery search. Choose a starting storage strategy and justify any derived stores.
18 pts
A support ticket system must get ticket by ID, list open tickets by team sorted by priority and createdAt, list a requester's ticket history, search ticket text, and show dashboard counts. Propose access paths and trade-offs.
18 pts
Design consistency for a ticket booking system. Identify three data elements that require strong correctness, two that can be eventually consistent, and one pattern that prevents duplicate processing.
10 pts
Which answer is strongest when choosing between SQL and NoSQL?