Question 201
Open question ↗You have an Azure subscription that contains 20 Azure SQL databases.
You create a Transact-SQL statement to perform index maintenance on a database.
You need to schedule the statement to run once daily against each database by using Transact-SQL commands.
What should you use to schedule the statement?
Question 202
Open question ↗You manage 100 Azure SQL managed instances located across 10 Azure regions.
You need to receive voice message notifications when a maintenance event affects any of the 10 regions. The solution must minimize administrative effort.
What should you do?
Question 203
Open question ↗You plan to deploy three instances of SQL Server on Azure Virtual Machines that will each contain 20 databases.
You need to recommend a solution that meets the following requirements:
• Ensures that the deployment is highly available
• Minimizes administrative effort to manage users, logins, permissions, and SQL Server Agent jobs across the instances
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 204
Open question ↗You have two Azure virtual machines named Server1 and Server2 that run Windows Server 2022 and are joined to an Active Directory Domain Services (AD DS) domain named contoso.com.
Both virtual machines have a default instance of Microsoft SQL Server 2019 installed. Server1 is configured as a master server, and Server2 is configured as a target server.
On Server1, you create a proxy account named contoso\sqlproxy.
You need to ensure that the SQL Server Agent job steps can be downloaded from Server1 and run on Server2.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Question 205
Open question ↗You have an Azure subscription. The subscription contains an instance of SQL Server on Azure Virtual Machines named SQL1 and an Azure Automation account named account1.
You need to configure account1 to restart the SQL Server Agent service if the service stops.
Which setting should you configure?
Question 206
Open question ↗SIMULATION
You need to ensure that any unused indexes of the databases on sql12345678 are removed automatically.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Question 207
Open question ↗SIMULATION
You need to generate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Question 208
Open question ↗You have 25 Azure SQL databases.
You need to implement a centralized database management solution that uses Transact-SQL.
What should you include in the solution?
Question 209
Open question ↗You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVM1. SQLVM1 has the following configurations:
• Automated patching is enabled.
• The SQL Server IaaS Agent extension is installed.
• The Microsoft SQL Server instance on SQLVM1 is managed by using the Azure portal.
You need to automate the deployment of cumulative updates to SQLVM1 by using Azure Update Manager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed by using the Azure portal.
What should you do first on SQLVM1?
Question 210
Open question ↗You plan to move two 100-GB databases to Azure.
You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations.
What should you use?