Die Microsoft Provisioning SQL Databases gilt im Jahr 2026 als anspruchsvoller Nachweis Ihres Fachwissens – und genau deshalb lohnt sich eine strukturierte Vorbereitung. Die 268 Praxisfragen von Fast2test wurden von erfahrenen Experten zusammengestellt und decken alle relevanten Themen der 70-765 Prüfung ab.

Microsoft 70-765 Prüfungsübersicht:

Microsoft 70-765 Prüfungsthemen:

FAQ: Alles Wichtige zur Microsoft 70-765 Zertifizierungsprüfung

Microsoft Provisioning SQL Databases 70-765 Prüfungsfragen mit Lösungen

Frage #1

Database DB1 must use two CPU cores.
Queries that were running on database DB2 prior to migration do not complete.
You need to configure the databases.
In the table below, identify the parameter that must be configured for each databases.
Select one option for DB1, and one option for DB2. Select one option for each column.

Frage #2

You have a Microsoft SQL Server instance which hosts all of your corporate databases. A database named Sales stores information about customers and their contact information.
You use the following processes for backing up the database:
All databases are configured for full recovery model.
Full backups are performed every morning at 2:00 AM.
Log backups are performed every hour starting at 9:00 AM.
At 9:35 AM, a member of the sales team mistakenly updates all customer records.
You need to recover the database to a stable state and recover as much data as possible without recovering the changes that the sales team member made.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Frage #3

You plan to create an AlwaysOn availability group that will have two replicas in Microsoft Azure and two onpremises replicas.
You need to ensure that a replica in Azure is always available.
Which cmdlet should you run before you deploy the virtual machines?

A. New-AzureRmAvailabilitySet
B. New-AzureRmVM
C. New-AzureRmSqlDatabaseSecondary
D. New-AzureRmSqlElasticPool
E. New-AzureRmSqlServer
F. New-AzureRmSqlDatabaseCopy
G. New-AzureRmSqlServerCommunicationLink
H. New-AzureRmLoadBalancer

Frage #4

You use a Microsoft SQL Server 2014 database that contains two tables named SalesOrderHeader and SalesOrderDetail. The indexes on the tables are as shown in the exhibit.
(Click the Exhibit button.)

You write the following Transact-SQL query:

You discover that the performance of the query is slow. Analysis of the query plan shows table scans where the estimated rows do not match the actual rows for SalesOrderHeader by using an unexpected index on SalesOrderDetail.
You need to improve the performance of the query.
What should you do?

A. Use a FORCESCAN hint in the query.
B. Update statistics on SalesOrderId on both tables.
C. Use a FORCESEEK hint in the query.
D. Add a clustered index on SalesOrderId in SalesOrderHeader.

Frage #5

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 are migrating an on-premises Microsoft SQL Server instance to SQL Server on a Microsoft Azure virtual machine. The instance has 30 databased that consume a total of 2 TB of disk space.
The instance sustains more than 30,000 transactions per second.
You need to provision storage for the virtual machine. The storage must be able to support the same load as the on-premises deployment.
Solution: You create one storage account that has 30 containers. You create a VHD in each container.
Does this meet the goal?

A. No
B. Yes

Fragen und Antworten: