Microsoft 70-764 : Administering a SQL Database Infrastructure

Pass 70-764 Exam Cram

Exam Code: 70-764

Exam Name: Administering a SQL Database Infrastructure

Updated: Oct 26, 2026

Q & A: 452 Questions and Answers

Already choose to buy "PDF"
Price: $59.99 

High quality 70-764 guarantee you to pass 70-764

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.

Microsoft 70-764 Exam Overview:
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:Free Download Pass 70-764 Exam Cram
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/
Microsoft 70-764 Exam Syllabus Topics:
SectionWeightObjectives
Topic 1: Manage high availability and disaster recovery20–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 databases20–25%- Perform backups
- Manage backup strategies
- Perform restores
- Configure recovery models
Topic 3: Manage and monitor SQL Server instances35–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 auditing20–25%- Implement encryption
- Configure data access
- Configure and manage auditing
- Configure security permissions

70-764 FAQ for Candidates Who Mean It

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:

  • PDF version — printable, expert-prepared, instantly downloadable, readable anywhere and anytime. Includes 365 days of free updates and a free demo.
  • Desktop Test Engine — Windows software simulating the real exam environment, with two practice modes, offline access, and unlimited installations.
  • Online Test Engine — runs in any browser on Windows, Mac, Android, and iOS, with test history and performance review built in.

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.

Microsoft Administering a SQL Database Infrastructure Sample Questions:
Question #1

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.

Reveal Solution  Discussion  0

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

Question #2

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?

  • A. Reduces the number of table variales used in the application.
  • B. Move the database files to SSD storage.
  • C. Use identity integers as primary key fields in the tables.
  • D. Reduce the Fill factor of all the clustered indexes.
Reveal Solution  Discussion  0

Correct Answer: B  🗳️

Explanation: Only visible for Pass4cram members. You can sign-up / login (it's free).

Question #3

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.

Reveal Solution  Discussion  0

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

Question #4

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?

  • A. Asynchronous manual failover
  • B. Asynchronous automatic failover
  • C. Synchronous automatic failover
  • D. Synchronous manual failover
Reveal Solution  Discussion  0

Correct Answer: A  🗳️

Question #5

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?

  • A. a new partitioned table
  • B. the full recovery model
  • C. a new filegroup
  • D. a new log file
  • E. the bulk-logged recovery model
Reveal Solution  Discussion  0

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.

1%
No help, Full refund!

No help, Full refund!

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.

What Clients Say About Us

I have passed this 70-764 with full marks.

Eunice Eunice       4.5 star  

Mike here, wanted to share amazing experience of mine using Pass4cram dumps. I downloaded demo for70-764 exam and eventually bought 70-764 pdf

Kim Kim       5 star  

Thanks For Everything.

Prescott Prescott       4 star  

Passed the 70-764 exam last saturday. I can say the 70-764 exam dumps are valid. Thanks Pass4cram.

Jerome Jerome       4.5 star  

The study guide materials are still valid. Encountered 5 new questions, but not too difficult. Pass successfully! Cheer!

Harvey Harvey       5 star  

I can prove that you 70-764 questions are exactly the actual questions.

Renata Renata       4 star  

So I am glad to share my success to you, I passed!
The version of this 70-764 exam materials.

Venus Venus       5 star  

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

Bard Bard       4.5 star  

Passed 70-764 exam after studying your PDF.

Addison Addison       4 star  

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.

Jennifer Jennifer       5 star  

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.

Clara Clara       5 star  

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

Morton Morton       5 star  

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!

Agatha Agatha       5 star  

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.

Harriet Harriet       4.5 star  

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

Winfred Winfred       5 star  

Precise and newest information, it is wonderful to find this Pass4cram to provide dumps!

Breenda Breenda       5 star  

Thank you so much Pass4cram for making my success possible in my 70-764 exam. I could not have done it without your help.

Earl Earl       4.5 star  

Yesterday I passed my 70-764 test with your study guide.

Yedda Yedda       4.5 star  

LEAVE A REPLY

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

Why Choose Pass4cram

Quality and Value

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.

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

Try Before Buy

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.

Our Clients

amazon
centurylink
earthlink
marriot
vodafone
comcast
bofa
charter
vodafone
xfinity
timewarner
verizon