System DesignBeginnerReady

Data and Storage Foundations Assessment

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

Question 1scenarioBeginner

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.

Question 2scenarioBeginner

16 pts

SQL vs NoSQL storage decision

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.

Question 3scenarioBeginner

18 pts

Index and query pattern design

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.

Question 4scenarioBeginner

18 pts

Transactions and consistency basics

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.

Question 5multiple-choiceBeginner

10 pts

Storage decision communication

Which answer is strongest when choosing between SQL and NoSQL?