PDF Version DemoExam 70-764: Administering a SQL Database Infrastructure
This exam retired on January 31, 2021. For currently available options, please refer to the Browse Certifications and Exams page.
This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.
Part of the requirements for: MCSA: Microsoft Dynamics 365 for Operations MCSA: SQL 2016 Database Administration
Reference: https://www.microsoft.com/en-us/learning/exam-70-764.aspx
What is the duration of the 70-764 Exam
- Length of Examination: 150 minutes
- Passing Score: 700/1000
- Number of Questions: 45-60
- Format: Multiple choices, multiple answers
How much 70-764 Exam Cost
The price of the Microsoft 70-764 exam is $165 USD.
Microsoft 070-764 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Administering a SQL Database Infrastructure |
| Exam Number: | 70-764 |
| Available Languages: | English |
| Exam Format: | Performance-based, Multiple choice, Case studies, Scenario-based |
| Certificate Validity Period: | Retired January 31, 2021; validity before retirement: 2 years |
| Real Exam Qty: | 45–60 |
| Exam Duration: | 120–150 |
| Exam Price: | USD 165 |
| Passing Score: | 700 / 1000 |
| Related Certifications: | MCSE: Data Management and Analytics MCSA: Microsoft Dynamics 365 for Operations |
| Recommended Training: | Microsoft Official Course 20764 Microsoft Learn |
| Exam Registration: | Pearson VUE (Historical) Microsoft Exam Page |
| Sample Questions: | Microsoft 070-764 Sample Questions |
| Exam Way: | Proctored onsite at Pearson VUE centers or online proctored; retired, no longer available |
| Pre Condition: | No mandatory prerequisites; recommended experience with SQL Server installation, configuration, and maintenance |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/70-764/ |
The benefit in Obtaining the 70-764 Exam Certification
- Candidates will get in-depth knowledge by completing the courses along with the access to revision materials for 6 months upon completion means they will have a wider skill set when it comes to the various technologies and systems than an uncertified professional. Certified Professional in this particular skill set is 74% more efficient when it comes to completing their tasks in a timely well-executed manner.
- Organization owners invest a lot in their employees when it comes to their training with the goal of making them quicker, more efficient, and more knowledgeable about their role. Certified Professional will reduce the time he spends on tasks, meaning he can get more done this could help reduce company downtime when repairing faults on a system or fixing hardware problems.
- Becoming a Microsoft MCP and MCSA means one thing you are worth more to the company and therefore more to yourself in the form of an upgraded pay package. On average a Microsoft MCP and MCSA member of staff is estimated to be worth 30% more to a company than their uncertified professionals.
- When Candidates applying for a job or looking to promotion in their current position, a Microsoft MCP and MCSA certification in the field in which Candidates are applying will put you at the top of the list and make them a desirable candidate for employers.
- After completion of Microsoft MCP and MCSA Certification candidates receive official confirmation from Microsoft that you are now fully certified in their chosen field. This can be now added to their CV, cover letters and job applications.
Microsoft 070-764 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Configure data access and auditing | 20–25% | - Implement encryption - Configure and manage auditing - Configure security permissions - Configure data access |
| Topic 2: Manage and monitor SQL Server instances | 35–40% | - Configure database instances - Troubleshoot performance issues - Configure automation and alerts - Monitor instance health and performance - Manage indexes and statistics |
| Topic 3: Manage high availability and disaster recovery | 20–25% | - Manage database mirroring and log shipping - Implement AlwaysOn availability groups - Implement failover cluster instances - Plan disaster recovery |
| Topic 4: Manage backup and restore of databases | 20–25% | - Perform restores - Perform backups - Manage backup strategies - Configure recovery models |
We are confident about the products and aim to help you pass with ease. In case of failure, we will provide a no hassle full money back guarantee for the purchasing fee.
1310 Customer Reviews
Quality and ValueITbraindumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITbraindumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITbraindumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.