SQL vs NoSQL Choice | Dataford Interview Questions

When would you choose SQL over NoSQL, and when would you choose NoSQL over SQL?

Using the supplied workload records and requirement signals, classify every workload. Choose SQL when it requires strong consistency, transactions, or relational joins. Choose NoSQL when it requires both horizontal scale and flexible schema. Classify all remaining workloads as Depends.

Output

One row per workload, including workloads without requirement signals
Columns: workload_name, recommendation
Order by recommendation in the sequence SQL, NoSQL, Depends, then by workload name

Schema

workloads

Column	Type	Description
workload_idPK	INT	Unique workload identifier
workload_name	VARCHAR(100)	Workload name
description	TEXT	Optional workload description

workload_signals

Column	Type	Description
signal_idPK	INT	Unique requirement signal identifier
workload_id	INT	Referenced workload identifier
signal_name	VARCHAR(50)	Requirement signal name
required	BOOLEAN	Whether the signal is a required property

Your question is SQL vs NoSQL Choice. 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