Microsoft 70-764 : Administering a SQL Database Infrastructure

  • Exam Code: 70-764
  • Exam Name: Administering a SQL Database Infrastructure
  • Updated: Jun 20, 2026
  • Q & A: 452 Questions and Answers

PDF Version

PC Test Engine

Online Test Engine

Total Price: $59.99

About Microsoft 70-764 Exam

Microsoft 70-764 Exam Syllabus Topics:

TopicDetails
Topic 1
  • Query The SQL Server Audit Log, Manage A SQL Server Audit
  • Configure Row-Level Security
Topic 2
  • Configure User Options For Azure SQL Database
  • Implement Cell-Level Encryption
Topic 3
  • Configure Dynamic Data Masking
  • Configure The Data Collector
  • Manage Database Object Permissions
Topic 4
  • Configure Alerting For Failed Backups
  • Configure An Audit On SQL Server
Topic 5
  • Manage Transaction Log Backups
  • Back Up Very Large Databases
  • Configure Backup Automation
Topic 6
  • Configure Encryption For Connections
  • Configure Data Access And Permissions
  • Implement Backup Encryption
Topic 7
  • Implement Auto Update Statistics
  • Recover From Database Corruption
  • Configure Transparent Data Encryption
Topic 8
  • Perform Point-In-Time Recovery
  • Identify Sessions That Cause Blocking Activity
Topic 9
  • Troubleshoot Server Health Using Extended Events
  • Implement Database Consistency Checks
Topic 10
  • Configure Read-Only Routing, Manage Failover
  • Configure Windows Clustering
  • Implement Failover Cluster Instances
Topic 11
  • Develop A Plan To Automate And Test Restores
  • Identify Problematic Execution Plans
Topic 12
  • Configure Policy-Based Management
  • Identify Database Corruption
  • Implement Alwayson Availability Groups
Topic 13
  • Implement Statistics For Large Tables
  • Configure Cluster Shared Volumes
  • Create And Maintain Users
Topic 14
  • Monitor SQL Server Instances
  • Manage Database Integrity
  • Create And Manage Operators
Topic 15
  • Identify Sessions That Consume Tempdb Resources
  • Configure An Azure SQL Database Audit
Topic 16
  • Identify And Create Missing Indexes
  • Identify And Drop Underutilized Indexes
  • Create And Maintain Custom Roles
Topic 17
  • Manage Existing Columnstore Indexes
  • Identify And Repair Index Fragmentation
  • Identify And Correct Outdated Statistics

Reference: https://www.microsoft.com/en-us/learning/exam-70-764.aspx

Who should take the 70-764 exam

The Microsoft 70-764 Exam is an internationally recognized validation that identifies persons who earn it as possessing skilled in MCP and MCSA Certification. If candidates want significant improvement in career growth needs enhanced knowledge, skills, and talents. The Microsoft 70-764 Exam provides proof of this advanced knowledge and skill. If a candidate has knowledge of associated technologies and skills that are required to pass the Microsoft 70-764 Exam then he should take this exam.

Exam 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

Download exam skills outline

Privacy and security

As a reliable platform, we always put our customer's interests in the first place. We are deeply concerned about your privacy and security. First, our 70-764 test engine is safety and virus-free, thus you can rest assured to install Microsoft 70-764 real practice torrent on your computer or other electronic device. Besides, we keep our customers' financial data and personal information private and secure, and never share it with the third part without the permission of you. You can search information about the 70-764 Administering a SQL Database Infrastructure pdf study guide as you like. We will try our best to offer the desired material for you.

Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)

As an aspiring IT candidate, you are must desperate to want to pass 70-764 exam certification under all costs and conditions. While, our 70-764 free practice torrent will not only help you pass your exam, but also save your time and energy at the same time. MCSA SQL 2016 70-764 sure pass torrent is the latest and edited and checked by our professional experts, which always can cover all the topics in the actual test. With our 70-764 exam vce torrent, you will test your knowledge and skills, and know more about the actual test. You will not waste much time on several times for test. One time pass with Microsoft 70-764 free download dumps is the guarantee for all of you.

Free Download 70-764 Exam Torrent

70-764 free practice torrent

Our 70-764 free practice torrent is available for all of you. Simply download 70-764 free pdf demo and get the practice questions. The demo questions are part of the complete dumps. With our 70-764 free download dumps you can determine whether the 70-764 real questions & answers are worth your time and investment or not. The 70-764 free pdf demo support to be printed, while if you want the 70-764 test simulator for reference, we can provide you the screenshot about the practice format. If you buy the dumps from other vendors and get the unhappy result, and want to make sure the validity of our MCSA SQL 2016 70-764 exam vce torrent, you can send your dumps to us, then we can check and compare them and tell you our dumps is worthy buying or not.

70-764 test engine for sure pass

The 70-764 test engine provides you with a virtual examination environment, which further helps you to be more familiar with the 70-764 actual test. The 70-764 test engine comes with many features which save your time for other training classes. With the 70-764 real questions & answers, you will easily memorizing the important concepts, and will feel as you are in the actual test. It is very good to experience the simulate environment in advance. Besides, at the end of each test the result will be declared along with the mistakes, so that you can know your weakness and strengthen about 70-764 Administering a SQL Database Infrastructure actual test, then make the detail study plan for further learning. In addition, when you receive our 70-764 exam vce torrent, you can download it with the computer, and then install it on your phone or other device. It is very convenient to study with our 70-764 sure pass torrent.

Skills measured

  • Configure data access and auditing (20-25%)
  • Manage high availability and disaster recovery (20-25%)
  • Manage and monitor SQL Server instances (35-40%)
  • Manage backup and restore of databases (20-25%)

1093 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)

I really feel grateful to Free4Torrent exam pdf for my 70-764 exam. I passed the 70-764 exam with good score.

Ron

Ron     4.5 star  

Just know I pass, happy happy happy. Recommendation!!! The 70-764practice test is very useful for me. I fail once. This time I buy the SOFT file, I feel easy to pass. Wonderful!

Dale

Dale     5 star  

Thanks again!
I decide to get Certification MCSA SQL 2016.

Frederic

Frederic     5 star  

It was enough to pass the 70-764 even i only studied for one day. Practice and study makes perfect.

Eudora

Eudora     4.5 star  

My roommate introduced Free4Torrent to me and he said their study dumps are quite effective. I decided to have a try. You didn’t let me down. I truly passed with ease.

Warner

Warner     5 star  

All my thanks to 70-764 study material.

Christian

Christian     5 star  

Your team is quite veteran and highly inclined to facilitate their customers so that they may take 70-764 exam very easy.

Nat

Nat     4.5 star  

Passed my exam highly in the last week! I don’t regret buying this 70-764 practice engine from you. It is worthy and wise to buy it!

Norman

Norman     4 star  

This 70-764 exam dumps is really helpful for my 70-764 examination. It is the latest version! Thank you!

Myron

Myron     4.5 star  

I prepared my 70-764 exam only with their materials.

Miles

Miles     5 star  

Passed the 70-764 exam yesterday! I bought the Value Pack since the price is so much cheaper than the other websites, and these three versions give me more joyful study experice. You gays can buy the same with me.

Ronald

Ronald     5 star  

I give full marks to the latest version of Free4Torrent 70-764 pdf exam containing all the valid and working material to pass this specific exam in first attempt. I was really Goal Achieved

Hugh

Hugh     4 star  

Thanks to your kind services, i passed the 70-764 exam today! If they didn't inform me, i would buy the wrong exam materials, they are so sweet and professional. Thanks again!

Dawn

Dawn     4.5 star  

Because I have a limit time to pass the 70-764 exam, I decide to choose 70-764 exam dump as the shortcut. The result is wonderful. Passed successfully. Thanks you!

Marsh

Marsh     4.5 star  

Girlfriend send 70-764 to me, LOVE LOVE LOVE. PASS EASILY. Hope we 'll be forever. Thanks, Honey!

Martin

Martin     5 star  

I am a Britain, when buying the 70-764 training materials, I saw it was paid by US dollars, so I asked the online service for help, and they said that the system will exchange the currency for the payment, quite convenient!

Erin

Erin     5 star  

It is really a good 70-764 guide I think, and thank you very much.

Bing

Bing     5 star  

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Quality and Value

Free4Torrent 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 Approved

We 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 Pass

If you prepare for the exams using our Free4Torrent 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 Buy

Free4Torrent 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.