We're so confident of our products that we provide no hassle product exchange.
Exam 70-461: Querying Microsoft SQL Server 2012/2014
This exam retired on January 31, 2021. For currently available options, please refer to the Browse Certifications and Exams page.
This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries.
In December 2015, this exam was evaluated for applicability to both SQL Server 2012 and SQL Server 2014. It was determined that no updates to exam objectives were required.
Part of the requirements for: MCSA: SQL Server 2012/2014
Skills measured
- Create database objects (20-25%)
- Troubleshoot and optimize (25-30%)
- Work with data (25-30%)
- Modify data (20-25%)
70-461 - MCSA Querying Microsoft SQL Server 2012/2014
The 70-461 exam is part of the new SQL Server 2012 certification paths leading towards MCSA SQL Server 2012, MCSE SQL Server 2012 and MCSE Business Intelligence. The MCSA certification is the base for the higher level MCSE certifications.
Reference: https://www.microsoft.com/en-us/learning/exam-70-461.aspx
High level topics covered by our practice test
- Work with data - SELECT, sub queries, data types
- Create database objects - CREATE, ALTER, DROP, Trigger, Views..
- Troubleshoot and Optimize Queries - transactions, indexes, error handling
- Modify data - stored procedures, INSERT, UPDATE, DELETE
Microsoft 70-461日本語 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Querying Microsoft SQL Server 2012/2014 |
| Exam Number: | 70-461 |
| Exam Duration: | 120-150 |
| Exam Format: | Multiple select, Drag and drop, Active screen, Multiple choice, Build list |
| Real Exam Qty: | 40-60 |
| Passing Score: | 700 / 1000 |
| Related Certifications: | MCSE: Business Intelligence MCSA: SQL Server 2012/2014 MCSE: Data Platform |
| Exam Price: | $80 USD |
| Available Languages: | French, English, Chinese (Simplified), Portuguese (Brazil), German, Japanese |
| Certificate Validity Period: | Retired Jan 31, 2021; MCSA credential does not expire |
| Recommended Training: | Microsoft Official Course 20461: Querying Microsoft SQL Server 2014 |
| Exam Registration: | Microsoft Learn Exam Page |
| Sample Questions: | Microsoft 70-461日本語 Sample Questions |
| Exam Way: | Previously delivered via Prometric test centers and online proctoring; no longer available |
| Pre Condition: | Recommended 2+ years of hands-on experience with SQL Server and Transact-SQL; no mandatory prerequisites |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/70-461/ |
Microsoft 70-461日本語 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Work with Data | 25-30% | - Apply built-in functions, aggregate functions, window functions - Join multiple tables, apply inner/outer/cross joins - Work with grouping, grouping sets, pivot/unpivot - Use subqueries, CTEs, derived tables - Write SELECT queries, filter and sort data |
| Topic 2: Modify Data | 20-25% | - Modify data via views and stored procedures - Insert, update, and delete data - Manage transactions and error handling - Use output clause, identity columns, sequences - Merge data from multiple sources |
| Topic 3: Troubleshoot and Optimize Queries | 25-30% | - Identify performance bottlenecks - Optimize joins, subqueries, and data access - Use DMVs and query hints - Analyze execution plans, statistics, indexes - Resolve locking, blocking, and concurrency issues |
| Topic 4: Create Database Objects | 20-25% | - Create and modify views, indexed views - Define constraints (primary key, foreign key, unique, default, check) - Create and alter tables - Work with data types, collation, and nullability - Create and modify stored procedures, triggers, user-defined functions |
By Isabel
