Python, SQL, and Kafka Questions | Dataford Interview Questions

How would you answer Python, SQL, and Kafka questions under a multiple-choice and coding format?

Treat this as a mixed interview prompt with short-answer coding responses. For Python, write a function that solves the stated task. For SQL, provide the query against the given table schema. For Kafka, explain the behavior or write the code/configuration snippet requested.

Constraints

1 <= len(prompts) <= 20
Each prompt must include a valid type field
Supported types are python, sql, and kafka

Function Signature

def answer_questions(prompts):

Your question is Python, SQL, and Kafka Questions. 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

How would you answer Python, SQL, and Kafka questions under a multiple-choice and coding format?

Constraints

1 <= len(prompts) <= 20
Each prompt must include a valid type field
Supported types are python, sql, and kafka

Function Signature

def answer_questions(prompts):

Your question is Python, SQL, and Kafka Questions. 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.