Question 41
Open question ↗You have a Microsoft SQL Server 2017 server.
You need to migrate the server to Azure. The solution must meet the following requirements:
• Ensure that the latest version of SQL Server is used.
• Support the SQL Server Agent service.
• Minimize administrative effort.
What should you use?
Question 42
Open question ↗You have a Microsoft SQL Server 2017 server that hosts five databases.
You plan to migrate the databases to Azure.
You need to recommend a solution that meets the following requirements:
• Automatically scales compute based on the workload demand
• Provides per-second billing
What should you include in the recommendation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 43
Open question ↗You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication.
You need to migrate SQL1 to Azure.
Which service should you use?
Question 44
Open question ↗You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database named DB1.
You need to recommend a solution to migrate DB1 to an Azure SQL managed instance. The solution must minimize downtime and administrative effort.
What should you include in the recommendation?
Question 45
Open question ↗You have an Azure subscription.
You plan to deploy an instance of SQL Server on Azure Virtual Machines that supports Write Accelerator.
Which virtual machine series should you use?
Question 46
Open question ↗You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.
You have an Azure subscription that contains an Azure SQL database named SQLDB1.
You need to replicate DB1 to SQLDB1.
Which type of replication should you use?
Question 47
Open question ↗You have two on-premises servers that run Windows Server 2019 and host a Microsoft SQL server 2017 Always On availability group named AG1. AG1 contains a single database named DB1.
You have an Azure subscription. The subscription contains a virtual machine named VM1 that runs Linux.
You need to migrate DB1 to a SQL Server 2019 instance on VM1. The solution must minimize the downtime of DB1 during the migration.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one-point.
Question 48
Open question ↗You have an Azure SQL database named DB1.
You need to create a partitioned table in DB1.
Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.
Question 49
Open question ↗You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database.
You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance.
Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Question 50
Open question ↗SIMULATION
You need to configure db1 to pause automatically after one hour of inactivity.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.