DP-300 Exam Question 66
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?
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?
DP-300 Exam Question 67
You plan to deploy an app that includes an Azure SQL database and an Azure web app. The app has the following requirements:
- The web app must be hosted on an Azure virtual network.
- The Azure SQL database must be assigned a private IP address.
- The Azure SQL database must allow connections only from the virtual
network.
You need to recommend a solution that meets the requirements.
What should you include in the recommendation?
- The web app must be hosted on an Azure virtual network.
- The Azure SQL database must be assigned a private IP address.
- The Azure SQL database must allow connections only from the virtual
network.
You need to recommend a solution that meets the requirements.
What should you include in the recommendation?
DP-300 Exam Question 68
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.
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.
DP-300 Exam Question 69
You have an Azure SQL managed instance that hosts multiple databases.
You need to configure alerts for each database based on the diagnostics telemetry of the database.
What should you use?
You need to configure alerts for each database based on the diagnostics telemetry of the database.
What should you use?
DP-300 Exam Question 70
Hotspot 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.
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.
