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 o Fifty five to sixty five questions • Types of questions o Multiple choices – single response o Multiple choices – multiple-answers o Drag and Drop • Overall numbering scale o 100 to 1000 • Time Duration o One hundred and twenty minutes • Requisite Passing score o Seven hundred Points o All question weighs different score • Exam Type o Proctored 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. • Course Code: 10774A • Course Title: Querying Microsoft SQL Server 2012 • Course Duration: 3 days ExamCertify is the well known source for pdf preparation material for exam preparation like 70-461 and 70-467.
Related Articles -
70-461, Querying Microsoft SQL Server 2012,
|