Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 520 |
A data mart may contain
| summarised data | |
| denormalized data | |
| aggregate departmental data | |
| All of the above |
Question 520 Explanation:
Data mart:
1. Often holds only one subject area- for example, Finance, or Sales
2. May hold more summarized data (although many hold full detail)
3. Concentrates on integrating information from a given subject area or set of source systems
4. Is built focused on a dimensional model using a star schema.
1. Often holds only one subject area- for example, Finance, or Sales
2. May hold more summarized data (although many hold full detail)
3. Concentrates on integrating information from a given subject area or set of source systems
4. Is built focused on a dimensional model using a star schema.
Correct Answer: D
Question 520 Explanation:
Data mart:
1. Often holds only one subject area- for example, Finance, or Sales
2. May hold more summarized data (although many hold full detail)
3. Concentrates on integrating information from a given subject area or set of source systems
4. Is built focused on a dimensional model using a star schema.
1. Often holds only one subject area- for example, Finance, or Sales
2. May hold more summarized data (although many hold full detail)
3. Concentrates on integrating information from a given subject area or set of source systems
4. Is built focused on a dimensional model using a star schema.