Every unsuccessful attempt at the 070-764 exam costs another full registration fee, not to mention weeks of lost momentum. Before risking that, candidates throughout 2026 are validating their readiness with the Microsoft Administering a SQL Database Infrastructure practice questions from ActualCollection.
Microsoft 070-764 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Administering a SQL Database Infrastructure |
| Exam Number: | 70-764 |
| Passing Score: | 700 / 1000 |
| Exam Duration: | 120–150 |
| Related Certifications: | MCSE: Data Management and Analytics MCSA: Microsoft Dynamics 365 for Operations |
| Available Languages: | English |
| Real Exam Qty: | 45–60 |
| Exam Format: | Scenario-based, Case studies, Performance-based, Multiple choice |
| Certificate Validity Period: | Retired January 31, 2021; validity before retirement: 2 years |
| Exam Price: | USD 165 |
| Recommended Training: | Microsoft Learn Microsoft Official Course 20764 |
| Exam Registration: | Pearson VUE (Historical) Microsoft Exam Page |
| Sample Questions: | DOWNLOAD DEMO |
| 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 070-764 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Configure data access and auditing | 20–25% | - Implement encryption - Configure security permissions - Configure data access - Configure and manage auditing |
| Manage and monitor SQL Server instances | 35–40% | - Configure automation and alerts - Monitor instance health and performance - Configure database instances - Troubleshoot performance issues - Manage indexes and statistics |
| Manage high availability and disaster recovery | 20–25% | - Implement AlwaysOn availability groups - Implement failover cluster instances - Plan disaster recovery - Manage database mirroring and log shipping |
| Manage backup and restore of databases | 20–25% | - Configure recovery models - Manage backup strategies - Perform restores - Perform backups |
Your Microsoft Administering a SQL Database Infrastructure Questions, Answered
Microsoft Administering a SQL Database Infrastructure is an official Microsoft exam, registered under the code 070-764. A passing score earns you the MCSA: SQL 2016 Database Administration certification, positioned at the Associate level. The credential also connects to MCSA: Microsoft Dynamics 365 for Operations, MCSE: Data Management and Analytics, so it can anchor a broader certification path. Because Microsoft designs its exams around real job tasks, holding this certification signals practical skill rather than memorized theory.
Candidates face 45–60 questions inside a 120–150 window on the Microsoft Administering a SQL Database Infrastructure exam. That ratio leaves little slack, which is why pacing deserves as much practice as the content itself. Learn to budget your minutes, park stubborn questions instead of wrestling them, and rehearse under a real clock: a few timed runs in the ActualCollection test engine will make the official time limit feel routine rather than threatening.
The passing bar for Microsoft Administering a SQL Database Infrastructure is set at 700 / 1000, and registering for the exam officially costs USD 165. There is no reduced price for a second try: fail, and you pay USD 165 in full again. That makes honest self-testing the cheapest insurance available, so hold off on booking until your ActualCollection practice scores sit clearly above the passing line, attempt after attempt.
No mandatory prerequisites; recommended experience with SQL Server installation, configuration, and maintenance
Vendor policies are revised from time to time, so double-check the eligibility details before registering on the official exam page.
Sign-up for the Microsoft Administering a SQL Database Infrastructure exam is handled through the official registration channels listed here.
One practical detail: the exam is delivered Proctored onsite at Pearson VUE centers or online proctored; retired, no longer available, so plan your logistics accordingly.
Microsoft recommends the following training resources for candidates working toward Microsoft Administering a SQL Database Infrastructure.
Training gives you the theory, but repetition locks it in. Pair any course with the 452 practice questions in the ActualCollection 070-764 package and you will know exactly how each topic shows up on exam day.
Absolutely. A free PDF demo of the Microsoft Administering a SQL Database Infrastructure questions is available at ActualCollection, so you can inspect the quality and formatting before any money changes hands. Once you buy, updates are free for 365 days, and when that period runs out you can extend the update service at 50% off the regular price.
ActualCollection offers a 100% money-back guarantee with specific conditions. If you take the Microsoft Administering a SQL Database Infrastructure exam within 60 days of purchase and fail, you may claim a full refund, provided the exam matches your product. Sitting the exam within 3 days of purchase disqualifies a claim, as do downloaded-but-unused products, free materials, and expired orders; the candidate name must also match the payer name. To file, submit a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and the claim is processed within 7 days. If you prefer, you can skip the refund and instead receive two other exam products of equal value at no charge while keeping the update service on your original purchase.
As for delivery: it is immediate. Your files become downloadable the moment payment completes and are also emailed to you within one minute. If nothing shows up within 2 hours, contact customer service. You may install the software on an unlimited number of computers.
Microsoft Administering a SQL Database Infrastructure is divided into 4 official domains. Among the headline areas are Manage backup and restore of databases (20–25%), Configure data access and auditing (20–25%), and Manage high availability and disaster recovery (20–25%). Scroll up to the exam topics section for the full breakdown, and use it as a checklist: any line you cannot confidently explain deserves another round of practice.
Microsoft Administering a SQL Database Infrastructure Sample Questions:
Question 1
General Overview
You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The company develops software applications custom designed to meet customer requirements.
Requirements Leafield Solutions has been asked by a customer to develop a web-based Enterprise Resource Planning and Management application. The new application will eventually replace a desktop application that the customer is currently using. The current application will remain in use while the users are trained to use the new webbased application.
You need to design the SQL Server and database infrastructure for the web-based application.
Databases
You plan to implement databases named Customers, Sales, Products, Current_Inventory, and TempReporting.
The Sales database contains a table named OrderTotals and a table named SalesInfo.
A stored procedure named SPUpdateSalesInfo reads data in the OrderTotals table and modifies data in the SalesInfo table.
The stored procedure then reads data in the OrderTotals table a second time and makes further changes to the information in the SalesInfo table.
The Current_Inventory database contains a large table named Inv_Current. The Inv_Current table has a clustered index for the primary key and a nonclustered index. The primary key column uses the identity property.
The data in the Inv_Current table is over 120GB in size. The tables in the Current_Inventory database are accessed by multiple queries in the Sales database.
Another table in the Current_Inventory database contains a self-join with an unlimited number of hierarchies.
This table is modified by a stored procedure named SPUpdate2.
An external application named ExternalApp1 will periodically query the Current_Inventory database to generate statistical information. The TempReporting database contains a single table named GenInfo.
A stored procedure named SPUPdateGenInfo combines data from multiple databases and generates millions of rows of data in the GenInfo table.
The GenInfo table is used for reports.
When the information in GenInfo is generated, a reporting process reads data from the Inv_Current table and queries information in the GenInfo table based on that data.
The GenInfo table is deleted after the reporting process completes. The Products database contains tables named ProductNames and ProductTypes.
Current System
The current desktop application uses data stored in a SQL Server 2005 database named DesABCopAppDB.
This database will remain online and data from the Current_Inventory database will be copied to it as soon as data is changed in the Current_Inventory database.
SQL Servers
A new SQL Server 2012 instance will be deployed to host the databases for the new system. The databases will be hosted on a Storage Area Network (SAN) that provides highly available storage.
Design Requirements
Your SQL Server infrastructure and database design must meet the following requirements:
* Confidential information in the Current_ Inventory database that is accessed by ExternalApp1 must be securely stored.
* Direct access to database tables by developers or applications must be denied.
* The account used to generate reports must have restrictions on the hours when it is allowed to make a connection.
* Deadlocks must be analyzed with the use of Deadlock Graphs.
* In the event of a SQL Server failure, the databases must remain available.
* Software licensing and database storage costs must be minimized.
* Development effort must be minimized.
* The Tempdb databases must be monitored for insufficient free space.
* Failed authentication requests must be logged.
* Every time a new row is added to the ProductTypes table in the Products database, a user defined function that validates the row must be called before the row is added to the table.
* When SPUpdateSalesInfo queries data in the OrderTotals table the first time, the same rows must be returned along with any newly added rows when SPUpdateSalesInfo queries data in the OrderTotals table the second time.
You need to configure a synchronization solution to copy data from the Current_Inventory database the DesABCopAppDB database.
What should you configure?
A. Incremental Backups
B. Database Mirroring.
C. Transactional Replication.
D. Snapshot Replication.
Question 2
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a data warehouse that stored sales data. One fact table has 100 million rows.
You must reduce storage needs for the data warehouse.
You need to implement a solution that uses column-based storage and provides real-time analytics for the operational workload.
Solution: You remove all clustered indexes, sort the transactions in the table, and create a clustered index on the table, so that the table is not a heap.
Does the solution meet the goal?
A. No
B. Yes
Question 3
You plan to deploy SQL Server 2012. You must create two tables named Table 1 and Table 2 that will have the following specifications:
* Table1 will contain a date column named Column1 that will contain a null value approximately 80 percent of the time.
* Table2 will contain a column named Column2 that is the product of two other columns in Table2.
Both Table1 and Table2 will contain more than 1 million rows.
You need to recommend which options must be defined for the columns. The solution must minimize the storage requirements for the tables.
Which options should you recommend? To answer, drag the appropriate options to the correct column in the answer area.
Question 4
You administer two Microsoft SQL Server 2012 servers.
Each server resides in a different, untrusted domain.
You plan to configure database mirroring.
You need to be able to create database mirroring endpoints on both servers.
What should you do?
A. Use a database certificate.
B. Configure the SQL Server service account to use Local System.
C. Configure the SQL Server service account to use Network Service.
D. Use a server certificate.
Question 5
General Overview
You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The company develops software applications custom designed to meet customer requirements.
Requirements Leafield Solutions has been asked by a customer to develop a web-based Enterprise Resource Planning and Management application. The new application will eventually replace a desktop application that the customer is currently using. The current application will remain in use while the users are trained to use the new webbased application.
You need to design the SQL Server and database infrastructure for the web-based application.
Databases
You plan to implement databases named Customers, Sales, Products, Current_Inventory, and TempReporting.
The Sales database contains a table named OrderTotals and a table named SalesInfo.
A stored procedure named SPUpdateSalesInfo reads data in the OrderTotals table and modifies data in the SalesInfo table.
The stored procedure then reads data in the OrderTotals table a second time and makes further changes to the information in the SalesInfo table.
The Current_Inventory database contains a large table named Inv_Current. The Inv_Current table has a clustered index for the primary key and a nonclustered index. The primary key column uses the identity property.
The data in the Inv_Current table is over 120GB in size. The tables in the Current_Inventory database are accessed by multiple queries in the Sales database.
Another table in the Current_Inventory database contains a self-join with an unlimited number of hierarchies.
This table is modified by a stored procedure named SPUpdate2.
An external application named ExternalApp1 will periodically query the Current_Inventory database to generate statistical information. The TempReporting database contains a single table named GenInfo.
A stored procedure named SPUPdateGenInfo combines data from multiple databases and generates millions of rows of data in the GenInfo table.
The GenInfo table is used for reports.
When the information in GenInfo is generated, a reporting process reads data from the Inv_Current table and queries information in the GenInfo table based on that data.
The GenInfo table is deleted after the reporting process completes. The Products database contains tables named ProductNames and ProductTypes.
Current System
The current desktop application uses data stored in a SQL Server 2005 database named DesABCopAppDB.
This database will remain online and data from the Current_Inventory database will be copied to it as soon as data is changed in the Current_Inventory database.
SQL Servers
A new SQL Server 2012 instance will be deployed to host the databases for the new system. The databases will be hosted on a Storage Area Network (SAN) that provides highly available storage.
Design Requirements
Your SQL Server infrastructure and database design must meet the following requirements:
* Confidential information in the Current_ Inventory database that is accessed by ExternalApp1 must be securely stored.
* Direct access to database tables by developers or applications must be denied.
* The account used to generate reports must have restrictions on the hours when it is allowed to make a connection.
* Deadlocks must be analyzed with the use of Deadlock Graphs.
* In the event of a SQL Server failure, the databases must remain available.
* Software licensing and database storage costs must be minimized.
* Development effort must be minimized.
* The Tempdb databases must be monitored for insufficient free space.
* Failed authentication requests must be logged.
* Every time a new row is added to the ProductTypes table in the Products database, a user defined function that validates the row must be called before the row is added to the table.
* When SPUpdateSalesInfo queries data in the OrderTotals table the first time, the same rows must be returned along with any newly added rows when SPUpdateSalesInfo queries data in the OrderTotals table the second time.
You need to recommend a solution to meet the design requirement of logging all failed authentication requests.
What should you recommend?
A. C2 Audit Mode
B. Logon Triggers.
C. Login Auditing.
D. Object Access Auditing
Solutions:
| Question 1 Answer: C | Question 2 Answer: B | Question 3 Answer: Only visible for members | Question 4 Answer: D | Question 5 Answer: C |
Toby 
Maria 
Adelaide 
Everley 
Leona 
Jacqueline 
Lionel 
Gladys 
Audrey 
Vincent 
Michell 
Norman 
Adonis 
Jo 
Perry 
Doris 
Merlin 
Laurel 
Roxanne 
Elliot 
