Microsoft 070-764 Exam Details & Actual Exam Questions

  • Exam Code/Number: 070-764
  • Exam Name/Title: Administering a SQL Database Infrastructure
  • Certification Provider: Microsoft
  • Corresponding Certification: MCSA SQL 2016
  • Exam Questions: 452
  • Updated On: Sep,23 2026
  • Certification Level: Associate

Microsoft Administering a SQL Database Infrastructure Exam Questions

View 070-764 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 Administering a SQL Database Infrastructure 070-764 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
(47 Up Votes)

Microsoft 070-764 Exam Overview:

Certification Vendor:Microsoft
Exam Name:Administering a SQL Database Infrastructure
Exam Number:70-764
Real Exam Qty:40-60 (varies)
Available Languages:English, Korean, Simplified Chinese, German, French, Japanese, Spanish
Passing Score:700 (on a 1000 scale)
Certificate Validity Period:Retired (certification no longer offered)
Exam Format:Short answer, Best answer selection, Case studies, Multiple choice
Related Certifications:MCSA: SQL 2016 Database Administration
MCSE: Data Management and Analytics (retired)
Exam Duration:120-150
Exam Price:$165 USD (varies by country)
Recommended Training:Microsoft Learn SQL Server Training
SQL Server Administration Documentation
Exam Registration:Pearson VUE Exam Registration
Microsoft Certification Portal
Sample Questions:Microsoft 070-764 Sample Questions
Exam Way:Online proctored or test center (Pearson VUE)
Pre Condition:No formal prerequisite required, but experience with SQL Server administration is recommended. Typically part of the MCSA SQL 2016 certification path.
Official Syllabus URL:https://learn.microsoft.com/en-us/credentials/certifications/exams/70-764/

Microsoft 070-764 Exam Syllabus Topics:

SectionObjectives
Maintain and optimize databases- Index management
  • 1. Create and maintain indexes
    • 2. Index fragmentation and optimization
      - Performance monitoring
      • 1. Dynamic Management Views (DMVs)
        • 2. Query performance tuning
          Plan and implement data storage- Manage databases and files
          • 1. Database creation and configuration
            • 2. Filegroups and storage layout
              - Implement backup strategies
              • 1. Full, differential, and transaction log backups
                • 2. Backup automation and scheduling
                  Monitor and troubleshoot SQL Server- Monitoring tools
                  • 1. SQL Server Profiler
                    • 2. Extended Events
                      - Troubleshooting performance issues
                      • 1. Query performance issues
                        • 2. Blocking and deadlocks
                          Manage SQL Server infrastructure- Configure SQL Server components
                          • 1. TempDB configuration
                            • 2. SQL Server Agent configuration
                              - Install and configure SQL Server
                              • 1. Select installation options and configurations
                                • 2. Configure server and database settings
                                  Manage high availability and disaster recovery- High availability solutions
                                  • 1. Always On Availability Groups overview
                                    • 2. Failover clustering concepts
                                      - Backup and restore planning
                                      • 1. Restore strategies and recovery models


                                        0
                                        0
                                        0
                                        10