McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
My Cart (0)  

Microsoft 70-761

70-761

Exam Code: 70-761

Exam Name: Querying Data with Transact-SQL

Updated: Oct 11, 2026

Q&A Number: 205 Q&As

70-761 Free Demo download:

PDF Version Demo PC Test Engine Online Test Engine

Already choose to buy "PDF"

Price: $59.99 

About Microsoft 70-761 Exam dumps / Bootcamp

Exam 70-761: Querying Data with Transact-SQL

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.

Part of the requirements for: MCSA: SQL 2016 Database Development

Download exam skills outline

Microsoft Querying Data with Transact-SQL Exam Certification Details:

Exam NameMicrosoft Certified Solutions Associate (MCSA) - SQL 2016 Database Development
Books / Training20761: Querying Data with Transact-SQL (three days)
Duration120 mins
Number of Questions40-60
Exam Code70-761
Schedule ExamPearson VUE
Passing Score700 / 1000
Exam Price$165 (USD)
Sample QuestionsMicrosoft Querying Data with Transact-SQL Sample Questions

Reference: https://www.microsoft.com/en-us/learning/exam-70-761.aspx

Along with the coming of the information age, the excellent IT skills are the primary criterion for selecting talent of enterprises. Microsoft Certification gives an IT a credential that is recognized in the IT industry. It can act as a passport to a well-rewarded job, smooth the path to promotion or higher earnings. Here, Microsoft certification 70-761 exam (Querying Data with Transact-SQL) is a very important exam to help you get better progress and to test your IT skills.

How to successfully pass Microsoft 70-761 certification exam? Don't worry. With DumpKiller, you will sail through your Microsoft 70-761 exam.

DumpKiller is a website that provides the candidates with the excellent IT certification exam materials. The Microsoft certification training 70-761 bootcamp on DumpKiller are on the basis for the real exam and are edited by our experienced IT experts. These dumps have a 99.9% of hit rate. So, we're sure it absolutely can help you pass Microsoft 70-761 exam and get Microsoft certificate and you don't need to spend much time and energy on preparing for 70-761 exam.

DumpKiller provides you with the most comprehensive and latest Microsoft exam materials which contain important knowledge point. And you just need to spend 20-30 hours to study these 70-761 exam questions and answers from our 70-761 dumps.

One year free update for all our customers. If you purchase DumpKiller Microsoft 70-761 practice test materials, as long as 70-761 questions updates, DumpKiller will immediately send the latest 70-761 questions and answers to your mailbox, which guarantees that you can get the latest 70-761 materials at any time. If you fail in the exam, please send the scanning copy of your 70-761 examination report card provided by the Test Center to the Email address on our website. After confirming, we will give you FULL REFUND of your purchasing fees. We absolutely guarantee you interests.

Before you decide to buy Microsoft 70-761 exam dumps on DumpKiller, you can download our free demo. In this way, you can know the reliability of DumpKiller.

No matter what level you are, when you prepare for Microsoft 70-761 exam, we're sure DumpKiller is your best choice.

Don't hesitate. Come on and visit DumpKiller.com to know more information. Let us help you pass 70-761 exam.

Easy and convenient way to buy: Just two steps to complete your purchase, we will send the 70-761 braindump to your mailbox quickly, you only need to download e-mail attachments to get your products.

Microsoft 70-761 Exam Syllabus Topics:

SectionWeightObjectives
Topic 1: Manage data with Transact-SQL40-45%- Implement functions and aggregate data
  • 1. Use scalar functions
  • 2. Use GROUP BY and HAVING
  • 3. Use ranking functions
  • 4. Use aggregate functions
- Create Transact-SQL SELECT queries
  • 1. Construct results from multiple queries using set operators
  • 2. Identify proper SELECT query structure
  • 3. Identify queries that return expected results based on table structure or data
  • 4. Distinguish between UNION and UNION ALL behavior
  • 5. Write queries to satisfy business requirements
- Query multiple tables by using joins
  • 1. Handle NULL values in join columns
  • 2. Write queries using cross joins
  • 3. Write queries using self joins
  • 4. Write queries using inner joins
  • 5. Write queries using outer joins
- Modify data
  • 1. Write UPDATE statements
  • 2. Use the OUTPUT statement
  • 3. Write INSERT statements
  • 4. Write DELETE statements
Topic 2: Query data with advanced Transact-SQL components30-35%- Query data by using table expressions
  • 1. Use common table expressions
  • 2. Use views
  • 3. Use inline table-valued functions
  • 4. Use derived tables
- Query data by using subqueries and APPLY
  • 1. Use correlated and non-correlated subqueries
  • 2. Use APPLY
  • 3. Use EXISTS and NOT EXISTS
- Group and pivot data by using queries
  • 1. Use grouping sets
  • 2. Use ROLLUP and CUBE
  • 3. Use PIVOT and UNPIVOT
- Query temporal and non-relational data
  • 1. Query XML data
  • 2. Query temporal tables
  • 3. Output results as XML or JSON
  • 4. Query JSON data
Topic 3: Program databases by using Transact-SQL25-30%- Create database programmability objects by using Transact-SQL
  • 1. Create views
  • 2. Create user-defined functions
  • 3. Create stored procedures
- Implement error handling and transactions
  • 1. Use TRY...CATCH
  • 2. Use THROW and RAISERROR
  • 3. Manage transaction isolation
  • 4. Implement transactions
- Implement data types and NULLs
  • 1. Handle NULL values
  • 2. Choose appropriate data types
  • 3. Use implicit and explicit conversions

861 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)

70-761 exam dumps are 100% valid. Pass today with these question dumps.

Haley

Haley     4 star  

Thank you for the updated 70-761 exam material! I passed my exam with good scores. You can do that too!

King

King     4 star  

Thank you!
Hello, just cleared 70-761 exam.

Gail

Gail     4.5 star  

Valid dumps!
Glad that you released the 70-761 update version.

Humphrey

Humphrey     4.5 star  

there are very high possibilities to pass exam. this dump is valid 100%. Passed today score 95%

Clark

Clark     4 star  

this dump is still valid. passed this week, a few new questions. strong recommendation!

Philipppa

Philipppa     5 star  

You can rely totally on these 70-761 exam dumps, and you don't need to do any additional job with all the topics. It really saved time and efforts. Thanks for letting me pass so easily!

Page

Page     4.5 star  

I have passed 70-761 exam with your material,it's very useful for me,will come back.

Amanda

Amanda     4.5 star  

I passed 70-761 exam last week, it was really handy for me and I prepared my exam within few days.

Nelson

Nelson     4.5 star  

I have used your material around two years,the material never let me down,yesterdays i just get 70-761 certification,what a nice experience.

Sid

Sid     4.5 star  

My success in 70-761 exam is all because of you guys. I cleared the actual 70-761 examination last week.

Riva

Riva     4.5 star  

Passed the 70-761 exam today. I didn't study the other exam materials or books. I just Learned this 70-761 practice test and passed with 96% marks!

Howar

Howar     4 star  

Your site is a blessing for those students who are very interested in taking 70-761 exam.

Myra

Myra     5 star  

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Contact US:  
 [email protected]  Support

Free Demo Download

Guarantee & Refund Policy
Popular Vendors
Alcatel-Lucent
Avaya
CIW
CWNP
Lpi
Nortel
Novell
SASInstitute
Symantec
The Open Group
all vendors
Why Choose DumpKiller Testing Engine
 Quality and ValueDumpKiller Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
 Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
 Easy to PassIf you prepare for the exams using our DumpKiller testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
 Try Before BuyDumpKiller offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.