Question 216
You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1.
You need to ensure that an automatic email notification is sent once the job completes.
What should you include in the solution?
Question 217
You have several Azure SQL databases on the same Azure SQL Database server in a resource group named ResourceGroup1.
You must be alerted when CPU usage exceeds 80 percent for any database. The solution must apply to any additional databases that are created on the Azure SQL server.
Which resource type should you use to create the alert?
Question 218
You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements:
* Support failovers that do not require client applications to change their connection strings.
* Replicate the database to a secondary Azure region.
* Support failover to the secondary region.
What should you include in the recommendation?
Question 219
Your company analyzes images from security cameras and sends alerts to security teams that respond to unusual activity. The solution uses Azure Databricks.
You need to send Apache Spark level events, Spark Structured Streaming metrics, and application metrics to Azure Monitor.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions in the answer area and arrange them in the correct order.
Question 220
You have a database named db1.
The log for db1 contains the following entry.
You need to ensure That db1 can process transactions.
