| Exam Name: | Administering Relational Databases on Microsoft Azure | ||
| Exam Code: | DP-300 Dumps | ||
| Vendor: | Microsoft | Certification: | Microsoft Certified: Azure Database Administrator Associate |
| Questions: | 366 Q&A's | Shared By: | ekam |
You need to use an Azure Resource Manager ARM) template to deploy an Azure virtual machine that will host a Microsoft SQL Server instance. The solution must maximize disk I/O
performance for the SQL Server database and log files
How should you complete the template? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1. You need to configure SQL! to use mixed mode authentication. Which procedure should you run?
You have a version-8.0 Azure Database for MySQL database.
You need to identify which database queries consume the most resources.
Which tool should you use?
Task 5
You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.