You have a Microsoft SQL Server instance that runs in an on-premises datacenter.You plan to deploy a SQL Server instance to an Azure virtual machine and implement an Always On availability group that will contain databases hosted on both SQL Server instances.You need to recommend a connectivity method between the two instances. The solution must minimize the latency of the replication traffic.Which connectivity method should you recommend?Select only one answer.a Point-to-Site (P2S) VPN connectiona Site-to-Site (S2S) VPN connectionan ExpressRoute circuit
Question
You have a Microsoft SQL Server instance that runs in an on-premises datacenter.You plan to deploy a SQL Server instance to an Azure virtual machine and implement an Always On availability group that will contain databases hosted on both SQL Server instances.You need to recommend a connectivity method between the two instances. The solution must minimize the latency of the replication traffic.Which connectivity method should you recommend?Select only one answer.a Point-to-Site (P2S) VPN connectiona Site-to-Site (S2S) VPN connectionan ExpressRoute circuit
Solution
I would recommend an ExpressRoute circuit. This connectivity method is designed for high-speed, secure, and reliable connectivity to Microsoft cloud services, including Azure. It bypasses the public internet, which can significantly reduce latency and improve the speed of replication traffic between your on-premises SQL Server instance and the Azure virtual machine. This makes it the most suitable option for implementing an Always On availability group across these two instances.
Similar Questions
You are designing a high availability solution for a business-critical web app that will be deployed to multiple Azure regions.You need to recommend a high availability solution that meets the following requirements:Provides users a single hostname to access the web app.Load balances HTTP traffic across regions.Route users to the web app instance that has the lowest latency.Which high availability solutions should you recommend?Select only one answer.Azure Application GatewayAzure Front DoorAzure Load BalancerAzure Traffic Manager
Which of the following resources are required before you can deploy a VPN gateway between Azure and on-premises resources?Select all options that apply.1 pointVirtual network.Point-to-site connectionVirtual network gatewayPublic IP address.
You need to connect an Azure Resource Manager virtual network and a classic virtual network. Both networks are created in the same region and do not have overlapping address spaces. How do you achieve the goal?A:Peer the networksB: Create a VPN Site-to-Site connectionC: Route the traffic using an on-premises network applianceD: Route the traffic using an Azure hosted network appliance
You have a database hosted in Azure on Azure SQL Database (single database, Gen 5, 16 vCore). You need to ensure that the database is reachable only from your internal network connected to an Azure virtual network through a Virtual Network Gateway. What do you need to do to achieve this goal?A: Configure a Service Endpoint on Azure SQL DatabaseB: Create a virtual network ruleC:Migrate the database to a Managed InstanceD: Migrate the database to an on-premises serverE: This is not possible
Your company has branch offices on five continents. All the offices are connected to the closest Azure region.You need to recommend an Azure service that provides the following:Automated connectivity between the officesCentral control over security aspects of the connectivityUses the Microsoft backbone for inter-office connectivityWhich service should you recommend?Select only one answer.Azure Private LinkAzure Virtual WANAzure VPN GatewayExpressRoute
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.