| Microsoft SQL Server 7 Data Warehousing Precertification Practice Exam |
 |
User
Level: D
The Microsoft SQL Server 7 Data Warehousing Precertification Practice Exam is an assessment designed to measure an individual's ability to plan, design, and implement solutions using Microsoft SQL Server version 7.0 with OLAP Services and Data Transformation Services (DTS) installed. The developer must be able to perform all stages of development from analyzing and designing, to implementing and maintaining the data warehouse solution. This is designed as a precertification practice test.
What the
Microsoft SQL Server 7 Data Warehousing Precertification Practice Exam Measures
This test contains 100 questions and covers the following objectives:
 |
Analyzing
Business Requirements (13 questions) |
|
Defining the
Technical Architecture for a Solution (4 questions) |
|
Developing the Logical Design
(10 questions) |
|
Deriving the Physical Design
(8 questions) |
|
Creating Data Services
(10 questions) |
|
Implementing a Physical Data Warehouse and Implementing OLAP Services
(35 questions) |
|
Maintaining a Database and VLDB
(20 questions) |
|
SQL Server 7.0 Data Warehousing Training
(includes reference to this media) |
|
