Resolving Dashboard Discrepancies | Dataford Interview Questions

How would you handle a situation where a key dashboard shows a discrepancy between two different source systems at Crusoe?

For the SQL portion, write a query that compares the two provided source tables at the resource and date level. Return every missing or mismatched record, including the values available in each source.

Output

One row per missing or mismatched resource and date
Columns: report_date, resource_id, source_a_value, source_b_value, difference, and discrepancy_type
Sort by report_date, then resource_id

Schema

source_system_a_metrics

Column	Type	Description
metric_datePK	DATE	Date associated with the metric
resource_idPK	VARCHAR(50)	Resource identifier
metric_value	NUMERIC(12,2)	Metric value reported by source A

source_system_b_metrics

Column	Type	Description
metric_datePK	DATE	Date associated with the metric
resource_idPK	VARCHAR(50)	Resource identifier
metric_value	NUMERIC(12,2)	Metric value reported by source B

Your question is Resolving Dashboard Discrepancies. 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.

Problem