Clarify and Solve JS Array Task | Dataford Interview Questions

How would you handle a coding task that is about JS array operations when the prompt is brief?

For this SQL version, state the assumptions needed to make the operation testable, then return the transformed values for active tasks whose operation is double_positive: keep positive values, double them, preserve position order, and ignore NULL values.

Output

One row per active double_positive task, with task_id, task_name, and transformed_values.
Include an empty integer array when a qualifying task has no positive values.
Sort by task_id ascending.

Schema

array_tasks

Column	Type	Description
task_idPK	INT	Identifier for the array operation task
task_name	VARCHAR(100)	Human-readable task name
operation	VARCHAR(50)	Requested array operation
is_active	BOOLEAN	Whether the task is active

array_task_values

Column	Type	Description
element_idPK	INT	Identifier for an array element
task_id	INT	Task containing the element
position	INT	Original zero-based element position
value	INT	Numeric array element

Your question is Clarify and Solve JS Array Task. 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