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