Microsoft 70-761日本語 Exam Details & Actual Exam Questions

Exam Code/Number: 70-761日本語
Exam Name/Title: Querying Data with Transact-SQL (70-761日本語版)
Certification Provider: Microsoft
Corresponding Certification: MCP

Exam Questions: 205
Updated On: Jul,14 2026
Certification Level: Associate

Microsoft Querying Data with Transact-SQL (70-761日本語版) Exam Questions

View 70-761日本語 actual exam questions, answers and explanations for free.

Go To 70-761日本語 Questions

95% student found the test questions almost same

All the information you need to pass Microsoft Querying Data with Transact-SQL (70-761日本語版) 70-761日本語 exam and free practice exam verified by EduDump exam experts.

Said the test questions were almost same

Passed the exams with the material

Found the study quides effective and helpful

Microsoft 70-761日本語 Exam Overview:

Certification Vendor:	Microsoft
Exam Name:	Querying Data with Transact-SQL
Exam Number:	70-761
Exam Duration:	120 minutes
Related Certifications:	MCSA: SQL 2016 Database Development
Passing Score:	700/1000
Available Languages:	English, Chinese (Simplified), Chinese (Traditional), French, German, Japanese, Portuguese (Brazil), Russian
Certificate Validity Period:	No fixed expiration for earned legacy certification; exam retired on January 31, 2021
Real Exam Qty:	40-60
Exam Format:	Multiple choice, Multiple response, Drag and drop, Build list, Hot area, Active screen, Short answer, Review screen
Exam Price:	$165 USD
Sample Questions:	Microsoft 70-761日本語 Sample Questions
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.
Official Syllabus URL:	[https://learn.microsoft.com/en-us/certifications/exams/70-761](https://learn.microsoft.com/en-us/certifications/exams/70-761)

Microsoft 70-761日本語 Exam Syllabus Topics:

Section

Weight

Objectives

Program databases by using Transact-SQL

25-30%

- Implement error handling and transactions

1. Use THROW and RAISERROR
2. Use TRY...CATCH
3. Manage transaction isolation
4. Implement transactions

- Create database programmability objects by using Transact-SQL

1. Create views
2. Create stored procedures
3. Create user-defined functions

- Implement data types and NULLs

1. Handle NULL values
2. Choose appropriate data types
3. Use implicit and explicit conversions

Manage data with Transact-SQL

40-45%

- Implement functions and aggregate data

1. Use aggregate functions
2. Use ranking functions
3. Use GROUP BY and HAVING
4. Use scalar functions

- Query multiple tables by using joins

1. Write queries using self joins
2. Write queries using inner joins
3. Write queries using cross joins
4. Handle NULL values in join columns
5. Write queries using outer joins

- Modify data

1. Use the OUTPUT statement
2. Write INSERT statements
3. Write DELETE statements
4. Write UPDATE statements

- Create Transact-SQL SELECT queries

1. Identify queries that return expected results based on table structure or data
2. Construct results from multiple queries using set operators
3. Write queries to satisfy business requirements
4. Distinguish between UNION and UNION ALL behavior
5. Identify proper SELECT query structure

Query data with advanced Transact-SQL components

30-35%

- Query data by using table expressions

1. Use derived tables
2. Use inline table-valued functions
3. Use common table expressions
4. Use views

- Group and pivot data by using queries

1. Use ROLLUP and CUBE
2. Use PIVOT and UNPIVOT
3. Use grouping sets

- Query temporal and non-relational data

1. Output results as XML or JSON
2. Query XML data
3. Query JSON data
4. Query temporal tables

- Query data by using subqueries and APPLY

1. Use correlated and non-correlated subqueries
2. Use EXISTS and NOT EXISTS
3. Use APPLY