Which of the following descriptions about the main usage scenarios of relational database (YySOL), document database (agDB), cache database (Redis) and wide-column database (Cassandra) are correct?…

Question

Options

• ARelational database (MySQL), transaction processing
• BWide column database (Cassandra), log storage
• CCache database (Redis): Key-Value pair
• DDocument database (longoDB): Key-Value pair

• A
  100% (13)

Explanation

All four options correctly match each database type to its primary usage scenario or data model. MySQL is built around ACID-compliant transactions, making it the standard choice for financial systems, e-commerce orders, and any workload requiring strict data consistency. Cassandra's architecture is optimized for high write throughput and time-ordered data, so storing logs, events, and time-series data at scale is one of its strongest use cases. Redis stores all data as key-value pairs in memory, giving it sub-millisecond read and write speeds ideal for caching, session management, and leaderboards. MongoDB, while more expressive than a simple key-value store, still fundamentally organizes data as key-value pairs within documents (BSON format), making this description technically accurate even though its real strength is handling nested, schema-flexible document structures.

Since all four choices are correct, there are no distractors to eliminate.

Memory tip: Group the four databases by their core strengths using the phrase "Transactions, Logs, Cache, Docs" - MySQL handles Transactions, Cassandra handles Logs, Redis is a Cache (key-value), and MongoDB handles Documents (which are built on key-value pairs). Matching the right tool to the right job is the core concept this question tests.

No community discussion yet for this question.