Q. What is the 70-450 exam?
A. Microsoft’s 70-450 PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 exam is targeted at the professional level SQL Server 2008 Database Administrator. It tests the user ability to make appropriate design and technology choice considerations for your SQL Server 2008 installations.
Q. What are the prerequisites for the exam?
A. This exam has no prerequisite.
Q. What credit does the 70-450 exam provide?
A. Microsoft Certified IT Professional: Database Administrator 2008.
Q. What certificate does it provide?
A. This certificate provide credit towards Microsoft Certified IT Professional: Database Administrator 2008.
Q. How many questions are asked in the test?
A. 45-55 approximately
Q. What is the duration of the test?
A. 120 minutes
Q. Which type of the test is it? (Adaptive/Linear)
Q. What is the passing score?
A. 700 out of 1000
Q. What is the test retake policy?
A. Second Shot provides a free retake if you do not pass an IT professional or developer Microsoft Certification exam the first time.
Q. What are the code languages available for the exam?
A. The code languages available are English, French, German, Japanese, Spanish, Chinese (Simplified).
Q. What are the skills being measured for the exam?
A. The exam covers the following topics:
- Designing a SQL Server Instance and a Database Solution
- Designing a Database Server Security Solution
- Designing a Database Solution for High Availability
- Designing a Backup and Recovery Solution
- Designing a Monitoring Strategy
- Designing a Strategy to Maintain and Manage Databases
- Designing a Strategy for Data Distribution
Q. Where to take the test?
A. Prometric Center.