Microsoft 070-761 Exam : Querying Data with Transact-SQL

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

Already choose to buy "PDF"

Price: $59.99

About Microsoft 070-761 Exam

Microsoft Querying Data with Transact-SQL Exam Certification Details:

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

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:

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

Microsoft 70-761 Exam Syllabus Topics:

TopicDetailsWeights
Manage data with Transact-SQL

Create Transact-SQL SELECT queries
-Identify proper SELECT query structure, write specific queries to satisfy business requirements, construct results from multiple queries using set operators, distinguish between UNION and UNION ALL behaviour, identify the query that would return expected results based on provided table structure and/or data

Query multiple tables by using joins
-Write queries with join statements based on provided tables, data, and requirements; determine proper usage of INNER JOIN, LEFT/RIGHT/FULL OUTER JOIN, and CROSS JOIN; construct multiple JOIN operators using AND and OR; determine the correct results when presented with multi-table SELECT statements and source data; write queries with NULLs on joins

Implement functions and aggregate data
-Construct queries using scalar-valued and table-valued functions; identify the impact of function usage to query performance and WHERE clause sargability; identify the differences between deterministic and non-deterministic functions; use built-in aggregate functions; use arithmetic functions, date-related functions, and system functions

Modify data
-Write INSERT, UPDATE, and DELETE statements; determine which statements can be used to load data to a table based on its structure and constraints; construct Data Manipulation Language (DML) statements using the OUTPUT statement; determine the results of Data Definition Language (DDL) statements on supplied tables and data

40-45%
Query data with advanced Transact-SQL components

Query data by using subqueries and APPLY
-Determine the results of queries using subqueries and table joins, evaluate performance differences between table joins and correlated subqueries based on provided data and query plans, distinguish between the use of CROSS APPLY and OUTER APPLY, write APPLY statements that return a given data set based on supplied data

Query data by using table expressions
-Identify basic components of table expressions, define usage differences between table expressions and temporary tables, construct recursive table expressions to meet business requirements

Group and pivot data by using queries
-Use windowing functions to group and rank the results of a query; distinguish between using windowing functions and GROUP BY; construct complex GROUP BY clauses using GROUPING SETS, and CUBE; construct PIVOT and UNPIVOT statements to return desired results based on supplied data; determine the impact of NULL values in PIVOT and UNPIVOT queries

Query temporal data and non-relational data
-Query historic data by using temporal tables, query and output JSON data, query and output XML data

30-35%
Program databases by using Transact-SQL

Create database programmability objects by using Transact-SQL
-Create stored procedures, table-valued and scalar-valued user-defined functions, triggers, and views; implement input and output parameters in stored procedures; identify whether to use scalar-valued or table-valued functions; distinguish between deterministic and non-deterministic functions; create indexed views

Implement error handling and transactions
-Determine results of Data Definition Language (DDL) statements based on transaction control statements, implement TRY…CATCH error handling with Transact-SQL, generate error messages with THROW and RAISERROR, implement transaction control in conjunction with error handling in stored procedures

Implement data types and NULLs
-Evaluate results of data type conversions, determine proper data types for given data elements or table columns, identify locations of implicit data type conversions in queries, determine the correct results of joins and functions in the presence of NULL values, identify proper usage of ISNULL and COALESCE functions

25-30%

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

Good study guide and valid review material for a high passing rate

When you face the 070-761 exam, you must be no-mind and don't know what to do next. It is time to wake up and carry out actual plan. Microsoft 070-761 training test will give you bright thoughts. When you attend 070-761 exam test, you should have a good knowledge of MCP & 070-761 first, so you can visit Microsoft MCP and find the related information. Then, the most important thing is to go over the 070-761 study materials.

When you scan Microsoft 070-761, you can pay attention to the exam code and name to ensure that is the right one you are looking for. Besides, you will find there are three different free 070-761 Querying Data with Transact-SQL exam demos for you to download. You can do the demo test first to inspect the value of MCP 070-761 test dumps. When you buy the 070-761 exam dumps, you can download it as soon as possible after payment, then you can do test and study. There are three files for you, if you want to do marks on papers, the 070-761 PDF file are the best for you. 070-761 PDF file can be printed to papers and it is convenient to mark the key points. If you want to test your ability and scores during the practice, the 070-761 SOFT and APP file are suitable for you. So you can control your test time and adapt the 070-761 actual test more confident.

With the aid of 070-761 exam dumps, your preparation will be well enough for the 070-761 certification. There is no problem to pass the 070-761 exam test.

Skills measured

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

No help, full refund (070-761 - Querying Data with Transact-SQL exam tests)

Generally, when you buy some goods, and if you find some flaw, the vendor often admit to replace the goods with you, even though the vendor reply to refund, the process is cumbersome and the money back to you is too slow. But Exam4Tests is different. If you don't pass the exam, you just need to send us your failure transcript of 070-761 exam test, then Exam4Tests will give you a full refund, thus the money you spent on 070-761 test won't be wasted. Actually the passing rate of MCP 070-761 exam dumps is very high. We have already heard some good news from the customers who used the 070-761 Querying Data with Transact-SQL exam dumps. So you can buy the 070-761 test dumps without any burden and worries. When you have bought 070-761 test dumps, you will enjoy the preferential treatment of one year free update, which means you will keep your information about 070-761 exam test all the latest.

Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)

Everyone has dream, although it is difficult to come true, we should insist on it and struggle to the last. So, if you are busy with 070-761 exam test and feel difficult, please insist on and do not give up. There are ways helping you to get out.

MCP 070-761 exam dumps can provide some help for you. 070-761 Querying Data with Transact-SQL exam questions & answers are codified by Microsoft qualified experts. The 070-761 exam dumps simulated to the actual test and give you a high hit shot. With the high-quality and high accuracy of Querying Data with Transact-SQL exam training, you can pass the 070-761 exam test with ease.

Free Download Latest 070-761 Exam Tests

What Clients Say About Us

Success in 070-761!
Got my 070-761 certification!

Clara Clara       4.5 star  

I passed the exam today. Exam4Tests has a great support system. You can be assured to pass 100%.

Egbert Egbert       4.5 star  

I am the only one of my colleagues who passed the 070-761 exam. So proud! And it is all because of your help! Many thinks!

Hubery Hubery       4 star  

No more words can describe my happiness. Yes I am informed I pass the 070-761 exam just now. Many thanks! Will introduce Exam4Tests to all my friends!

Vivian Vivian       4 star  

I can say that Exam4Tests is well-reputed brand among the candidates. I used it only and get a good score. The high-effective of this 070-761 exam dump is really out of my expection!

Janice Janice       4 star  

Thank you so much for the perfect study 070-761 materials.

Priscilla Priscilla       4.5 star  

Thank you for your help. Your exam dumps are easy-understanding. I just used your exam questions for my 070-761 examination. I passed the exam with a high score!

Michell Michell       4 star  

The 070-761 learning materials in Exam4Tests was high efficiency, and I passed the exam successfully.

Barlow Barlow       4.5 star  

I would say 90% of the dumps on this test.

Ruby Ruby       5 star  

Thank 070-761 exam dumps, I got a high mark 94%.

Ed Ed       4.5 star  

Anyone can attempt 070-761 exam with this state of the art study guide provided by Exam4Tests, you will never regret.

Leo Leo       5 star  

070-761 preparation materials gave me much support. I passed exam just right now with ease. Thanks!

Jane Jane       5 star  

Guys it is really magical, 070-761 exam guide from Exam4Tests is 100% accurate and completely valid.

Gordon Gordon       4.5 star  

Great exam answers for 070-761 Passed my exam with 92% marks. Thank you so much Exam4Tests. Keep posting amazing things.

Lennon Lennon       5 star  

I love these 070-761 exam questions.I have Passed 070-761 exam successfully. my friends want to buy the 070-761 exam dumps too! I have told them it is from Exam4Tests!

Elliot Elliot       4 star  

Thank you so much team Exam4Tests for developing the exam questions and answers file . Passed my 070-761 certification exam in the first attempt. Exam answers file is highly recommended by me.

Julia Julia       4.5 star  

I bought the value pack but in fact PDF file is enough. Passed 070-761 exam easily!

Molly Molly       5 star  

Latest dumps for 070-761 at Exam4Tests. I prepared for the exam with these sample exams and got 98% marks. Thank you so much Exam4Tests.

Warner Warner       4.5 star  

I passed my 070-761 exam successfully. I really feel joyful. Thank you very much for offering me an admission to online program.

Felix Felix       4 star  

This is a great 070-761 exam dump. I had successfully passed with my exam. Nice purchase!

Ronald Ronald       4 star  

I was informed by my boss to clear 070-761 exam.

Geoffrey Geoffrey       5 star  

With 070-761 exam I am getting more and more precise each day.

Rita Rita       4.5 star  

LEAVE A REPLY

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

QUALITY AND VALUE

Exam4Tests 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 APPROVED

We 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 PASS

If you prepare for the exams using our Exam4Tests 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 BUY

Exam4Tests 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.

Our Clients

amazon
centurylink
vodafone
xfinity
earthlink
marriot
vodafone
comcast
bofa
timewarner
charter
verizon