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: Jun 02, 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

If you want to pass 070-761 exam, go and buy this 070-761 exam materials. You are worthy of it!

Ada Ada       4 star  

When I ordered the 070-761 exam materials, I am still a little worried about it. But, after I used the exam dumps, I changed my idea. Because it covers all the key knowledge points. Eventually, I passed my exam. Thanks!

Morgan Morgan       4 star  

I found some answers are wrong, please correct them.

Aurora Aurora       4 star  

I purchased the bundle file for 070-761 by TestPassed. Must say it is worth the money spent. Passed my exam in the first attempt with an 90% score.

Orville Orville       4 star  

Passed my 070-761 exam 2 days ago, your 070-761 practice dumps are excellent!

Sean Sean       4.5 star  

With your new updated guide, I passed my 070-761 test today.

Oswald Oswald       4 star  

Thanks a lot TestPassed.

Jill Jill       5 star  

I passed 070-761 exam sucessfully with using TestPassed exam questions &answers.

Mona Mona       4.5 star  

I bought this study material to take my 070-761 exams and passed it with a good score. Thanks

Elsie Elsie       4.5 star  

Good job! I passed 070-761 test.

Yves Yves       4 star  

All the 070-761 questions are covered.

Quentin Quentin       5 star  

And your materials are very helpful.
And never disappointed.

Bella Bella       4.5 star  

I appreciate TestPassed for developing a study material that provides a deep exposure of each and every topic of 070-761 certification exam. This remarkable content was provid

Catherine Catherine       4 star  

Really amazing 070-761 study guide containing so many answered questions! They are all accurate, i have passed the exam today. Thanks!

Lorraine Lorraine       5 star  

You can use the 070-761 exam dumps. I passed my 070-761 exam with using them. You will get to know the areas that you need to perfect. All the best!

Isidore Isidore       5 star  

TestPassed really handy for me and I prepared my exam within few days. It was a long-awaited dream of specialized career which at last was effectively materialized with the assist of 070-761 exam materials.

Joanna Joanna       4 star  

Very clear and to the point. Good dump to use for 070-761 exam preparation. I took and passed the 070-761 exam last week.

Evelyn Evelyn       4 star  

Today, i present my 070-761 exam, i bought the 070-761 training questions and my score is 97%. Thanks, TestPassed!

Hilda Hilda       4.5 star  

070-761 exam dump is helpful. I Passed today. Only 3 new questions didn't matter. I feel really relax now and grateful to this TestPassed!

Sigrid Sigrid       4.5 star  

I have passed 070-761 exams with high scores. Thank you TestPassed for the best study materials. I only used your braindumps for all my exams.

Rosalind Rosalind       4 star  

i was recommended to use TestPassed by my colleagues, who passed their exams before. Today,
i also passed the 070-761 exam using your 070-761 dumps. it was not that hard as i thought. thank you!

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