You receive numerous alerts from Azure Monitor for an Azure SQL database.
You need to reduce the number of alerts. You must only receive alerts if there is a significant change in usage patterns for an extended period.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Set Threshold Sensitivity to High
• B.Set the Alert logic threshold to Dynamic
• C.Set the Alert logic threshold to Static
• D.Set Threshold Sensitivity to Low
• E.Set Force Plan to On

Comment: *

Name: *

Email: *

Verification: *

You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview
https://docs.microsoft.com/en-us/azure/azure-sql/database/reserved-capacity-overview

Comment: *

Name: *

Email: *

Verification: *

You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements.
What should you run as part of the implementation?

• A.CREATE LOGIN and the FROM WINDOWS clause
• B.CREATE USER and the FROM CERTIFICATE clause
• C.CREATE USER and the FROM LOGIN clause
• D.CREATE USER and the ASYMMETRIC KEY clause
• E.CREATE USER and the FROM EXTERNAL PROVIDER clause

Comment: *

Name: *

Email: *

Verification: *

You have 20 Azure SQL databases provisioned by using the vCore purchasing model.
You plan to create an Azure SQL Database elastic pool and add the 20 databases.
Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.total size of all the databases
• B.geo-replication support
• C.number of concurrently peaking databases * peak CPU utilization per database
• D.maximum number of concurrent sessions for all the databases
• E.total number of databases * average CPU utilization per database

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL managed instance.
You need to restore a database named DB1 by using Transact-SQL.
Which command should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *