SQL Server Training

Designing Database Solutions for Microsoft SQL Server 2012

Microsoft Exam 70-465

Microsoft Certification

Published:	June 12, 2012(In development)
Language(s):	English, French, German, Japanese, Spanish, Chinese (Simplified)
Audience(s):	IT Professionals
Technology:	Microsoft SQL Server 2012
Type:	Proctored Exam

Preparing for an Exam

The Microsoft Certification website and this preparation guide contain a variety of resources to help you prepare for an exam. Preparing for and Taking an Exam — FAQ provides answers to frequently asked questions about exam registration, preparation, scoring, and policies, including:

The most effective way to prepare to take an exam.
The relationship between Microsoft training materials and exam content.
Microsoft policy concerning the incorporation of service pack and revision updates into exam content.
Exam question types and formats.
Exam time limits and number of questions asked.

We recommend that you review this preparation guide in its entirety and familiarize yourself with the FAQs and resources on the Microsoft Certification website before you schedule your exam.

Audience Profile

This exam is intended for database professionals who design and build database solutions in an organization. They are responsible for the creation of plans and designs for database structure, storage, objects, and servers. They create the plan for the environment in which the database solution runs. Primary responsibilities may include but are not limited to:

Design a data compression strategy
Design a database model
Design a Full-Text Search strategy
Design a high-availability solution
Design a maintenance strategy for database servers
Design a management automation strategy
Design a migration, consolidation, and upgrade strategy
Design database, schema, and object security parameters
Design for business requirements
Design for concurrency
Design for high availability
Design for implicit and explicit transactions
Design instance-level security configurations
Design physical database and object placement
Design policies
Design scalable database solutions

Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.