Fast learning with high-quality 070-761 Training Materials after purchasing; free demo before buying 070-761 Exam Torrent materials, Favorable price of 070-761 Study Guide make you cost-efficient and satisfying.

Microsoft 070-761 pass test : Querying Data with Transact-SQL

070-761 actual test
  • Exam Code: 070-761
  • Exam Name: Querying Data with Transact-SQL
  • Updated: Aug 31, 2026
  • Q & A: 205 Questions and Answers
  • PDF Demo
  • PC Test Engine
  • Online Test Engine
  • Total Price: $59.99  

About Microsoft 070-761 Exam

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%)

Microsoft 70-761 Exam Syllabus Topics:

TopicDetailsWeights
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%
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%

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

Fast learning with high-quality products

There is no denying that preparing for the exam is a time-consuming as well as energy-consuming process without valid 070-761 study guide materials, while the paradox is that a majority of the candidates for the exam are workers who don't have enough time to spend on preparing, and the good news for you is that our company is aimed at solving this problem by releasing high passing-rate 070-761 training materials for all of the workers in this field. We have employed a large number of the leading experts in this field to compile our high-quality 070-761 exam torrent, and we have put forces on the efficiency of our study material. Facts proved that almost all of the candidates can pass the exam as well as getting the certification only after practicing our high-quality 070-761 study guide materials for 20 to 30 hours, which means that you can get success with the minimum of time and effort.

It is easy to understand that the candidates who are preparing for exams (without 070-761 training materials) are very similar to the soldiers who are preparing for the battles, on the one hand, all of them need to spend a lot of time as well as energy and even a large amount of money in the course of preparation (without 070-761 exam torrent), on the other hand, it is inevitable that some people will become winners while others will become losers in the process. Do you want to be the winner (with our 070-761 study guide)? I strongly believe that almost everyone would like to give me the positive answer to this question. Our company is right here to help you to win your personal battle with the minimum of time and effort, because we have spent over ten years in creating the secret weapon for you—our 070-761 training materials. The advantages of our 070-761 exam torrent are as follows.

Free Download real 070-761 test passed rate

Favorable price

Our company has a profound understanding of the psychology of consumers and we always would like to take the needs of our customers into consideration (070-761 study guide materials), it is universally acknowledged that the popularity of a company is driven not only by the vast selection and the high level of customer service, but also -- and mainly -- by the favorable price as well as the deep discounts the company regularly offers. So in order to let our 070-761 training materials available to as many workers in this field as possible, we have always kept the favorable price for our 070-761 exam torrent materials even though our products have been acclaimed as the most effective and useful study materials in this field by all of our customers in the international market.

After purchase, 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.)

Free demo before buying

I dare to say that our 070-761 training materials are the most useful and effective study materials in the field which is 100 percent trustworthy, we are not afraid of any test for our products--070-761 exam torrent, so we provide the free demo of our 070-761 study guide materials in this website for all of the workers in this field to have a try. We strongly believe that after trying you will be satisfied with our 070-761 training materials and will have more confidence to pass the exam as well as getting the certification, since you will find all of the key points as well as the latest question types are concluded in our 070-761 exam torrent materials. Seeing is believing, if you still have any misgivings just feel free to download our free demo in this website.

What Clients Say About Us

I feel more confident on 070-761 with the help of the exam dumps provided by 070-761.

Claude Claude       5 star  

I tried free demo before buying 070-761 training materials, and they helped me know the mode of the complete version.

Reginald Reginald       4 star  

Never push yourself. 070-761 exam is simple. Many real question are practised on this 070-761 dumps many times.

Lester Lester       4.5 star  

Good 070-761 exam practice questions. I use them recently to prepare and pass my 070-761 exam. Good wok TestPassed!

Pearl Pearl       4 star  

Cheers! I finally passed the exam. Truly, the 070-761 exam dump was very much helpful as I got so many questions common.

Debby Debby       5 star  

These 070-761 exam braindumps helped me the most on may way to get the certification. Thanks! I have gotten the certification now.

Moore Moore       5 star  

I don't understand all of the concepts of the topics, so i try my best to remember the Q&A together. So lucky that i passed it. I feel grateful to choose this TestPassed!

Tyrone Tyrone       4 star  

After using Software version, I can say without any doubt that TestPassed is a very professional website that provides all of candidates with the excellent exam materials. I used 070-761 study materials and passed the 070-761 exams last week.

Andre Andre       5 star  

WOW this dump is accurate!
it was amazingly doing at this platform, just passed it.

Ward Ward       4.5 star  

Thank you so much for your high-effective 070-761 exam braindumps! This is an important exam for me and i had cleared it with your help. Thank you again! The certification will help me to get a better job!

Arlen Arlen       4.5 star  

These 070-761 exam dumps are still valid, I cleared this exam yesterday on 5th June 2018. All simulations came from here and theory questions came from here.

Bruce Bruce       4 star  

Yesterday passed 070-761 exam. 90% questions were valid. The dump helps. Thanks a lot!

Dominic Dominic       4.5 star  

Thanks for 070-761 exam dumps that made exam much easier for me without disturbing my routine works. I just used these real 070-761 exam dumps and got through with distinction.

Oswald Oswald       4 star  

Guys, I have passed 070-761 exam this morning! This is really valid 070-761 exam guide.

Debby Debby       4 star  

LEAVE A REPLY

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

QUALITY AND VALUE

TestPassed 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 TestPassed 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

TestPassed 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