SQL vs NoSQL Choice | Dataford Interview Questions

Describe when you would choose SQL versus NoSQL for a Perplexity AI feature that stores and queries data.

Using the supplied feature requirements and domain data, write a query that assigns each matched feature a recommended storage model and a concise rationale. Exclude features without a matching domain.

Output

One row per matched feature with feature_id, feature_name, domain_name, recommended_store, and rationale
Sort by domain_id, then feature_id, both ascending.

Schema

feature_requirements

Column	Type	Description
feature_idPK	INT	Unique feature identifier
feature_name	VARCHAR(80)	Name of the feature
domain_id	INT	Related feature domain
requires_acid	BOOLEAN	Whether transactional consistency is required
has_relationships	BOOLEAN	Whether relational queries are important
schema_flexibility	VARCHAR(20)	Whether records need flexible structure
write_scale	VARCHAR(20)	Expected write scale

feature_domains

Column	Type	Description
domain_idPK	INT	Unique domain identifier
domain_name	VARCHAR(60)	Feature domain name

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