DS0-001 · Question #92
DS0-001 Question #92: Real Exam Question with Answer & Explanation
The correct answer is E: MongoDB. MongoDB (E) and Cosmos DB (F) are NoSQL databases that store data in flexible, schema-less formats (documents, key-value pairs, graphs, etc.), meaning you can insert records without defining the structure in advance. This makes them ideal when data is unstructured, varies between
Question
A database administrator wants to create a database that does not have a predefined schema. Which of the following tools should the administrator use to create this type of database? (Choose two.)
Options
- APostgreSQL
- BMariaDB
- CMySQL
- DSQL Server
- EMongoDB
- FCosmos
Explanation
MongoDB (E) and Cosmos DB (F) are NoSQL databases that store data in flexible, schema-less formats (documents, key-value pairs, graphs, etc.), meaning you can insert records without defining the structure in advance. This makes them ideal when data is unstructured, varies between records, or evolves frequently.
Options A (PostgreSQL), B (MariaDB), C (MySQL), and D (SQL Server) are all relational databases (RDBMS) that require a predefined schema - you must define tables, columns, and data types before inserting data. They enforce structure by design.
Memory tip: If the tool uses SQL in its name or heritage (MySQL, SQL Server, MariaDB is MySQL-compatible, PostgreSQL), it's relational and schema-bound. MongoDB ("Mongo" = humongous data, flexible) and Cosmos DB (Azure's multi-model NoSQL service) are the schema-free NoSQL choices on this list.
Community Discussion
No community discussion yet for this question.