MongoDB Use Cases | Dataford Interview Questions

What are the use cases of MongoDB, and why did you use MongoDB in your project?

For the SQL portion, use the supplied workload and database-choice records to identify projects that selected MongoDB and classify the primary reason. Include projects with no matching workload detail.

Output

One row per project that selected MongoDB.
Columns: project_id, use_case, and selection_reason.
Classify each use case from workload characteristics, preserve the recorded reason, and sort by project_id ascending.

Schema

project_workloads

Column	Type	Description
workload_idPK	INT	Unique workload record identifier
project_id	VARCHAR(20)	Project identifier
nested_data	BOOLEAN	Whether the workload contains nested data
schema_change_rate	VARCHAR(20)	Frequency of schema changes
event_volume	VARCHAR(20)	Relative volume of events or records

project_database_choices

Column	Type	Description
choice_idPK	INT	Unique database-choice identifier
project_id	VARCHAR(20)	Project identifier
chosen_database	VARCHAR(30)	Database selected for the project
selection_reason	VARCHAR(160)	Recorded reason for the database selection

Your question is MongoDB Use Cases. 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