I have passed this 70-764 with full marks.
Exam Code: 70-764
Exam Name: Administering a SQL Database Infrastructure
Updated: Oct 26, 2026
Q & A: 452 Questions and Answers
70-764 Free Demo download
The real exam is a performance, and performances need rehearsal. Pass4cram's timed test engines stage the Microsoft Administering a SQL Database Infrastructure experience at home, 70-764 practice questions at a time.
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Administering a SQL Database Infrastructure |
| Exam Number: | 70-764 |
| Exam Price: | USD 165 |
| Exam Format: | Multiple choice, Case studies, Performance-based, Scenario-based |
| Passing Score: | 700 / 1000 |
| Real Exam Qty: | 45–60 |
| Certificate Validity Period: | Retired January 31, 2021; validity before retirement: 2 years |
| Related Certifications: | MCSA: Microsoft Dynamics 365 for Operations MCSE: Data Management and Analytics |
| Available Languages: | English |
| Exam Duration: | 120–150 |
| Recommended Training: | Microsoft Learn Microsoft Official Course 20764 |
| Exam Registration: | Microsoft Exam Page Pearson VUE (Historical) |
| 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/ |
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Manage high availability and disaster recovery | 20–25% | - Implement failover cluster instances - Implement AlwaysOn availability groups - Manage database mirroring and log shipping - Plan disaster recovery |
| Topic 2: Manage backup and restore of databases | 20–25% | - Perform backups - Manage backup strategies - Perform restores - Configure recovery models |
| Topic 3: Manage and monitor SQL Server instances | 35–40% | - Manage indexes and statistics - Monitor instance health and performance - Configure automation and alerts - Configure database instances - Troubleshoot performance issues |
| Topic 4: Configure data access and auditing | 20–25% | - Implement encryption - Configure data access - Configure and manage auditing - Configure security permissions |
The 70-764 exam is Microsoft's formal test for the MCSA: SQL 2016 Database Administration certification, a credential at the Associate level. It verifies that you can apply the Microsoft Administering a SQL Database Infrastructure objectives in realistic, scenario-driven situations — the difference between having read about the work and being able to do it. It also connects to a broader certification path covering MCSA: Microsoft Dynamics 365 for Operations, MCSE: Data Management and Analytics, so the study effort compounds beyond a single exam. That is why preparing through realistic questions beats re-reading chapters every time.
The Microsoft Administering a SQL Database Infrastructure blueprint spans 4 domains, led by Manage and monitor SQL Server instances (35–40%), Configure data access and auditing (20–25%), and Manage backup and restore of databases (20–25%). Treat the percentages as a study budget: the heavier the domain, the larger its share of your week. The complete topic list sits in the exam topics section above — build your plan on it, not on guesswork.
The Microsoft Administering a SQL Database Infrastructure exam packs 45–60 questions into 120–150. Turn that ratio into a plan before test day: minutes divided by questions gives your per-item budget, and anything consuming double its budget gets marked and revisited at the end. Practice the rhythm against a real timer — every Pass4cram engine session enforces one — until finishing with spare review time is your default.
Microsoft Administering a SQL Database Infrastructure requires 700 / 1000 to pass, and every attempt costs USD 165 — retakes included, at full price. The smart economics are simple: drill with Pass4cram practice questions until your timed scores clear the mark across several consecutive sessions, then book the seat. Over-preparation is cheaper than re-registration.
Microsoft lists the Microsoft Administering a SQL Database Infrastructure question formats as: Multiple choice, Scenario-based, Case studies, Performance-based. Format shapes strategy — locate the actual question sentence inside long scenario stems before reading details, and double-check every selection on multi-answer items. Pass4cram's 452 practice questions exercise these formats so thoroughly that on exam day, only the content is unfamiliar.
You can sit the 70-764 exam in English. Choose whichever language keeps your comprehension fastest under the clock — slow reading is a hidden tax on every question. Testing in English? Daily sessions with Pass4cram's English 70-764 practice questions double as focused terminology training.
The certification earned through the Microsoft Administering a SQL Database Infrastructure exam stays valid for Retired January 31, 2021; validity before retirement: 2 years. Put the expiry date on your calendar the day you pass, and research the recertification path before it looms — a planned renewal is an errand, while an expired credential is a project. Microsoft sets these policies, so verify the current rules on the official certification page as your window approaches.
All three versions carry the same 452 expert-written questions — you are choosing a study environment, not a content tier:
Plenty of candidates mix formats — the PDF for reading, an engine for timed rehearsal.
Yes. Pass4cram's free Microsoft Administering a SQL Database Infrastructure PDF demo contains real sample questions with complete verified answers, so you can judge the quality yourself. Every purchase includes 365 days of free updates, and renewing after expiry costs 50% of the regular price from your member zone. Inspect first — material this confident has nothing to hide.
Continuously. As Microsoft adjusts the Microsoft Administering a SQL Database Infrastructure exam, our experts supplement and revise the bank to match, and customer feedback flows into the same loop. Updates are free for 365 days in your member zone; watch the New Releases section or the Pass4cram newsletter, and re-verify your version 3-4 days before your exam. Expired products repurchase at 50% off to restart the service.
Our staff are professionally trained and available around the clock: free consultation whenever you need it, one-on-one remote guidance for installation or usage issues, and patient answers to content questions by email. On privacy, the rules are rigid — transactions are secured by McAfee security services, purchase information is never disclosed to third parties, and no spam or telemarketing follows your order.
Delivery first: your Microsoft Administering a SQL Database Infrastructure practice questions are downloadable immediately and emailed within one minute of payment — if 2 hours pass, check spam and contact support. Install on as many computers as you like. If the exam goes wrong, the 100% Money Back Guarantee applies under clear conditions: take the corresponding exam within 60 days of purchase, and if you don't pass, submit a scanned enrollment slip and your official Score Report PDF within 2 days after the exam — full refunds are processed within 7 days. Not eligible: attempts within 3 days of purchase, exams never actually taken, free items, and expired orders; the candidate name must match the payer name. Prefer to keep preparing instead? Exchange for two free products of equal value and keep your update service.
Your company hosts Microsoft SQL Server instances for customers. One customer requires that the SQL Server instance send an email when an alert is generated in the Sales database.
You need to create the alert.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
Correct Answer:

Explanation
The following example adds an e-mail notification for the specified alert (Test Alert).
NOTE: This example assumes that Test Alert already exists and that Francois Ajenstat is a valid operator name.
USE msdb ;
GO
EXEC dbo.sp_add_notification
@alert_name = N'Test Alert',
@operator_name = N'Francois Ajenstat',
@notification_method = 1;
GO
References:
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-notification-transact-s
You have an application that queries a database. Users report that the application is slower than expected.
You discover that several server process identifiers (SPIDs) have PAGELATCH_UP and PAGELATCH_EX waits. The resource descriptions of the SPIDs contains 2:1:1.
You need to resolve the issue.
What should you do?
Correct Answer: B 🗳️
Explanation: Only visible for Pass4cram members. You can sign-up / login (it's free).
You have an SQL Server 2014 server. You plan to create four stored procedures that will use transactions. The stored procedures will be configured as shown in the following table.
You need to recommend an isolation level for each stored procedure. The solution must support the concurrency strategy of each stored procedure and must minimize locks.
What should you recommend?
To answer, drag the appropriate isolation levels to the correct stored procedures. Each isolation level may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Correct Answer:

Explanation
SP1 - SNAPSHOT, SP2 - REPEATABLE READ, SP3 - READ COMMITTED, SP4 - SERIALIZABLE References: SET TRANSACTION ISOLATION LEVEL (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms173763.aspx
Your company has offices in Seattle and Montreal.
The network contains two servers named Server1 and Server2 that have SQL Server 2012 installed. Server1 is located in the Seattle office. Server2 is located in the Montreal office. The latency of the WAN link between the Montreal office and the Seattle office is more than 200 ms.
You plan to implement an AlwaysOn availability group on both servers.
You need to recommend a failover type for the availability group. What should you recommend?
Correct Answer: A 🗳️
You have a SQL Server 2012 database named DB1.
You plan to import a large number of records from a SQL Azure database to DB1.
You need to recommend a solution to minimize the amount of space used in the transaction log during the import operation.
What should you include in the recommendation?
Correct Answer: E 🗳️
Explanation: Only visible for Pass4cram members. You can sign-up / login (it's free).
Viewing page 1 out of 91 pages.
Viewing questions 1-5 out of 452 questions.
Pass4cram confidently stands behind all its offerings by giving Unconditional "No help, Full refund" Guarantee. Since the time our operations started we have never seen people report failure in the 70-764 exam after using our products. With this feedback we can assure you of the benefits that you will get from our products and the high probability of clearing the Microsoft 70-764 exam.
We still understand the effort, time, and money you will invest in preparing for your certification exam, which makes failure in the 70-764 exam really painful and disappointing. Although we cannot reduce your pain and disappointment but we can certainly share with you the financial loss.
This means that if due to any reason you are not able to pass theactual 70-764 exam even after using our product, we will reimburse the full amount you spent on our products. you just need to mail us your score report along with your account information to address listed below within 7 days after your unqualified certificate came out.
Over 37998+ Satisfied Customers
I have passed this 70-764 with full marks.
Mike here, wanted to share amazing experience of mine using Pass4cram dumps. I downloaded demo for70-764 exam and eventually bought 70-764 pdf
Thanks For Everything.
Passed the 70-764 exam last saturday. I can say the 70-764 exam dumps are valid. Thanks Pass4cram.
The study guide materials are still valid. Encountered 5 new questions, but not too difficult. Pass successfully! Cheer!
I can prove that you 70-764 questions are exactly the actual questions.
So I am glad to share my success to you, I passed!
The version of this 70-764 exam materials.
Used Pass4cram real exam stuff to practice for this exam and found it same to same in real exam. This Pass4cram 70-764 pdf + testing engine is still up to date and delivering 91% marked
Passed 70-764 exam after studying your PDF.
The questions and answers from Pass4cram are the latest. With this dump, I passed the exam with ease. I would like to recommend Pass4cram to other candidates.
Excellent practise exam software. I couldn't prepare for a lot of time but the exam practising software helped me pass my 70-764 exam cert with good scores. Thank you Pass4cram.
When I made up my mind to take Microsoft 70-764 certification exam, I hadn't any idea of the exam pattern and its requirements. Thanks to Pass4cram Study Guide that it
I bought these 70-764 exam dumps with new questions added, so fortunately i passed the exam perfectly! It is a new updated version, you can rely on it!
If you want to save you time and money, the 70-764 exam questions are the best choice. I bought them and passed the exam in a short time.
When I planned to take exam MCSA SQL 2016 Professional 70-764 , I was very confused as how to prepare for it. I came across the Pass4cram
Precise and newest information, it is wonderful to find this Pass4cram to provide dumps!
Thank you so much Pass4cram for making my success possible in my 70-764 exam. I could not have done it without your help.
Yesterday I passed my 70-764 test with your study guide.
Pass4cram Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all vce.
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.
If you prepare for the exams using our Pass4cram 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.
Pass4cram 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.