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.