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.)

The correct answer is E. MongoDB F. Cosmos. 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…

Database Fundamentals

Question

Options

APostgreSQL
BMariaDB
CMySQL
DSQL Server
EMongoDB
FCosmos

How the community answered

(42 responses)

A
5% (2)
B
5% (2)
C
12% (5)
D
2% (1)
E
76% (32)

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.

Topics

#NoSQL databases#Schema-less design#MongoDB#Azure Cosmos DB

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice