Data Quality Architecture: Threshold 245
Scenario
You are a data professional working with finance data. Prepare a reliable reusable result from payments for a review.
Question
Design a source-to-report path for payments. Keep records where amount is at least 245, store them in payments_trusted_1, and include an owner and an access rule.
Your task
- Inspect the provided data and column names
- Design a source-to-report path for payments. Keep records where amount is at least 245, store them in payments_trusted_1, and include an owner and an access rule.
- Run your code and compare the result
Advanced · Quality Gated Architecture & Serving Layers — question 3 of 30
1. Choose your dataset
Pick an industry and a size. Your code and results change to match.
Data Quality Architecture: Threshold 245
Design a source-to-report path for payments. Keep records where amount is at least 245, store them in payments_trusted_1, and include an owner and an access rule.
Your code cell is below. Press Check my answer to run the cell — the result appears as Out [1].
💡 Explain my whole code, line by line (hover any word in the editor for a tip)
🌈 In short — no coding words
Altogether: this script runs top to bottom, one line at a time, building up the answer step by step.
Dataset & schema
payments
The tiny starter data. Bigger data scrolls.
Fields
| payment_id | region | amount |
|---|---|---|
| P1 | North | 500 |
| P2 | South | 200 |
| P3 | North | 900 |
| P4 | East | 300 |
Finance practice data only.
$ Press “Check my answer” — results appear here.Your next steps
Each item turns green when your answer includes it.
- Names the source
- Defines the quality rule
- Names trusted storage
- Defines access
- Names governance