...
Database-Management-System
August 29, 2024
Database-Management-System
August 29, 2024
Database-Management-System
August 29, 2024
Database-Management-System
August 29, 2024

Database-Management-System

Question 520
A data mart may contain
A
summarised data
B
denormalized data
C
aggregate departmental data
D
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.
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.

Leave a Reply

Your email address will not be published. Required fields are marked *