subject: Reference Guide For Microsoft 70-464 Exam [print this page] 70-464 exam is also recognized as Developing Microsoft SQL Server 2012 Databases exam. It is an endorsed credential offered by Microsoft Certification. This exam corresponds to the following certification.
MCSE Microsoft Certified Solutions Expert Data Platform
Concepts and Objectives
This exam assesses the candidates knowledge and expertise in planning, development, installation, and modification of databases in an organizational infrastructure as well as ascertaining availability of data at high level. This exam also provides knowledge of following tasks.
Building database files
Generation of data type
Table generation
Making plans
Building indexes
Optimization for optimal availability and performance
Implementation of data integrity
Deployment of views
Handling of stored procedures and functions
Management of locks and transactions
Associated Product Assessed
Following product will be tested but are not limited.
Microsoft SQL Server 2012
Ideal Aspirants
This course is specifically designed for professionals belong to Information Technology and are working as developers and administrators of databases in organizational environment.
Recommended and Required Aptitude
It is strongly recommended that aspirant must have on the job experience in the respective field and must be fluent and extensively skilled in the following tasks.
Optimization and modification of queries
Building and tuning of stored procedures
Creation and modification of indexes
Maintenance of database integrity
Optimization of strategies for indexing
Creation and modification of tables
Maintenance of indexes
Production and alteration of constraints
Generation and modification of views
Generation and modification of user-defined functions (UDFs)
Controlling of execution plans
Handling of XML Data
Implementation of full text search
Troubleshooting of security
70-464 Course Outline
Microsoft learning has a detailed list of Course outline available at its website. Please consult Microsoft Learning for exact blue print of the exam topics or any further information.
Questionnaire and Scoring
Questions are mostly compound selections requiring either a single response or multiple replies. Exam is approximately one hundred and twenty minutes long. Candidate securing Seventy percent or higher marks will be measured as passed candidate.
Languages Available
This course is available in eight different languages. Languages are English, French, German, Japanese, Russian, Spanish, Portuguese (Brazil), Chinese (Simplified). Language will have to be specified at the time of scheduling for exam otherwise default English language will be selected automatically.
Registration Process
Prometric Testing Center is an authorized registration venue for this exams registration. Prometric Testing Centers will also process fee and other pre-requisite credentials if any. Contact your nearest Prometric Testing center for any further details regarding registration process.
70-464 Preparation Tips
This course is presented by Microsoft and strongly recommended training material for this exam. Free practice tests are also available for the assessment of delegates preparation level and acquainting him/her with exam environment.
Trainer led Classroom course
Course number 10776A
Course Title Developing Microsoft SQL Server 2012 Databases
Course Duration 5 days
Please consult Microsoft Learning for further details on scheduling and classing.
