Online Access Free 070-765 Exam Questions
| Exam Code: | 070-765 |
| Exam Name: | Provisioning SQL Databases |
| Certification Provider: | Microsoft |
| Free Question Number: | 268 |
| Posted: | Jun 01, 2026 |
You are using dynamic management views to monitor an SQL Server server named SQL1.
A database administrator named Dba1 must monitor the health of SQL1.
You need to ensure that Dba1 can access dynamic management views for SQL1.
The solution must use the principle of least privilege.
Which permissions should you assign to Dba1?
A company plans to deploy Microsoft SQL Server on Azure using an Azure Resource Manager template, The deployment must be fault-tolerant with a 99.99 percent service level agreement (SLA).
You need to complete the Azure Resource Manager template while minimizing costs.
How should you complete the Azure Resource Manager template? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You manage a Microsoft SQL Server instance named SQL1 that has 32 gigabytes (GB) of total memory. The instance supports an app named App1 that only uses a single thread. App1 frequently queries the database using the same index. The operating system and App1 combined require 8 GB of memory to function.
You need to ensure that the SQL Server does not limit the performance of App1.
What configuration option should you set?
You must optimize DB1 for queries that use unknown variables. DB2 must not allow queries to run in parallel.
You need to configure the databases.
In the table below, identify the parameter that must be configured for each database.
NOTE: Make only one selection in each column.
You administer all the deployments of Microsoft SQL Server 2014 in your company. You have two servers in the same data center that hosts your production database.
You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs.
You also need to maintain transactional consistency of the data across both servers.
You need to achieve these goals without manual intervention.
Which configuration should you use?