FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
____ contains repositories of summarized data collected for analysis on a specific section or unit within an organization
A
Data Warehouse
B
Data Marts
C
Data Store
D
None
Explanation: 

Detailed explanation-1: -Data marts contain repositories of summarized data collected for analysis on a specific section or unit within an organization, for example, the sales department. A data warehouse is a large centralized repository of data that contains information from many sources within an organization.

Detailed explanation-2: -A data mart can be created from an existing data warehouse-the top-down approach-or from other sources, such as internal operational systems or external data.

Detailed explanation-3: -A data mart is a data storage system that contains information specific to an organization’s business unit. It contains a small and selected part of the data that the company stores in a larger storage system. Companies use a data mart to analyze department-specific information more efficiently.

Detailed explanation-4: -Organizations do not need to know in advance how the data will be used. A data mart is a simple form of a data warehouse that is focused on a single subject or line of business, such as sales, finance, or marketing. Given their focus, data marts draw data from fewer sources than data warehouses.

There is 1 question to complete.