Microsoft 70-764 Deutsch Exam Details & Actual Exam Questions

  • Exam Code/Number: 70-764 Deutsch
  • Exam Name/Title: Administering a SQL Database Infrastructure (70-764 Deutsch Version)
  • Certification Provider: Microsoft
  • Corresponding Certification: MCSA SQL 2016
  • Exam Questions: 452
  • Updated On: Jul,18 2026
  • Certification Level: Associate

Microsoft Administering a SQL Database Infrastructure (70-764 Deutsch Version) Exam Questions

View 70-764 Deutsch actual exam questions, answers and explanations for free.

users 93% student found the test questions almost same

All the information you need to pass Microsoft Administering a SQL Database Infrastructure (70-764 Deutsch Version) 70-764 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 70-764 Deutsch Exam Overview:

Certification Vendor:Microsoft
Exam Name:Administering a SQL Database Infrastructure
Exam Number:70-764
Certificate Validity Period:Exam retired and replaced by role-based certifications (note: retired January 2021, but information maintained for reference)
Available Languages:English, Japanese, Chinese (Simplified), Korean, German, Spanish
Exam Duration:120–150
Exam Format:Multiple choice, Scenario-based questions
Passing Score:700 (scaled score)
Exam Price:USD 165 (approx.)
Related Certifications:MCSA: SQL 2016 Database Administration
MCSE: Data Management and Analytics
Real Exam Qty:40–60 (approx.)
Sample Questions:Microsoft 70-764 Deutsch Sample Questions
Exam Way:Onsite at testing centers (e.g., Pearson VUE) or through approved online proctoring (availability may vary by region and retirement status)
Pre Condition:Recommended experience in SQL Server installation, configuration, maintenance, and database administration
Official Syllabus URL:https://learn.microsoft.com/learn/certifications/exams/70-764

Microsoft 70-764 Deutsch Exam Syllabus Topics:

SectionWeightObjectives
Configure data access and auditing20–25%- Configure auditing
  • 1. Query and analyze audit logs
  • 2. Configure SQL Server audit
- Configure data access and permissions
  • 1. Configure row-level security and dynamic data masking
  • 2. Manage database object permissions
  • 3. Manage logins, users, and roles
- Configure encryption
  • 1. Implement column and backup encryption
  • 2. Configure encrypted connections
  • 3. Configure transparent data encryption
Manage high availability and disaster recovery20–25%- Implement high availability
  • 1. Failover clustering
  • 2. Always On Availability Groups
- Implement disaster recovery
  • 1. Log shipping
  • 2. Design disaster recovery solutions
Manage backup and restore of databases20–25%- Develop backup strategy
  • 1. Transaction log backups and differential strategy
  • 2. Backup planning and automation
- Manage database integrity
  • 1. Database consistency checks
  • 2. Corruption recovery
- Restore databases
  • 1. Point-in-time restore
  • 2. Piecemeal and page restores
Manage and monitor SQL Server instances35–40%- General monitoring
  • 1. Policy-based management
  • 2. SQL Agent alerts and operators
- Monitor queries and performance
  • 1. Identify problematic execution plans
  • 2. Query Store and Extended Events
- Manage indexes and statistics
  • 1. Index fragmentation and missing indexes
  • 2. Statistics updates and maintenance
- Monitor database activity
  • 1. Identify blocking sessions and tempdb resource usage
  • 2. Configure data collector


0
0
0
10