Study with Microsoft : 070-761 Exam Torrent as your best preparation materials

Last Updated: Nov 16, 2026

No. of Questions: 205 Questions & Answers with Testing Engine

Download Limit: Unlimited

Choosing Purchase: "Online Test Engine"
Price: $69.00 

Professional & Latest Exam Preparation materials for 070-761 Exam

Our SurePassExams 070-761 Exam Preparation materials are famous for its high pass-rate. Actual studying content will help you pass exam for sure. Also different study methods will give you different choices and different preparing experience. 070-761 exam torrent files can help you prepare easily and get doubt result with half effort. Our Soft test engine and Online test engine will provide you simulation function so that you can have a good mood after studying deeply.

100% Money Back Guarantee

SurePassExams has an unprecedented 99.6% first time pass rate among our customers. We're so confident of our products that we provide no hassle product exchange.

  • Best exam practice material
  • Three formats are optional
  • 10 years of excellence
  • 365 Days Free Updates
  • Learn anywhere, anytime
  • 100% Safe shopping experience
  • Instant Download: Our system will send you the products you purchase in mailbox in a minute after payment. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)

Microsoft 070-761 Practice Q&A's

070-761 PDF
  • Printable 070-761 PDF Format
  • Prepared by 070-761 Experts
  • Instant Access to Download
  • Study Anywhere, Anytime
  • 365 Days Free Updates
  • Free 070-761 PDF Demo Available
  • Download Q&A's Demo

Microsoft 070-761 Online Engine

070-761 Online Test Engine
  • Online Tool, Convenient, easy to study.
  • Instant Online Access
  • Supports All Web Browsers
  • Practice Online Anytime
  • Test History and Performance Review
  • Supports Windows / Mac / Android / iOS, etc.
  • Try Online Engine Demo

Microsoft 070-761 Self Test Engine

070-761 Testing Engine
  • Installable Software Application
  • Simulates Real Exam Environment
  • Builds 070-761 Exam Confidence
  • Supports MS Operating System
  • Two Modes For Practice
  • Practice Offline Anytime
  • Software Screenshots

Waiting for a bus, waiting for friends — spare minutes add up to a certification. The Microsoft Querying Data with Transact-SQL online engine from SurePassExams turns them into progress on 205 practice questions for the 070-761 exam.

Microsoft 070-761 Exam Overview:

Certification Vendor:Microsoft
Exam Name:Querying Data with Transact-SQL
Exam Number:70-761
Exam Format:Multiple choice, Build list, Review screen, Drag and drop, Multiple response, Active screen, Hot area, Short answer
Exam Price:$165 USD
Available Languages:Chinese (Simplified), Chinese (Traditional), English, German, Russian, Japanese, French, Portuguese (Brazil)
Real Exam Qty:40-60
Certificate Validity Period:No fixed expiration for earned legacy certification; exam retired on January 31, 2021
Exam Duration:120 minutes
Passing Score:700/1000
Related Certifications:MCSA: SQL 2016 Database Development
Sample Questions: DOWNLOAD DEMO
Exam Way:Pearson VUE testing center or online proctored delivery when available; the exam is retired and no longer available for registration.
Pre Condition:No formal prerequisite exam. Intended for SQL Server database administrators, system engineers, and developers with two or more years of experience writing Transact-SQL queries. Exam 70-762 was also required to earn MCSA: SQL 2016 Database Development.

Microsoft 070-761 Exam Syllabus Topics:

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

About the Microsoft 070-761 Exam: FAQ

Delivery is instant: payment triggers an automatic email within a minute — unlimited installations, and 24/7 customer assisting for any downloading or purchasing issue if nothing arrives within 2 hours. If you fail the corresponding 070-761 exam within 60 days of purchase, choose your remedy: a full refund (scanned enrollment slip plus the official Score Report PDF within 2 days of the exam; processed within 7 days), waiting for the next updated version free, or a free change to two other equal-value dumps. Excluded: exams within 3 days of purchase, candidate names that don't match the payer, and free or expired products.

120 minutes for 40-60 questions. Fit the atmosphere in advance: timed sessions in the SurePassExams online engine make the formal pace feel practiced, not pressured.

The Microsoft Querying Data with Transact-SQL blueprint spans 3 domains — including Manage data with Transact-SQL (40-45%), Query data with advanced Transact-SQL components (30-35%), Program databases by using Transact-SQL (25-30%). Let the weightings direct your spare-time review; the full outline above lists every subtopic.

Yes — download the free Microsoft Querying Data with Transact-SQL demo and evaluate the material before paying. Purchases include 365 days of free updates, each new version emailed immediately upon release; renew afterward at 50% off.

No formal prerequisite exam. Intended for SQL Server database administrators, system engineers, and developers with two or more years of experience writing Transact-SQL queries. Exam 70-762 was also required to earn MCSA: SQL 2016 Database Development. Eligibility rules change periodically, so confirm the current requirements on the official page before registering.

The Microsoft Querying Data with Transact-SQL is Microsoft's certification exam for MCP, at the Associate level. It validates job-ready skills, and passing it marks you as a verified professional. Related credentials include MCSA: SQL 2016 Database Development.

$165 USD per attempt, 700/1000 to pass. A retake costs the full fee again — effective preparation with the 205 practice questions for the 070-761 exam is the economical path.

Microsoft Querying Data with Transact-SQL Sample Questions:

Question #1

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.)

You review the Employee table and make the following observations:
- Every record has a value in the ManagerID except for the Chief Executive Officer (CEO).
- The FirstName and MiddleName columns contain null values for some records.
- The valid values for the Title column are Sales Representative manager, and CEO.
You review the SalesSummary table and make the following observations:
- The ProductCode column contains two parts: The first five digits represent a product code, and the last seven digits represent the unit price. The unit price uses the following pattern: ####.##.
- You observe that for many records, the unit price portion of the ProductCode column contains values.
- The RegionCode column contains NULL for some records.
- Sales data is only recorded for sales representatives.
You are developing a series of reports and procedures to support the business. Details for each report or procedure follow.
Sales Summary report: This report aggregates data by year and quarter. The report must resemble the following table.

Sales Manager report: This report lists each sales manager and the total sales amount for all employees that report to the sales manager.
Sales by Region report: This report lists the total sales amount by employee and by region. The report must include the following columns: EmployeeCode, MiddleName, LastName, RegionCode, and SalesAmount. If MiddleName is NULL, FirstName must be displayed. If both FirstName and MiddleName have null values, the world Unknown must be displayed/ If RegionCode is NULL, the word Unknown must be displayed.
Report1: This report joins data from SalesSummary with the Employee table and other tables. You plan to create an object to support Report1. The object has the following requirements:
- be joinable with the SELECT statement that supplies data for the report
- can be used multiple times with the SELECT statement for the report
- be usable only with the SELECT statement for the report
- not be saved as a permanent object
Report2: This report joins data from SalesSummary with the Employee table and other tables.
You plan to create an object to support Report1. The object has the following requirements:
Sales Hierarchy report. This report aggregates rows, creates subtotal rows, and super-aggregates rows over the SalesAmount column in a single result-set. The report uses SaleYear, SaleQuarter, and SaleMonth as a hierarchy. The result set must not contain a grand total or cross-tabulation aggregate rows.
Current Price Stored Procedure: This stored procedure must return the unit price for a product when a product code is supplied. The unit price must include a dollar sign at the beginning. In addition, the unit price must contain a comma every three digits to the left of the decimal point, and must display two digits to the left of the decimal point. The stored procedure must not throw errors, even if the product code contains invalid data.
End of Repeated Scenario
You need to create the query for the Sales by Region report.
Which function should you apply to each column? To answer, select the appropriate options in the answer area.

Reveal Solution  Discussion  0

Correct Answer:


Explanation

Box 1: COALESCE
COALESCE evaluates the arguments in order and returns the current value of the first expression that initially does not evaluate to NULL.
If MiddleName is NULL, FirstName must be displayed. If both FirstName and MiddleName have null values, the world Unknown must be displayed.
The following example shows how COALESCE selects the data from the first column that has a nonnull value.
SELECT Name, Class, Color, ProductNumber,
COALESCE(Class, Color, ProductNumber) AS FirstNotNull
FROM Production.Product;
Not NULLIF: NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression.
Box 2: COALESCE
If RegionCode is NULL, the word Unknown must be displayed.
References: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/coalesce-transact-sql

Question #2

You have a database that contains the following tables:
Customer

CustomerAudit

Where the value of the CustomerID column equals 3, you need to update the value of the CreditLimit column to 1000 for the customer. You must ensure that the change to the record in the Customer table is recorded on the CustomerAudit table.
Which Transact-SQL statement should you run?

  • A. Option B
  • B. Option D
  • C. Option A
  • D. Option C
Reveal Solution  Discussion  0

Correct Answer: B  🗳️

Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).

Question #3

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a database that contains tables named Customer_CRMSystem and Customer_HRSystem. Both tables use the following structure:
The tables include the following records:
Customer_CRMSystem

Customer_HRSystem

Records that contain null values for CustomerCode can be uniquely identified by CustomerName.
You need to create a list of all unique customers that appear in either table.
Which Transact-SQL statement should you run?

  • A. Option B
  • B. Option E
  • C. Option D
  • D. Option A
  • E. Option H
  • F. Option C
  • G. Option G
  • H. Option F
Reveal Solution  Discussion  0

Correct Answer: B  🗳️

Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).

Question #4

You need to create a database object that meets the following requirements:
* accepts a product identifies as input
* calculates the total quantity of a specific product, including quantity on hand and quantity on order
* caches and reuses execution plan
* returns a value
* can be called from within a SELECT statement
* can be used in a JOIN clause
What should you create?

  • A. a temporary table that has a columnstore index
  • B. a natively-complied stored procedure that has an OUTPUT parameter
  • C. a memory-optimized table that has updated statistics
  • D. a user-defined table-valued function
Reveal Solution  Discussion  0

Correct Answer: D  🗳️

Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).

Question #5

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a table named Products that stores information about products your company sells. The table has a column named ListPrice that stores retail pricing information for products.
Some products are used only internally by the company. Records for these products are maintained in the Products table for inventory purposes. The price for each of these products is $0.00. Customers are not permitted to order these products.
You need to increase the list price for products that cost less than $100 by 10 percent. You must only increase pricing for products that customers are permitted to order.
Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?

  • A. No
  • B. Yes
Reveal Solution  Discussion  0

Correct Answer: A  🗳️

Explanation: Only visible for SurePassExams members. You can sign-up / login (it's free).

Viewing page 1 out of 41 pages.
Viewing questions 1-5 out of 205 questions.

2%
The 070-761 exam materials are valid and covered all the Q&As, trust me because i passed the 070-761 exam just now! So happy!

Tim

I pass the 070-761 exam with 90% pass rate, i believe you can pass it with easy too.

Zebulon

When I knew that the pass rate was 100%, I was really shocked. And I bought the 070-761 exam braindumps without hesitation, and I did pass the exam. Buy and pass it!

Bridget

I could not believe it when I got very good score on this 070-761 exam. Thank your 070-761 exam product!

Eileen

Thanks to SurePassExams's good 070-761 exam dumps -- all the questions are available!!!

Hedy

I bought the pdf version of 070-761 exam questions. With it, I was able to write the 070-761 test and passed it. All in all, great reference materials.

Laura

9.6 / 10 - 735 reviews

SurePassExams is the world's largest certification preparation company with 99.6% Pass Rate History from 58886+ Satisfied Customers in 148 Countries.

Disclaimer Policy

The site does not guarantee the content of the comments. Because of the different time and the changes in the scope of the exam, it can produce different effect. Before you purchase the dump, please carefully read the product introduction from the page. In addition, please be advised the site will not be responsible for the content of the comments and contradictions between users.

Over 58886+ Satisfied Customers

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

Our Clients