IPv6 vs IPv4 Need | Dataford Interview Questions

Tell me about why you would need IPv6 over IPv4 and what tradeoffs matter in practice.

Use the endpoint and connection observation data to produce a PostgreSQL comparison of IPv4 and IPv6 operational characteristics.

Output

One row per address family, ordered IPv4 then IPv6.
Columns: address_family, endpoint_count, nat_dependency_pct, observation_count, success_rate_pct, and avg_latency_ms.
Include only IPv4 and IPv6 endpoints. Percentages and average latency must be rounded to two decimal places.

endpoints

Column	Type	Description
endpoint_idPK	INT	Unique endpoint identifier
endpoint_name	VARCHAR(100)	Endpoint display name
address_family	VARCHAR(30)	Endpoint address family, such as IPv4 or IPv6
nat_required	BOOLEAN	Whether the endpoint requires NAT

connection_observations

Column	Type	Description
observation_idPK	INT	Unique connection observation identifier
endpoint_id	INT	Endpoint identifier associated with the observation
connection_succeeded	BOOLEAN	Whether the connection attempt succeeded
latency_ms	NUMERIC(10,2)	Observed connection latency in milliseconds

Your question is IPv6 vs IPv4 Need. Start with the requirements and the two tables 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.