Which of the following systems is the most appropriate?

Alex wants to use data from his corporate sale, CRM, and shipping systems to try and predict future sales.

Which of the following systems is the most appropriate? Choose the best answer.
A . Data mart.
B . OLAP.
C . Data Warehouse.
D . OLTP.

View Answer

Answer: C

Explanation:

Correct answer: C. Data Warehouse.

Data warehouse bring together data from multiple systems used by an organization.

A data mart is too narrow, as Alex needs data from across multiple divisions.

OLAP is a broad term of analytical processing, and OLTP systems are transactional and not ideal for this task.