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

  • Exam Code/Number: 070-761日本語
  • Exam Name/Title: Querying Data with Transact-SQL (070-761日本語版)
  • Certification Provider: Microsoft
  • Corresponding Certification: MCP
  • Exam Questions: 205
  • Updated On: Jul,14 2026
  • Certification Level: Associate

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

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

users 92% student found the test questions almost same

All the information you need to pass Microsoft Querying Data with Transact-SQL (070-761日本語版) 070-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 070-761日本語 Exam Overview:

Certification Vendor:Microsoft
Exam Name:Querying Data with Transact-SQL
Exam Number:70-761
Passing Score:700 (on a 1000 scale)
Certificate Validity Period:Retired (no longer available; certification has been discontinued)
Exam Duration:120 minutes
Exam Format:Multiple choice, Multiple response, Case studies, Drag and drop
Related Certifications:MCSA: SQL 2016 Database Development
70-762 Developing SQL Databases
Exam Price:USD 165 (varies by country/region)
Real Exam Qty:40-60 (approximate)
Available Languages:English, Japanese, Chinese (Simplified), Korean, French, German, Spanish, Portuguese (Brazil), Russian
Sample Questions:Microsoft 070-761日本語 Sample Questions
Exam Way:Computer-based exam delivered via online proctoring or authorized test centers (Pearson VUE, historically).
Pre Condition:No formal prerequisites; recommended knowledge of relational databases and basic Transact-SQL.
Official Syllabus URL:https://learn.microsoft.com/en-us/credentials/certifications/exams/70-761/

Microsoft 070-761日本語 Exam Syllabus Topics:

SectionObjectives
Query multiple tables- Set operators
  • 1. UNION and UNION ALL
    • 2. EXCEPT
      • 3. INTERSECT
        - Joins
        • 1. INNER JOIN
          • 2. CROSS JOIN
            • 3. OUTER JOINs (LEFT, RIGHT, FULL)
              Work with SELECT queries- Advanced SELECT operations
              • 1. Aliasing columns and tables
                • 2. TOP and OFFSET-FETCH
                  - Query fundamentals
                  • 1. Sorting results with ORDER BY
                    • 2. SELECT statement structure
                      • 3. Filtering data with WHERE
                        Data aggregation and grouping- Aggregation functions
                        • 1. COUNT, SUM, AVG, MIN, MAX
                          - GROUP BY and HAVING
                          • 1. Filtering grouped results
                            • 2. Grouping data
                              Modify data- Data manipulation language (DML)
                              • 1. INSERT statements
                                • 2. UPDATE statements
                                  • 3. DELETE statements
                                    Advanced querying features- Subqueries and expressions
                                    • 1. Correlated subqueries
                                      • 2. Scalar subqueries
                                        - Windowing functions
                                        • 1. OVER clause
                                          • 2. ROW_NUMBER, RANK, DENSE_RANK
                                            Programming with Transact-SQL- Control of flow
                                            • 1. IF...ELSE logic
                                              • 2. BEGIN...END blocks
                                                - Error handling and transactions
                                                • 1. Transactions (BEGIN, COMMIT, ROLLBACK)
                                                  • 2. TRY...CATCH


                                                    0
                                                    0
                                                    0
                                                    10