Verifying Data Consistency Across Environments | Dataford Interview Questions

How do you verify data consistency across different environments?

Use the provided environment and record data to compare the production and staging environments. Identify matching records, value differences, and records missing from either environment.

Output

One row per distinct record key found in either environment.
Return external_key, production_value, staging_value, consistency_status, production_updated_at, and staging_updated_at.
Sort by external_key ascending.

Schema

environments

Column	Type	Description
environment_idPK	INT	Unique environment identifier
environment_name	VARCHAR(50)	Environment name, such as production or staging
region	VARCHAR(30)	Deployment region for the environment

environment_records

Column	Type	Description
record_idPK	INT	Unique record identifier
environment_id	INT	Referenced environment
external_key	VARCHAR(50)	Logical key used to compare records across environments
record_value	VARCHAR(100)	Value stored for the logical record
updated_at	TIMESTAMP	Last update timestamp for the record

Your question is Verifying Data Consistency Across Environments. 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