Which two are true about MySQL Document Store?

Question

Options

• AIt helps to store data items in a schema-less key-value store.
• BIt can store documents greater than 4 GB.
• CIt depends heavily on strictly typed data.
• DIt allows one to bypass the SQL layer of the server.
• EThere is no access to relational tables.

• A
  96% (43)
• B
  2% (1)
• C
  2% (1)

Explanation

MySQL Document Store is a NoSQL interface built on top of MySQL that lets you store and retrieve JSON documents in schema-less collections. Option A is correct because documents are stored without a predefined schema, making it a flexible key-value/document store. Option D is correct because MySQL Document Store uses the X Protocol and X DevAPI, which lets applications communicate directly with the server without going through the traditional SQL layer.

Why the distractors are wrong:

• B is false - JSON documents in MySQL are capped well below 4 GB (bounded by max_allowed_packet, defaulting to 64 MB).
• C is the opposite of true - Document Store is explicitly designed to be schema-less and avoids strict typing requirements.
• E is false - one of MySQL Document Store's key selling points is that relational tables remain fully accessible alongside document collections in the same server.

Memory tip: Think of the letters A and D as "Access Data directly" - you Access schema-less documents and Directly bypass SQL to do it. If an option implies a hard restriction (strict types, no relational access, giant file sizes), it's almost certainly a distractor for a technology designed around flexibility.

No community discussion yet for this question.