subject: Exam Manual Of Microsoft 70-461 Test [print this page] Querying Microsoft SQL Server 2012 exam is a pre requisite exam for Microsoft Certification. Common exam code for this exam is 70-461 exam. This exam corresponds to three certifications. Certifications are, MCSA Microsoft Certified Solution Associate SQL Server 2012, MCSE Microsoft Certified Solution Expert Data Platform, MCSA Microsoft Certified Solution Associate Business Intelligence.
Objectives of Exam
Key objective of this exam is to provide the fundamental knowledge of how to utilize the available queries, functions and tools for generation, modification, manipulation, and management of transactions of different data types within database.
Detail of 70-461 Exam Topics
Following topics are included in exam but not limited for it.
Creation of Database Objects
Creation and alteration of tables through T-SQL syntax
Creation of tables by not utilizing built in tools
Creation of views and their alteration
Creation of indexed views
Definition and implementation of structuring a view
Ascertaining code non regression
Explanation of Views and function interfaces
Implementation of logic which is utilizing dynamic SQL as well as system metadata
Explanation of write efficient
Definition of technically complicated SQL queries
Implication regarding security issues
Creation of constraints including its modification
Creation constraints on tables
Definition of constraints
Creation of DML triggers including their alteration
Explanation of nested triggers and types of triggers
Manipulation of different rows in session
Explanation of sub-queries and their implementation
Optimization of different queries
Familiarization with statistics
Reading plans for query
Classification of tricky plan within query
Explication of Guides for plan
Comprehensive awareness of various technologies associated with data accessing
Proper utilization of different correlated technologies of data accessing
Description of DMVs, Hints, and statistics IO
Explication of different types of join
Explication of scenarios
How to manage different transactions
How to mark a transaction
Differentiation among implicit and explicit transactions
Explanation of Isolation levels, scope and type of locks, trancount
Differentiation between row-based operations and set-based operations
Proper usage of cursors
Explanation of scalar UDFs and its impact
Blending of different DML operations
Implementation of try-catch-throw
Utilization of set based instead of row based logic
Details of 70-461 Exam
Number of questions
oFifty five to sixty five questions
Types of questions
oMultiple choices single response
oMultiple choices multiple-answers
oDrag and Drop
Overall numbering scale
o100 to 1000
Time Duration
oOne hundred and twenty minutes
Requisite Passing score
oSeven hundred Points
oAll question weighs different score
Exam Type
oProctored
Available Languages of Exam
Exam is available in English language only.
Registration Process
Prometric Testing Center
Preparation Tips
Following course is the recommended course for the preparation of exam.
