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

Microsoft 070-761

070-761

Exam Code: 070-761

Exam Name: Querying Data with Transact-SQL

Updated: Sep 09, 2026

Q & A: 205 Questions and Answers

070-761 Free Demo download

PDF Version Demo PC Test Engine Online Test Engine

Already choose to buy "PDF"

Price: $59.99 

About Microsoft 070-761 Exam

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

Skills measured

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

Our 070-761 study tool prepared by our company has now been selected as the secret weapons of customers who wish to pass the exam and obtain relevant certification. If you are agonizing about how to pass the exam and to get the Microsoft certificate, now you can try our learning materials. Our reputation is earned by high-quality of our learning materials. Once you choose our training materials, you chose hope. Our learning materials are based on the customer's point of view and fully consider the needs of our customers. If you follow the steps of our 070-761 exam questions, you can easily and happily learn and ultimately succeed in the ocean of learning. Next, I will detail the relevant information of our learning materials so that you can have a better understanding of our 070-761 guide training.

070-761 exam dumps

Our 70-761 exam dumps will include those topics:

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

For more info visit: Microsoft Official 70-761 Exam Reference

Scientific and Convenient Design

The design of our 070-761 guide training is ingenious and delicate. Every detail is perfect. For example, if you choose to study our learning materials on our windows software, you will find the interface our learning materials are concise and beautiful, so it can allow you to study 070-761 exam questions in a concise and undisturbed environment. In addition, you will find a lot of small buttons, which can give you a lot of help. Some buttons are used to hide or show the answer. What's more important is that we have spare space, so you can take notes under each question in the process of learning 070-761 study tool. When you start, there will be a timer to help you to time, so that you can finish the problem within the prescribed time and it can create an environment. If you are satisfied with our 070-761 exam questions, you can make a choice to purchase them.

70-761 - Querying Data with Transact-SQL

The 70-761 exam is part of the Database Core Certification. This exam measures your ability to work with SQL and Transact-SQL.

This certification exam is targeted for professional who perform queries over SQL Server database. The certification is for administrators, system engineers, and developers with one or more years of experience who are seeking to validate their skills and knowledge in writing queries.. This is a list of covered topics:

  • Error handling and transactions
  • Group and pivot data by using queries
  • Create Transact-SQL SELECT queries, query multiple tables by using joins
  • Using subqueries
  • Implement and design database programmability objects by using Transact-SQL
  • Data types

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

High Efficiency

After years of hard work, our 070-761 guide training can take the leading position in the market. Our highly efficient operating system for learning materials has won the praise of many customers. If you are determined to purchase our 070-761 study tool, we can assure you that you can receive an email from our efficient system within 5 to 10 minutes after your payment, which means that you do not need to wait a long time to experience our learning materials. Then you can start learning our 070-761 exam questions in preparation for the exam.

Pass Rate is Guaranteed

As the authoritative provider of 070-761 guide training, we can guarantee a high pass rate compared with peers, which is also proved by practice. Our good reputation is your motivation to choose our learning materials. We guarantee that if you under the guidance of our 070-761 study tool step by step you will pass the exam without a doubt and get a certificate. Our learning materials are carefully compiled over many years of practical effort and are adaptable to the needs of the exam. We firmly believe that you cannot be an exception. Choosing our 070-761 exam questions actually means that you will have more opportunities to be promoted in the near future. If you eventually fail the exam, we will refund the fee by the contract. We are confident that in the future, our 070-761 study tool will be more attractive and the pass rate will be further enhanced.

Microsoft 070-761 Exam Syllabus Topics:

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

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

Thank you very much! ! !
Thanks for all your help! I also have shared your site with some of my friends, they will visit your site and take the exams that they need now.

Ashbur

Ashbur     5 star  

ITCertTest provides the best exam dumps for the 070-761 certification exam. I passed it 2 days ago with a score of 95%.

Colin

Colin     5 star  

Passed exam 070-761!
To pass exam 070-761 , I relied on ITCertTest 's practice tests. The tests were created taking questions from the previous papers.

Dolores

Dolores     5 star  

That was a huge task based on current scenario of my working hours as well as social activities, but 070-761 study guide let it be a reality within no time.

Kyle

Kyle     4.5 star  

Pass with 90% score, this dump is still valid. About 3-4 questions are different, but the remaining is ok for pass. I passed successfully.

Eunice

Eunice     4.5 star  

Your dumps 070-761 are as good as before.

Kennedy

Kennedy     4 star  

The 070-761 study dumps are very useful, and i have found some effective methods to face the exam. I am confident now.

Bradley

Bradley     4 star  

I want to say thanks to you and also advise you to use these inspiring and admirable for your 070-761 exam.

Andre

Andre     4.5 star  

I previously appeared two times in the same exam but couldn't achieve success only because of the wrong choice of a preparatory material.

Marshall

Marshall     4.5 star  

Valid 070-761 exam dumps.

Clementine

Clementine     4 star  

I have bought the 070-761 online test engine, I think it is good to simulate the actual test. From the customizable test, I knew about my weakness and strenght about the 070-761, so I can cleared my exam easily.

Theresa

Theresa     4 star  

Clearing my dream certification exam with utmost ease was nothing less than a dream come true. I got it with minimum efforts only by the use of ITCertTest 070-761 real exam dumps.

Lennon

Lennon     5 star  

Passed the 070-761 exam yesterday! I bought the Value Pack since the price is so much cheaper than the other websites, and these three versions give me more joyful study experice. You gays can buy the same with me.

Nina

Nina     5 star  

Passed the exam today! These 070-761 exam files are capable of providing you a definite exam success. Trust me!

Rosalind

Rosalind     4.5 star  

I took the 070-761 exam yesterday, and i got a green grade. I got my certification now. The 070-761 practice dump helped me a lot.

Jocelyn

Jocelyn     4 star  

LEAVE A REPLY

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

Contact US:  
 [email protected]  Support

Free Demo Download

Popular Vendors
Alcatel-Lucent
Avaya
CIW
CWNP
Lpi
Nortel
Novell
SASInstitute
Symantec
The Open Group
Tibco
Zend-Technologies
Lotus
OMG
RES Software
all vendors
Why Choose ITCertTest Testing Engine
 Quality and ValueITCertTest 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 ITCertTest 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 BuyITCertTest 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.