We're so confident of our products that we provide no hassle product exchange.
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.
Our 70-461 exam dumps will include those topics:
- Modify data (20-25%)
- Troubleshoot and optimize (25-30%)
- Create database objects (20-25%)
- Work with data (25-30%)
For more info visit: Microsoft Official 70-461 Exam Reference
Microsoft 70-461 Deutsch Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | Querying Microsoft SQL Server 2012/2014 |
| Exam Number: | 70-461 |
| Exam Format: | Multiple choice, Multiple select, Drag and drop, Build list, Active screen |
| Passing Score: | 700 / 1000 |
| Exam Price: | $80 USD |
| Certificate Validity Period: | Retired Jan 31, 2021; MCSA credential does not expire |
| Real Exam Qty: | 40-60 |
| Related Certifications: | MCSA: SQL Server 2012/2014 MCSE: Data Platform MCSE: Business Intelligence |
| Exam Duration: | 120-150 |
| Available Languages: | English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil) |
| Recommended Training: | Microsoft Official Course 20461: Querying Microsoft SQL Server 2014 |
| Exam Registration: | Microsoft Learn Exam Page |
| Sample Questions: | Microsoft 70-461 Deutsch 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/ |
Skills measured
- Modify data (20-25%)
- Troubleshoot and optimize (25-30%)
- Create database objects (20-25%)
- Work with data (25-30%)
Reference: https://www.microsoft.com/en-us/learning/exam-70-461.aspx
Microsoft 70-461 Deutsch Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Troubleshoot and Optimize Queries | 25-30% | - Resolve locking, blocking, and concurrency issues - Use DMVs and query hints - Analyze execution plans, statistics, indexes - Identify performance bottlenecks - Optimize joins, subqueries, and data access |
| Topic 2: Modify Data | 20-25% | - Manage transactions and error handling - Merge data from multiple sources - Use output clause, identity columns, sequences - Modify data via views and stored procedures - Insert, update, and delete data |
| Topic 3: Create Database Objects | 20-25% | - Work with data types, collation, and nullability - Define constraints (primary key, foreign key, unique, default, check) - Create and alter tables - Create and modify stored procedures, triggers, user-defined functions - Create and modify views, indexed views |
| Topic 4: Work with Data | 25-30% | - Apply built-in functions, aggregate functions, window functions - Work with grouping, grouping sets, pivot/unpivot - Write SELECT queries, filter and sort data - Join multiple tables, apply inner/outer/cross joins - Use subqueries, CTEs, derived tables |
By Melissa
