Exam Name: Administering a SQL Database Infrastructure
Certification Provider: Microsoft
Corresponding Certification: MCSA SQL 2016
Over 66114+ Satisfied Customers
Instant Download Microsoft : 70-764
Check Updated on: Aug 30, 2026
No. of Questions: 452 Questions & Answers with Exam Engine
Download Limit: Unlimited
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.)
100% Money Back Guarantee
2Pass4sure has an unprecedented 99.6% first time pass rate among our customers. 
We're so confident of our products that we provide no hassle product exchange.
- Best exam practice material
- Three formats are optional
- 10+ years of excellence
- 365 Days Free Updates
- Learn anywhere, anytime
- 100% Safe shopping experience
70-764 Desktop Test Engine
- Installable Software Application
- Simulates Real 70-764 Exam Environment
- Builds 70-764 Exam Confidence
- Supports MS Operating System
- Two Modes For 70-764 Practice
- Practice Offline Anytime
- Software Screenshots
- Total Questions: 452
- Updated on: Aug 30, 2026
- Price: $69.00
70-764 PDF Practice Q&A's
- Printable 70-764 PDF Format
- Prepared by Microsoft Experts
- Instant Access to Download 70-764 PDF
- Study Anywhere, Anytime
- 365 Days Free Updates
- Free 70-764 PDF Demo Available
- Download Q&A's Demo
- Total Questions: 452
- Updated on: Aug 30, 2026
- Price: $69.00
70-764 Online Test Engine
- Online Tool, Convenient, easy to study.
- Instant Online Access 70-764 Dumps
- Supports All Web Browsers
- 70-764 Practice Online Anytime
- Test History and Performance Review
- Supports Windows / Mac / Android / iOS, etc.
- Try Online Engine Demo
- Total Questions: 452
- Updated on: Aug 30, 2026
- Price: $69.00
The Microsoft Administering a SQL Database Infrastructure credential carries weight in the industry because the vendor sets a high bar for passing it. 2Pass4sure helps you clear that bar with 452 carefully prepared 70-764 practice questions reviewed by subject-matter experts.
Microsoft 70-764 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Administering a SQL Database Infrastructure |
| Exam Number: | 70-764 |
| Exam Price: | $165 USD (varies by country) |
| Certificate Validity Period: | Retired (certification no longer offered) |
| Real Exam Qty: | 40-60 (varies) |
| Related Certifications: | MCSA: SQL 2016 Database Administration MCSE: Data Management and Analytics (retired) |
| Exam Format: | Best answer selection, Case studies, Multiple choice, Short answer |
| Passing Score: | 700 (on a 1000 scale) |
| Exam Duration: | 120-150 |
| Available Languages: | Spanish, English, Japanese, Korean, German, Simplified Chinese, French |
| Recommended Training: | Microsoft Learn SQL Server Training SQL Server Administration Documentation |
| Exam Registration: | Microsoft Certification Portal Pearson VUE Exam Registration |
| Sample Questions: | DOWNLOAD DEMO |
| Exam Way: | Online proctored or test center (Pearson VUE) |
| Pre Condition: | No formal prerequisite required, but experience with SQL Server administration is recommended. Typically part of the MCSA SQL 2016 certification path. |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/70-764/ |
Microsoft 70-764 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Manage SQL Server infrastructure | - Install and configure SQL Server
|
| Topic 2: Monitor and troubleshoot SQL Server | - Troubleshooting performance issues
|
| Topic 3: Maintain and optimize databases | - Index management
|
| Topic 4: Plan and implement data storage | - Manage databases and files
|
| Topic 5: Manage high availability and disaster recovery | - High availability solutions
|
Common Questions About the Microsoft Administering a SQL Database Infrastructure Exam
The Microsoft Administering a SQL Database Infrastructure (exam code 70-764) is the exam you pass to earn the MCSA: SQL 2016 Database Administration (Retired) certification, a credential at the Associate level. It is also connected with related credentials such as MCSA: SQL 2016 Database Administration, MCSE: Data Management and Analytics (retired). If you are mapping out a certification path with Microsoft, this exam is a milestone worth planning around.
The 70-764 exam includes 40-60 (varies) questions, and you have 120-150 to complete them. With that many questions on the clock, pacing is part of the challenge: divide your time into rough blocks as you go, and flag the items that stall you so you can circle back at the end instead of burning minutes on a single question. A week or two before your exam date, sit at least one full timed session in the 2Pass4sure test engine under the same time limit, so the pace feels familiar rather than frantic on the day.
You need 700 (on a 1000 scale) to pass the 70-764 exam, and the official registration fee is $165 USD (varies by country). That fee is due again in full for every retake, which makes thorough preparation the cheaper investment by far. Before you book your seat, test yourself with the 2Pass4sure practice questions until you are scoring comfortably above the passing mark on a consistent basis — it is the simplest way to avoid paying for the same exam twice.
No formal prerequisite required, but experience with SQL Server administration is recommended. Typically part of the MCSA SQL 2016 certification path.
Eligibility rules can be adjusted by Microsoft over time, so before you register, confirm the current requirements on the official exam page: view the official 70-764 exam information.
You can book the 70-764 exam through the official registration channels below:
How the exam is taken: Online proctored or test center (Pearson VUE).
Microsoft lists the following official training options for candidates preparing for this exam:
Once you have worked through the training, measure your readiness with the 452 practice questions from 2Pass4sure — they show you exactly which topics still need attention before you book the exam.
Yes. 2Pass4sure offers a free PDF demo of the 70-764 practice questions, so you can judge the quality of the material firsthand before paying anything. Every purchase also includes 365 days of free updates — if Microsoft changes the exam during that year, your material changes with it. And when the free update period expires, you can extend it at a 50% discount from within your member zone.
Every 70-764 purchase at 2Pass4sure is backed by a 100% Money Back Guarantee: if you take the corresponding exam within 60 days of your purchase and do not pass, you can apply for a full refund. The guarantee has clear conditions — it does not apply if you sit the exam within 3 days of purchase, if you downloaded the material but never actually took the exam, or to free materials and expired orders, and the candidate name must match the payer name. To file a claim, send a scan of your exam enrollment slip together with your official Score Report PDF within 2 days of the exam; claims are processed within 7 days. If you would rather not take a refund, you can exchange the product instead and receive two additional exam preparation products of equal value for free, while your original product keeps its update service. Delivery itself is instant: your material is available for download right after payment and is also sent to your email within one minute — if it has not arrived within 2 hours, contact our customer service. There is no limit on how many computers you can install it on.
The official Microsoft Administering a SQL Database Infrastructure outline divides the exam content into 5 main domains. The first three are:
- Manage high availability and disaster recovery
- Manage SQL Server infrastructure
- Maintain and optimize databases
That is only the headline view — scroll back up to the Exam Topics section on this page for the complete domain-by-domain breakdown before you plan your study schedule.
Microsoft Administering a SQL Database Infrastructure Sample Questions:
Question 1
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
A company has a Microsoft SQL Server environment in Microsoft Azure. The databases are stored directly in Azure blob storage. The company uses a complex backup process.
You need to simplify the backup process. Future restores should not require differential or multiple incremental logs to perform a restore.
You need to design a backup solution for the SQL Server instances.
Which option should you use?
A. file snapshot backup
B. backup encryption
C. SQL Server backup to URL
D. back up and truncate the transaction log
E. mirrored backup media sets
F. tail-log backup
G. SQL Server Managed Backup to Azure
H. backup compression
Question 2
You are deploying a Microsoft Azure SQL Database environment:
You need to configure the environment to meet the following requirements:
* Access to databases must be logged.
* Email alerts must be sent to the database administrator if anomalous activity is detected.
What should you do? To answer, drag the appropriate solutions to the correct requirements. Each solution 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.
Question 3
You administer a Microsoft SQL Server 2016 server that hosts a transactional database and a reporting database.
The transactional database is updated through a web application and is operational throughout the day.
The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table:
The differential backup of the reporting database fails.
Then, the reporting database fails at 14:00 hours.
You need to ensure that the reporting database is restored.
You also need to ensure that data loss is minimal.
What should you do?
A. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
B. Restore the latest full backup.
C. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
D. Perform a page restore.
E. Perform a partial restore.
F. Restore the latest full backup. Then, restore the latest differential backup.
G. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
H. Perform a point-in-time restore.
Question 4
You plan to install a Microsoft SQL Server 2016 instance.
The instance will support a database that has the following requirements:
* Store Excel workbooks on the file system.
* Access the workbooks through Transact-SQL.
* Include the workbooks in database backups.
* During installation, you need to ensure that the requirements will be met.
Which feature should you use?
A. SQL Server Integration Services (SSIS)
B. FILESTREAM
C. OpenXML
D. Excel Services
Question 5
General Overview
You are the Senior Database Administrator (DBA) for a manufacturing company named Fairstone Manufacturing.
Fairstone Manufacturing is based in the New York area. The company has two offices: a main office in the city and a branch office just outside the city. The company has four factories where their products are manufactured. Two factories are in the New York area and the other two factories are in Washington.
Network Connectivity
The two offices are connected by a 10 Mbps dedicated WAN link.
SQL Server Environment
The main office has four SQL Server 2012 Standard Edition servers named MainDB1, MainDB2, MainDB3 and MainDB4. The branch office has two SQL Server 2012 Standard Edition servers named BranchDB1 and BranchDB2. The main office has a Development department. All databases used by the Development department are hosted on MainDB3 and MainDB4. MainDB1 and MainDB2 host the following databases:
Products
Manufacturing
Sales
HR
Customers
DailyReportsTemp
BranchDB1 and BranchDB2 host the same databases as MainDB1 and MainDB2. The DailyReportsTemp database is a temporary database that is recreated every day and used for reporting purposes.
One of the tables in the Customer database lists all the customers. Another table linked to the customers table contains a list of classifications for the customers. The classifications are Hot, Warm and Cold based on the number of orders placed by the customers in the last year. The customers are classified according to the following criteria:
Hot - Over 100 orders placed in a year.
Warm - Between 50 and 100 orders placed in a year.
Cold - Under 50 orders placed in a year.
Stored Procedures
Three tables in the Manufacturing database are modified by a stored procedure named ManProc1.
A segment of code from ManProc1 is as follows:
The same three tables are also modified by a stored procedure named ManProc2. A segment of code from ManProc2 is as follows:
A product list in the Products database is updated using information from tables in the Manufacturing database by a stored procedure named ProductUpdateProc. Locks on tables in the Manufacturing database often cause ProductUpdateProc to take a long time to complete.
A list of manufacturing processes required to create each product is stored in tables in the Manufacturing database and updated by a stored procedure named ProcessUpdateProc. The ProcessUpdateProc stored procedure contains several UPDATE statements. The UPDATE statements are configured to be called in a specific order. The ProcessUpdateProc stored procedure continues to run in the event of a failure of one of the UPDATE statements.
This can cause inaccurate results in the manufacturing process list.
Sales Director Statement
The Sales Director has made the following observations about the current database design:
* The current customer classification system needs to be changed.
* Currently the customers are classified by the number of orders placed in the last year.
* This information is an unreliable guide as it does not take in to account the size of the orders.
* I would suggest a trial run of a classification system based on the revenue generated by the orders placed in the last year.
* We may add more than the current three classification types in future.
* We should have a method of recording changes to the classifications.
IT Manager Statement
The IT Manager has listed the following requirements for the SQL Server and database environment:
* We need to provide a group of users from the IT and Manufacturing departments the minimum administrative rights to view database information and server state for the Manufacturing database on MainDB1.
* The Sales database takes too long to back up due to the large amount of historical sales order data in the database. We need to reduce the backup time for this database.
* The DailyReportsTemp database takes four hours to back up. We need to be able to recover the DailyReportsTemp database in less than one hour if the database storage hardware fails.
* We need to be able to immediately return the Manufacturing database to its previous state if the ProcessUpdateProc stored procedure fails to update the process information correctly.
* I also want the ProcessUpdateProc stored procedure to stop running in the event of a failure of one of the UPDATE statements.
* IT Administrators need to be able to monitor the disk space used on the SQL Servers by running real-time reports on the disk usage.
* The Developers would like to install second instances of SQL Server on MainDB3 and MainDB4.
* They would like to assign each instance to specific processors on the SQL Servers.
You need to enable the Developers to assign SQL Server instances on MainDB3 and MainDB4 to specific processors on the servers. What should you configure?
A. Windows System Resource Manager (WSRM)
B. Resource Governor
C. A Maintenance Plan
D. Processor Affinity
Solutions:
| Question 1 Answer: A | Question 2 Answer: Only visible for members | Question 3 Answer: B | Question 4 Answer: B | Question 5 Answer: D |
982 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)
Good news from Kevin.Good 70-764 study materials.
Ernest
I passed today, just wanted to say that the 70-764 materials are very authentic and exactly what is required for the training.
Harry
Your site was my first choice for exam preparation, as a lot of my friends suggested I take the 70-764 exam.
Lynn
2Pass4sure offers wide range of preparation products of 70-764 exam, which gives professionals the long lasting knowledge in order to excel in the industry. Thank you so much and please keep up the good work.
Sid
After purchase for the 70-764 study guide,I recived it , studied then I took the 70-764 exam and passed. I am very pleased with this choice!
Francis
Your questions and answers are up-to-date and really helped me a lot, thank you.
Nicholas
Passed 70-764 exam with latest exam dumps Yesterday, I can have a good holiday now.
James
Very nice exam dump, about 93% of the questions have correct answers.
Georgia
The dump is helpful. With your Microsoft dump, I got my certification successfully last week! Thank u 2Pass4sure!
Henry
Thanks a lot for your Microsoft dumps help.
Xavier
As long as you read the questions of all 70-764 practice file and learn the format behind it, you will pass for sure for they are very valid. I completed this exam last Monday. Good luck to you guys!
Venus
Thank you so much for your help 2Pass4sure. I have completed my 70-764 exam preparation with your 70-764 practice questions assistance.
Helen
2Pass4sure 70-764 real exam questions cover all the knowledge points of real test.
Jessica
Amlost all 70-764 exam questions and the content are exact with the real exam. I passed with a good mark. It is a good learning material, I believe you will pass for sure as long as you use it!
Frederica
wow, wonderful 2Pass4sure 70-764 real exam questions.
Frederic
Related Exams
Instant Download 70-764
After Payment, our system will send you the products you purchase in mailbox in a minute after payment. If not received within 2 hours, please contact us.
365 Days Free Updates
Free update is available within 365 days after your purchase. After 365 days, you will get 50% discounts for updating.
Money Back Guarantee
Full refund if you fail the corresponding exam in 60 days after purchasing. And Free get any another product.
Security & Privacy
We respect customer privacy. We use McAfee's security service to provide you with utmost security for your personal information & peace of mind.
