Data Engineering Fundamentals Practice | Dataford Interview Questions

Tell me about your experience with data engineering fundamentals, including SQL and Python, and how you apply them in real projects.

Implement the function below to deduplicate records by key while retaining the record with the greatest timestamp. Each input record is a dictionary with key, timestamp, and value; return a list of dictionaries sorted by key.

Constraints

0 <= len(records) <= 500
Each record contains exactly the keys key, timestamp, and value
key is a non-empty string
timestamp is an integer
value is an integer
The output contains one record per distinct key and is sorted lexicographically by key

Function Signature

def aggregate_latest(records):

Your question is Data Engineering Fundamentals Practice. Start with the requirements 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

Tell me about your experience with data engineering fundamentals, including SQL and Python, and how you apply them in real projects.

Constraints

0 <= len(records) <= 500
Each record contains exactly the keys key, timestamp, and value
key is a non-empty string
timestamp is an integer
value is an integer
The output contains one record per distinct key and is sorted lexicographically by key

Function Signature

def aggregate_latest(records):

Your question is Data Engineering Fundamentals Practice. Start with the requirements 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.