AI-102 Question #144: Real Exam Question with Answer & Explanation

Question

You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file. Which type of data store should you recommend?

Options

• Acolumnar
• Bkey/value
• Cdocument
• Dobject

Explanation

Object storage is the recommended non-relational data store for unstructured data like text files, videos, and virtual disk images, as it is optimized for large binary objects, stores metadata, and assigns a unique ID.

Common mistakes.

• A. Columnar databases are optimized for analytical workloads, storing data in columns to efficiently query aggregates over large datasets, which is not ideal for storing and retrieving diverse unstructured files.
• B. Key/value stores are optimized for storing simple key-value pairs and fast lookups, but are not primarily designed for handling large, unstructured files with associated metadata efficiently at the object level.
• C. Document databases store semi-structured data as documents (e.g., JSON), which are suitable for flexible schema data but not typically optimized for storing large binary files like videos or virtual disk images themselves, often storing references to such files instead.

Concept tested. Non-relational data store types - Object storage

Reference. https://learn.microsoft.com/en-us/azure/architecture/data-guide/big-data/object-storage

No community discussion yet for this question.