Online Access Free 070-764 Exam Questions
| Exam Code: | 070-764 |
| Exam Name: | Administering a SQL Database Infrastructure |
| Certification Provider: | Microsoft |
| Free Question Number: | 452 |
| Posted: | Sep 01, 2025 |
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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.
Solution: You add the DatabaseMailUserRole to Mail1 in the master database.
Does the solution meet the goal?
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 are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance. The environments that you manage are shown in the following table.
You need to configure monitoring for Tailspin Toys.
In the table below, identify the monitoring tool that you must use for each activity.
NOTE: Make only one selection in each column.
You plan to deploy three highly available SQL Server environments that will use SQL Server 2014. You identify the following specifications for each environment as shown following table.
You need to recommend which high-availability feature is required for each environment.
Which features should you identify? To answer, drag the appropriate feature to the correct requirement in the answer area.
You plan to deploy SQL Server 2014. You are designing two stored procedures named SP1 and SP2 that have the following requirements:
- Prevent data read by SP1 from being modified by other active processes.
- Prevent SP2 from performing dirty reads.
You need to recommend the isolation level for each stored procedure.
The solution must maximize concurrency. Which isolation levels should you recommend? To answer, drag the appropriate isolation level to the correct stored procedure in the answer area.
You need to recommend a backup process for data warehouse database. The solution must meet the following requirements:
* Ensure that if a hardware failure occurs, you can bring the database online without losing more than 24 hours of transactions.
* Minimize the amount of administrative effort required to restore any lost data.
* Minimize the space used by transaction logs.
What should you include in the recommendation? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
