Free demo, three versions, credit card payment protected, delivery in minutes, replies within two hours, and a written refund policy: TestPassed makes Microsoft Administering a SQL Database Infrastructure preparation a worry-free purchase for 2026 070-764 candidates.
Microsoft 070-764 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Administering a SQL Database Infrastructure |
| Exam Number: | 70-764 |
| Passing Score: | 700 (scaled score) |
| Real Exam Qty: | 40–60 (approx.) |
| Available Languages: | English, Spanish, German, Japanese, Korean, Chinese (Simplified) |
| Certificate Validity Period: | Exam retired and replaced by role-based certifications (note: retired January 2021, but information maintained for reference) |
| Related Certifications: | MCSE: Data Management and Analytics MCSA: SQL 2016 Database Administration |
| Exam Duration: | 120–150 |
| Exam Price: | USD 165 (approx.) |
| Exam Format: | Multiple choice, Scenario-based questions |
| Sample Questions: |  |
| Exam Way: | Onsite at testing centers (e.g., Pearson VUE) or through approved online proctoring (availability may vary by region and retirement status) |
| Pre Condition: | Recommended experience in SQL Server installation, configuration, maintenance, and database administration |
| Official Syllabus URL: | https://learn.microsoft.com/learn/certifications/exams/70-764 |
Microsoft 070-764 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Configure data access and auditing | 20–25% | - Configure data access and permissions
|
| Topic 2: Manage and monitor SQL Server instances | 35–40% | - Manage indexes and statistics
|
| Topic 3: Manage backup and restore of databases | 20–25% | - Restore databases
|
| Topic 4: Manage high availability and disaster recovery | 20–25% | - Implement disaster recovery
|
070-764 Exam: The FAQ Candidates Actually Need
Microsoft Administering a SQL Database Infrastructure is an official Microsoft certification exam, listed under the code 070-764. Passing it earns you the MCSA SQL 2016 certification, positioned at the Associate level. It also connects to MCSA: SQL 2016 Database Administration, MCSE: Data Management and Analytics. For anyone aiming at a leadership track in IT, this credential is one of the clearest markers of verified skill.
Passing Microsoft Administering a SQL Database Infrastructure takes 700 (scaled score), and the official registration fee is USD 165 (approx.). Retakes charge the full USD 165 (approx.) again, which is why accuracy in preparation matters more than volume. Validate your readiness with repeated TestPassed practice scores above the requirement before committing to a date.
The Microsoft Administering a SQL Database Infrastructure exam contains 40–60 (approx.) questions to answer within 120–150. The SOFT engine from TestPassed imitates the real test scene on your computer and uses special methods to help you master questions and answers, so the official time limit becomes a practiced routine rather than a surprise.
Recommended experience in SQL Server installation, configuration, maintenance, and database administration
Vendor requirements are revised periodically, so confirm the current conditions before registering via the official exam page.
Three versions share the same verified content: the PDF prints unlimited copies for paper study, the SOFT engine imitates the real test scene on Windows PCs, and the APP version runs on all electronic products, which is why the majority of examinees choose it. A free demo lets you try before deciding, and after purchase updates are free for 365 days, extendable afterward at a 50% discount.
Worry-free shopping means a 100% money-back guarantee with stated conditions. Take the Microsoft Administering a SQL Database Infrastructure exam within 60 days of purchase; if you fail, you may claim a full refund, provided the exam matches your product. Attempts within 3 days of purchase are ineligible, as are downloaded-but-unused products, free materials, and expired orders; the candidate name must match the payer name. Submit a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and claims are processed within 7 days. Alternatively, exchange for two other exam products of equal value, free, keeping the update service on your original purchase.
Delivery is immediate: files unlock for download at payment and are emailed to you within one minute. If nothing arrives within 2 hours, check spam and contact our 7/24 customer attendants, who reply within two hours. Installation is unlimited, and credit card payment keeps your money safe.
Microsoft Administering a SQL Database Infrastructure is structured into 4 official domains. The leading ones are Manage and monitor SQL Server instances (35–40%), Manage backup and restore of databases (20–25%), and Manage high availability and disaster recovery (20–25%). The full topic breakdown appears above; accurate preparation starts with an accurate map.
Microsoft Administering a SQL Database Infrastructure Sample Questions:
You administer a single server that contains a Microsoft SQL Server 2016 default instance.
You plan to install a new application that requires the deployment of a database on the server. The application login requires sysadmin permissions.
You need to ensure that the application login is unable to access other production databases.
What should you do?
- A. Use the SQL Server default instance and configure an affinity mask.
- B. Install a new default SQL Server instance on the server.
- C. Install a new named SQL Server instance on the server.
- D. Use the SQL Server default instance and enable Contained Databases.
Correct Answer: C 🗳️
Explanation: Only visible for TestPassed members. You can sign-up / login (it's free).
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
You maintain a Microsoft SQL Server instance that contains the following databases SalesDb1, SalesDb2, and SalesDb3. Each database has tabled named Products and Sales. The following table shows the configuration of each database.
The backup strategies for each database are described in the following table.
Each full or differential backup operation writes into a new file and uses a different sequence number. You observe the following database corruption issues.
SalesDb3 reports a number of database corruption issues related to error 823 and 824 when reading data pages.
You must display the following information about the corrupted pages:
* database name
* impacted file id
* impacted file physical name
* impacted page id
* event type that identifies the error type
* error count
Users report performance issues when they run queries against SalesDb2. You plan to monitor query statistics and execution plans for SalesDb2 by using Query Store. The monitoring strategy must meet the following requirements:
* Perform automatic data cleanup when query store disk usage reaches 500 megabyte (MB).
* Capture queries based on resource consumption.
* Use a stale query threshold value of 60 days.
The query optimizer generates suboptimal execution plans for a number of queries on the Sales table in SalesDb2. You will create a maintenance plan that updates statistics for the table. The plan should only update statistics that were automatically created and have not been updated for 30 days. The update should be based on all data in the table.
You need to write the query the maintenance plan will use to update the statistics.
Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
Correct Answer:
Explanation
Step 1: Use SalesDB2...
We specify the specific database SalesDB2, not the master.
Step 2:
Step 3:
From scenario: The plan should only update statistics that were automatically created and have not been updated for 30 days.
Step 4:
Declare the curser using WITH FULLSCAN.
References:
https://solutioncenter.apexsql.com/how-to-automate-and-schedule-sql-server-index-defragmentation/
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 Microsoft Azure SQL database that has Blob Auditing configured.
You need to review the audit logs.
Solution: From Microsoft SQL Server Management Studio, you connect to the database, and then you execute the following statement.
Does this meet the goal?
- A. Yes
- B. No
Correct Answer: B 🗳️
Explanation: Only visible for TestPassed members. You can sign-up / login (it's free).
Your network contains an Active Directory domain that has two groups named Group1 and Group2.
The domain contains two SQL Server instances named SQLDev and SQLProd. Each SQL Server instance has access to various storage media.
The SQL Server instances have a database that contains a table named Table1. Table1 contains a column named Column1.
The value for Column1 can be either Value1 or Value2.
You need to recommend a solution to ensure that users in Group1 can retrieve only rows from Column1 that contain the value of Value1.
What should you recommend?
- A. A dynamic management view
- B. Snapshot isolation
- C. Filegroups
- D. User-defined views
Correct Answer: D 🗳️
Explanation: Only visible for TestPassed members. You can sign-up / login (it's free).
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 generate a new certificate on new instance.
Does the solution meet the goal?
- A. Yes
- B. No
Correct Answer: B 🗳️
Explanation: Only visible for TestPassed members. You can sign-up / login (it's free).
Valerie 
Helen 
Eric 
Margaret 
Henry 
Baron 
Carr 
Aubrey 
Fabian 
Taylor 
Murray 
Hamiltion 
Wallis 
Marcus 
Wanda 
