Explain Data Partitioning | Dataford Interview Questions

What is partitioning?

Use the provided events table to demonstrate logical partitioning by calendar month. Return one row for each month represented by a non-null event date, including months with multiple events.

Output

Columns: partition_month, event_count, and total_value
One row per calendar month
Sort by partition_month ascending

Schema

events

Column	Type	Description
event_idPK	INT	Unique event identifier
event_date	DATE	Date used to assign the event to a calendar-month partition
value	DECIMAL(10,2)	Numeric value associated with the event

Your question is Explain Data Partitioning. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem