DP-300 Exam Question 201

You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1.
You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on-premises network connects to VNET1 by using an ExpressRoute connection.
You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service.
You need to configure VNET1 to support the migration.
What should you do?
  • DP-300 Exam Question 202

    You have an Azure subscription. The subscription contains three instances of SQL Server on Azure Virtual Machines that run Windows Server. The subscription contains an Azure load balancer named LB1.
    You implement an Always On availability group named AO1. You deploy a listener named AG1 and link AO1 to LB1.
    You need to configure a load balancing rule for LB1. The solution must ensure that traffic can flow to AG1.
    What should you use as the backend port?
  • DP-300 Exam Question 203

    You have four Azure virtual machines hosted in different availability zones in the same Azure region.
    You plan to deploy a Microsoft SQL Server Always On failover cluster instance (FCI) to the four virtual machines.
    What is the most resilient quorum option for the deployment?
  • DP-300 Exam Question 204

    Your company wants to create an Azure SQL Database. The database will contain a table that would have Employee information. There are columns which contain sensitive information. You have to enabled Always Encryption for the data stored in the Employee table.
    Which of the following could be used to store the encryption keys required for enabling Always Encrypted for the table?
  • DP-300 Exam Question 205

    SIMULATION
    You need to protect all the databases on sql12345678 from SQL injection attacks.
    To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.