Data Quality Architecture: Threshold 36

Scenario

You are a data professional working with energy data. Prepare a reliable result from power_readings for a review.

Question

Design a source-to-report path for power_readings. Keep records where megawatts is at least 36, store them in power_readings_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 power_readings. Keep records where megawatts is at least 36, store them in power_readings_trusted_1, and include an owner and an access rule.
Run your code and compare the result

Quality-Gated ArchitectureData Architecture

Read the simple theory: Sources

Beginner · Quality Gated Architecture & Columns — question 3 of 30

Finish all 30 to earn a certificate

1. Choose your dataset

Pick an industry and a size. Your code and results change to match.

IndustrySize

📓 DataPro notebookextension-data-architecture-energy-beginner-data-architecture__energy__Beginner-1.ipynbFileEditViewRunKernel: Python 3

[md]

Data Quality Architecture: Threshold 36

Design a source-to-report path for power_readings. Keep records where megawatts is at least 36, store them in power_readings_trusted_1, and include an owner and an access rule.

In [1]:

Your code cell is below. Press Check my answer to run the cell — the result appears as Out [1].

python editorpower_readings

Snippets

💡 Explain my whole code, line by line (hover any word in the editor for a tip)

🌈 In short — no coding words

📂 Opens the "power_readings" table→✅ Shows you the answer

Altogether: this script runs top to bottom, one line at a time, building up the answer step by step.

Start typing to see suggestions. Press Enter to use one. Red marks show the line to fix. Drag a bottom corner horizontally and vertically to resize.

Type your code here ↓Tap or click inside the box to start

✍️ Tap here to type

Dataset & schema

power_readings

IndustryDataset size

The tiny starter data. Bigger data scrolls.

Fields

reading_id	plant	megawatts
E1	Solar	40
E2	Wind	55
E3	Solar	35
E4	Hydro	70

Energy practice data only.

attempts: 0

▶ Output terminal

$ Press “Check my answer” — results appear here.

Your next steps

Each item turns green when your answer includes it.

5 left

Names the source
Defines the quality rule
Names trusted storage
Defines access
Names governance