Microsoft 070-761 exam dumps - Querying Data with Transact-SQL

  • Exam Code: 070-761
  • Exam Name: Querying Data with Transact-SQL
  • Updated: Jul 24, 2026     Q & A: 205 Questions and Answers

PDF Version Demo
PDF Price: $59.99

PC Test Engine
Software Price: $59.99

Microsoft 070-761 Value Pack (Frequently Bought Together)

070-761 Online Test Engine
  • If you purchase Microsoft 070-761 Value Pack, you will also own the free online test engine.
  • PDF Version + PC Test Engine + Online Test Engine
  • Value Pack Total: $119.98  $79.99
  •   Save 49%

Humanized service

If you come to our website to choose 070-761 real exam, you will enjoy humanized service. Firstly, we have chat windows to wipe out your doubts about our 070-761 exam materials. You can ask any question about our study materials. All of our online workers are going through special training. They are familiar with all details of our 070-761 practice guide. Also, you have easy access to our free demo. Once you apply for our free trials of the study materials, our system will quickly send it via email. Last but not least, you are available for our free updated version of the 070-761 real exam. Whenever you have problems about our study materials, you can contact our online workers via email. We warmly welcome you to experience our considerate service.

It is human nature to pursue wealth and success. No one wants to be a common person. In order to become a successful person, you must sharpen your horizons and deepen your thoughts. Our 070-761 practice guide can help you update yourself in the shortest time. You just need to make use of your spare time to finish learning our 070-761 exam materials. So your normal life will not be disturbed. Please witness your growth after the professional guidance of our 070-761 study materials. In short, our 070-761 real exam will bring good luck to your life.

070-761 exam dumps

Skills measured

  • Program databases by using Transact-SQL (25-30%)
  • Query data with advanced Transact-SQL components (30-35%)
  • Manage data with Transact-SQL (40-45%)

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

Schedule exam

Languages: English

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-761.aspx

Efficient learning tools

Actually, most people do not like learning the boring knowledge. It is hard to understand if our brain rejects taking the initiative. Now, our company has researched the 070-761 practice guide, a kind of high efficient learning tool. Firstly, we have deleted all irrelevant knowledge, which decreases your learning pressure. Then, the difficult questions of the 070-761 exam materials will have vivid explanations. So you will have a better understanding after you carefully see the explanations. At the same time, our 070-761 real exam just needs to cost you a few spare time. After about twenty to thirty hours' practice, you can completely master all knowledge. Then you can apply what you have learned on our 070-761 practice guide into practices. Your speed of finishing the task will be greatly elevated. Everting will take positive changes because of our 070-761 exam materials. Please cheer up for yourself.

Correct questions and answers

Before we start develop a new 070-761 real exam, we will prepare a lot of materials. After all, we must ensure that all the questions and answers of the 070-761 exam materials are completely correct. First of all, we have collected all relevant reference books. Most of the 070-761 practice guide is written by the famous experts in the field. They are widely read and accepted by people. Through careful adaption and reorganization, all knowledge will be integrated in our 070-761 real exam. The explanations of our 070-761 exam materials also go through strict inspections. So what you have learned are absolutely correct. All in all, we have invested many efforts on compiling of the 070-761 practice guide. At last, we will arrange proofreaders to check the study materials.

Microsoft 070-761 Exam Syllabus Topics:

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

What Clients Say About Us

Unbelievable! Thank you for the unbelievable 070-761 questions and answers.

Lynn Lynn       4 star  

Absolutely satisfied with the dumps at FreeDumps for the 070-761 certification exam. Latest questions and answers included in them. I suggest all to prepare for the exam with these dumps.

Murphy Murphy       4.5 star  

I purchased the 070-761 exam dumps 2 weeks ago and passed. Thank you. I have recommended your dumps to my friends.

Magee Magee       4.5 star  

This 070-761 exam dumps is really helpful for my 070-761 examination. It is the latest version! Thank you!

Abraham Abraham       4 star  

I used latest 070-761 exam materials and I passed. The study guide helped a lot and is a great reference material and you should pass as well.

Joseph Joseph       5 star  

It is my wise choice.Just passed this 070-761 exam.

Deirdre Deirdre       5 star  

I studied the work book over and over and the test 070-761 was no problem.

Alexia Alexia       4.5 star  

I love this website-FreeDumps, i have bought several exam materials from it and passed all the exams. And i passed the 070-761 exam this time. It never lets me feel disapointed. Highly recommend to all of you!

Stephanie Stephanie       4.5 star  

I suggest everyone buy the pdf exam guide for 070-761 developer certificate. It helped me score 98% in the exam. Great work FreeDumps.

Merlin Merlin       4 star  

Adding to your satisfied customers list, I am Linda here. Passed 070-761 certification exam just moments ago and wanted to thank you without wasting any further time.

Athena Athena       5 star  

I can say that FreeDumps is well-reputed brand among the candidates. I used it's dump 2 times, and passed my exam in a short time.

Una Una       4.5 star  

I highly recommend the FreeDumps exam questions and answers pdf to all the candidates. It gives detailed knowledge about the original exam. Passed my exam recently.

Page Page       5 star  

The 070-761 training dumps are 100% accurate. And i did my preparation from these 070-761 exam dumps only. I passed the exam with flying colours. Thank you so much!

Dolores Dolores       5 star  

Passed today with a high score. Dump is very valid. Glad I came across this FreeDumps at the right time!

Ferdinand Ferdinand       5 star  

LEAVE A REPLY

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

Why Choose Us