This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Data Quality Engineer at Amazon. The fulfillment-analytics team is rebuilding the on-time-delivery dashboard, but the underlying join between orders and shipments is producing inconsistent counts depending on whose query you run. Before anything else, you need a clean audit of every order whose shipment record is missing or incomplete — orders with NO shipment row at all (data pipeline failure or canceled before pickup), shipments missing ship_date (label printed but never picked up), and shipments missing delivery_date (in transit OR delivery event never logged). The downstream dashboard owner wants each row categorized so they can decide which gap to fix first.
You are a Data Quality Engineer at Amazon. The fulfillment-analytics team is rebuilding the on-time-delivery dashboard, but the underlying join between orders and shipments is producing inconsistent counts depending on whose query you run. Before anything else, you need a clean audit of every order whose shipment record is missing or incomplete — orders with NO shipment row at all (data pipeline failure or canceled before pickup), shipments missing ship_date (label printed but never picked up), and shipments missing delivery_date (in transit OR delivery event never logged). The downstream dashboard owner wants each row categorized so they can decide which gap to fix first.