D8LooP - Practise Data Engineering

Preparing your workspaceloading the brief, studio & canvas…

buyersellerlistingorder

SCENARIO

You model the case system for LoopTrust’s risk & compliance team. An auditor must reconstruct exactly who did what, when, and under which policy — so the trail is append-only and four-eyes applies: whoever submits a case cannot be the one who approves it.

your ERD must answer

01The full, immutable audit trail of who did what to a case, and when.
02That every approval was made by someone other than the submitter.
03Which policy or control each case decision was made under.

out of scopeID-verification vendors · sanctions data · scoring · report formats

This exercise’s brief could not be loaded.The guided questions and their model answers come from the review service. It looks like it is not reachable — start it with pnpm dev:api and reload.The canvas below still works, so you can model now and run the review once the service is up.

Build starts here

The brief becomes the left drawer. The canvas stays the build surface.Study is done above. Build the tables here, hit review to validate, then use follow-ups to defend the model.

Practice studio

Ctrl/Cmd + C copyCtrl/Cmd + V pasteCtrl/Cmd + Z undoDelete remove

68%

You built the model in the Studio. Now defend it.Risk and compliance audit

Design review

The reviewer reads your model.

Preparing your workspaceloading the brief, studio & canvas…

buyersellerlistingorder

SCENARIO

your ERD must answer

01The full, immutable audit trail of who did what to a case, and when.
02That every approval was made by someone other than the submitter.
03Which policy or control each case decision was made under.

out of scopeID-verification vendors · sanctions data · scoring · report formats

Build starts here

The brief becomes the left drawer. The canvas stays the build surface.Study is done above. Build the tables here, hit review to validate, then use follow-ups to defend the model.

Practice studio

Ctrl/Cmd + C copyCtrl/Cmd + V pasteCtrl/Cmd + Z undoDelete remove

68%

You built the model in the Studio. Now defend it.Risk and compliance audit

Design review