| 1.
|
Explain a data warehouse and a data mart. (I)
|
| 2.
|
Compare and contrast the system architectures. (II)
|
| 3.
|
Summarize the steps involved in analyzing and implementing data
warehousing. (II)
|
| 4.
|
Describe the design characteristics of On-Line Transaction Processing
(OLTP) systems and On-Line Analytical Processing (OLAP) systems. (III)
|
| 5.
|
Describe methodologies for designing dimensional schemes. (III)
|
| 6.
|
Describe the design characteristics of aggregate schemes. (III)
|
| 7.
|
Summarize data warehousing framework. (IV)
|
| 8.
|
Explain the purpose and components of Data Transformation Services
(DTS). (V)
|
| 9.
|
Build, store and execute DTS packages. (V)
|
| 10.
|
Describe the mechanisms for distributing data. (VI)
|
| 11.
|
Determine which type of replication to use in different data
warehousing installations. (VI)
|
| 12.
|
Describe Microsoft Structured Query Language (SQL) Server OLAP
Services. (VII)
|
| 13.
|
Build data cubes. (VII)
|
| 14.
|
Define terminology used to describe multidimensional data structures.
(VIII)
|
| 15.
|
Describe multidimensional schemes. (VIII)
|
| 16.
|
Access multidimensional data stores. (VIII)
|
| 17.
|
Explain the architecture of the Pivot Table Service. (VIII, IX)
|
| 18.
|
Create and work with in-memory data and query caching. (IX)
|
| 19.
|
Create and work with local cube persistence. (IX)
|
| 20.
|
Define the purpose and components of Microsoft English Query. (X)
|
| 21.
|
Create an English Query application. (X)
|
| 22.
|
Explain Microsoft Repository. (XI)
|
| 23.
|
Manage specific SQL Server databases operations using wizards. (XII)
|
|