Exam 70-019: Designing and Implementing Data Warehouses With Microsoft SQL Server 7.0
 | 
E X A M D I F F I C U L T Y
   
| |
|
|
SYNOPSIS • MCDBA • MCSE 2000
Microsoft’s exam 70-019, “Designing and Implementing
Data Warehouses With Microsoft SQL Server 7.0” is an elective requirement for
these certifications: MCDBA (Microsoft Certified Database Administrator) on SQL
Server 2000; MCSE (Microsoft Certified Systems Engineer) on Microsoft Windows 2000;
MCSE (Microsoft Certified Systems Engineer) on Microsoft Windows NT 4.0; and MCSD
(Microsoft Certified Solution Developer).
It is designed for candidates who are able “to
design and implement data warehouse solutions by using Microsoft SQL Server
version 7.0 with OLAP Services and Data Transformation Services (DTS)
installed.” There is no specific prerequisite for this exam.
This exam is moderate to hard in difficulty and costs $125 USD.
It
may be taken from Pearson Vue or Thomson Prometric.
At one time this
exam had a passing score of around 620, but this is subject to change. “Beginning
with the release of the Microsoft Windows Server™ 2003–related exams, Microsoft
will provide numerical scores on exams. By the end of September 2003, most
exams will have the new score report format, which includes this numerical
score... The new scale requires a minimum passing score of 700 on all exams.
The maximum score on the exams will vary depending on the complexity of the
skills being measured.” - Microsoft
Exam and Testing Procedures FAQ
Note that Microsoft
does not document the format of a particular exam: “Microsoft exams might
include adaptive testing technology and simulation items. Microsoft does not
identify the format in which exams are presented.” In the past, though, this exam
was form-based multiple choice with around 50 questions.
This exam is scheduled to be discontinued
on June 30, 2004.
The
topics covered by this exam include:
- Analyzing
Business Requirements
- Defining
the Technical Architecture for a Solution
- Developing
the Logical Design
- Deriving
the Physical Design
- Creating
Data Services
- Implementing
a Physical Data Warehouse and Implementing OLAP Services
- Maintaining
a Database and VLDB
For more information:
http://www.microsoft.com/traincert/exams/70-019.asp
Helpful: Compare this exam with others.
Retired: This exam has been retired by the vendor and is no longer available.
|
Email this Page
