AppendixAnswers to Review Questions

Chapter 2: Database Fundamentals

  1. C.  Key-value databases are ideal for storing audio, image, and video data. Document databases store data in a JSON-like structure. Graph databases excel at exploring the relationships between data. With data stored in columns instead of rows, column-oriented databases are well-suited for aggregations in a data warehouse.
  2. B.  Cassandra is a column-oriented database, MongoDB is a document database, DynamoDB is a key-value database, and Neo4j is a graph database.
  3. C.  Primary Keys uniquely identify individual rows within a table and do not directly help associate data between separate tables. Tuples contain specific data about a single data subject within a table. Relations ...

Get CompTIA DataSys+ Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial