Data marts can be built with what type of data stores?

Data marts can be built with what type of data stores?

• A. Centralized storage only
• B. Built with distributable data stores
• C. Require real-time data only
• D. Use a single vendor technology

Answer: (B)

Data marts are designed to serve a specific business area and can be built using storage that is distributed across multiple systems rather than forcing a single centralized store. This distributable approach allows data to be pulled from various source systems and stored in different types of stores—such as relational databases, columnar stores, or data lakes—across on-prem and cloud environments. It supports scalability, performance, and resilience, and fits the way departments often work with data from multiple origins. The other options are too limiting: data marts don’t have to be centralized in one place, they aren’t required to hold real-time data only, and they don’t have to rely on a single vendor technology.

Data marts are designed to serve a specific business area and can be built using storage that is distributed across multiple systems rather than forcing a single centralized store. This distributable approach allows data to be pulled from various source systems and stored in different types of stores—such as relational databases, columnar stores, or data lakes—across on-prem and cloud environments. It supports scalability, performance, and resilience, and fits the way departments often work with data from multiple origins.

The other options are too limiting: data marts don’t have to be centralized in one place, they aren’t required to hold real-time data only, and they don’t have to rely on a single vendor technology.