Microsoft 070-761 Deutsch Exam Details & Actual Exam Questions

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

Microsoft Querying Data with Transact-SQL (070-761 Deutsch Version) Exam Questions

View 070-761 Deutsch actual exam questions, answers and explanations for free.

users 95% student found the test questions almost same

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

Certification Vendor:Microsoft
Exam Name:Querying Data with Transact-SQL
Exam Number:70-761
Exam Duration:120 minutes
Exam Price:USD 165 (varies by country/region)
Certificate Validity Period:Retired (no longer available; certification has been discontinued)
Related Certifications:MCSA: SQL 2016 Database Development
70-762 Developing SQL Databases
Exam Format:Multiple choice, Multiple response, Case studies, Drag and drop
Available Languages:English, Japanese, Chinese (Simplified), Korean, French, German, Spanish, Portuguese (Brazil), Russian
Passing Score:700 (on a 1000 scale)
Real Exam Qty:40-60 (approximate)
Recommended Training:SQL Server T-SQL Documentation
Microsoft Learn T-SQL Learning Paths
Exam Registration:Pearson VUE Microsoft Exams
Microsoft Learn Certification Page
Sample Questions:Microsoft 070-761 Deutsch 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 Deutsch Exam Syllabus Topics:

SectionObjectives
Topic 1: Modify data- Data manipulation language (DML)
  • 1. DELETE statements
    • 2. INSERT statements
      • 3. UPDATE statements
        Topic 2: 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
                Topic 3: Data aggregation and grouping- GROUP BY and HAVING
                • 1. Grouping data
                  • 2. Filtering grouped results
                    - Aggregation functions
                    • 1. COUNT, SUM, AVG, MIN, MAX
                      Topic 4: Work with SELECT queries- Query fundamentals
                      • 1. Sorting results with ORDER BY
                        • 2. Filtering data with WHERE
                          • 3. SELECT statement structure
                            - Advanced SELECT operations
                            • 1. Aliasing columns and tables
                              • 2. TOP and OFFSET-FETCH
                                Topic 5: Query multiple tables- Set operators
                                • 1. UNION and UNION ALL
                                  • 2. INTERSECT
                                    • 3. EXCEPT
                                      - Joins
                                      • 1. CROSS JOIN
                                        • 2. OUTER JOINs (LEFT, RIGHT, FULL)
                                          • 3. INNER JOIN
                                            Topic 6: Advanced querying features- Windowing functions
                                            • 1. OVER clause
                                              • 2. ROW_NUMBER, RANK, DENSE_RANK
                                                - Subqueries and expressions
                                                • 1. Scalar subqueries
                                                  • 2. Correlated subqueries


                                                    0
                                                    0
                                                    0
                                                    10