DP-300 Exam Question 51

You have an Azure virtual machine based on a custom image named VM1.
VM1 hosts an instance of Microsoft SQL Server 2019 Standard.
You need to automate the maintenance of VM1 to meet the following requirements:
Automate the patching of SQL Server and Windows Server.
Automate full database backups and transaction log backups of the databases on VM1.
Minimize administrative effort.
What should you do first?
  • DP-300 Exam Question 52

    You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.
    You plan to migrate DB1 to an Azure SQL Database managed instance.
    What should you use to minimize downtime and data loss during the migration?
  • DP-300 Exam Question 53

    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?
  • DP-300 Exam Question 54

    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 have an Azure SQL database named Sales.
    You need to implement disaster recovery for Sales to meet the following requirements:
    During normal operations, provide at least two readable copies of Sales.
    Ensure that Sales remains available if a datacenter fails.
    Solution: You deploy an Azure SQL database that uses the Business Critical service tier and Availability Zones.
    Does this meet the goal?
  • DP-300 Exam Question 55

    You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.
    You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.
    You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
    Ensure that VM1 cannot connect to any Azure SQL Server other than SqlSrv1.
    Restrict network connectivity to SqlSrv1.
    What should you create on VNet1?