 |
EXAMS: WHAT TO KNOW
• Relates to: MCSE 2000 | MCDBA
- Identify the major subject areas that will be incorporated into the
data warehouse
- Analyze human factor requirements, especially the localization issue
- Choose a data storage architecture
- Identify the sources of data from the operational databases
- Identify the filtering requirements for operational data
- Assess which schema should be implemented
- Assess the level of detail required for data
- Know how to group data into fact tables and dimension tables
- Know the different aspects of Cube
- Know the roles of Dimensions, Measures, Partitions, and Fact Tables
- Analyze security requirements and know the different security levels
- Know the options for developing custom applications
|
|
|
|
|
|
Email this Article
Print this Article
