You need to migrate an on-premises SQL Server database to Azure. The solution must include support for SQL Server Agent.Which Azure SQL architecture should you recommend?Select only one answer.Azure SQL Database with the Business Critical service tierAzure SQL Database with the General Purpose service tierAzure SQL Database with the Hyperscale service tierAzure SQL Managed Instance with the General Purpose service tier
Question
You need to migrate an on-premises SQL Server database to Azure. The solution must include support for SQL Server Agent.Which Azure SQL architecture should you recommend?Select only one answer.Azure SQL Database with the Business Critical service tierAzure SQL Database with the General Purpose service tierAzure SQL Database with the Hyperscale service tierAzure SQL Managed Instance with the General Purpose service tier
Solution
I recommend Azure SQL Managed Instance with the General Purpose service tier. This is because Azure SQL Managed Instance is the only option that supports SQL Server Agent, which is a requirement in your scenario. The General Purpose service tier is a balanced and cost-effective option for most business workloads.
Similar Questions
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 transactional database requirements exceed the maximum capacity of a single Azure SQL database in the General Purpose service tier.What should you implement to resolve the capacity issue?
. Which deployment option offers the best compatibility when migrating an existing SQL Server on-premises solution? Azure SQL Database (single database)Azure SQL Database (elastic pool)Azure SQL Managed Instance
Which Azure SQL Database service tier provides the fastest recovery time for a database?Select only one answer.Business criticalGeneral PurposeHyperscale
Your company plans to run large scale image analysis and processing in Azure.You need to recommend which Azure compute service to use for the planned solution. The solution must minimize administrative effort.Which Azure service should you recommend?Select only one answer.Azure BatchAzure FunctionsAzure Logic AppsAzure virtual machines
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.