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

  • Exam Code/Number: 070-764日本語
  • Exam Name/Title: Administering a SQL Database Infrastructure (070-764日本語版)
  • Certification Provider: Microsoft
  • Corresponding Certification: MCSA SQL 2016
  • Exam Questions: 452
  • Updated On: Sep,15 2026
  • Certification Level: Associate

Microsoft Administering a SQL Database Infrastructure (070-764日本語版) Exam Questions

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

users 91% student found the test questions almost same

All the information you need to pass Microsoft Administering a SQL Database Infrastructure (070-764日本語版) 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

Microsoft 070-764日本語 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)
Related Certifications:MCSA: SQL 2016 Database Administration
MCSE: Data Management and Analytics
Available Languages:Spanish, Japanese, Chinese (Simplified), English, Korean, German
Exam Price:USD 165 (approx.)
Real Exam Qty:40–60 (approx.)
Exam Duration:120–150
Passing Score:700 (scaled score)
Exam Format:Scenario-based questions, Multiple choice
Sample Questions:Microsoft 070-764日本語 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 070-764日本語 Exam Syllabus Topics:

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


0
0
0
10