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 have an Azure Databricks resource.
You need to log actions that relate to changes in compute for the Databricks resource.
Which Databricks services should you log?

• A.clusters
• B.jobs
• C.DBFS
• D.SSH
• E.workspace

Comment: *

Name: *

Email: *

Verification: *

You have SQL Server on an Azure virtual machine that contains a database named DB1.
The database reports a CHECKSUM error.
You need to recover the database.
How should you complete the statements? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: SINGLE_USER
The specified database must be in single-user mode to use one of the following repair options.
Box 2: REPAIR_ALLOW_DATA_LOSS
REPAIR_ALLOW_DATA_LOSS tries to repair all reported errors. These repairs can cause some data loss.
Note: The REPAIR_ALLOW_DATA_LOSS option is a supported feature but it may not always be the best option for bringing a database to a physically consistent state. If successful, the REPAIR_ALLOW_DATA_LOSS option may result in some data loss. In fact, it may result in more data lost than if a user were to restore the database from the last known good backup.
Incorrect Answers:
REPAIR_FAST
Maintains syntax for backward compatibility only. No repair actions are performed.
Box 3: MULTI_USER
MULTI_USER
All users that have the appropriate permissions to connect to the database are allowed.
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql

Comment: *

Name: *

Email: *

Verification: *

You have the following Transact-SQL query.

Which column returned by the query represents the free space in each file?

• A.ColumnA
• B.ColumnB
• C.ColumnC
• D.ColumnD

Comment: *

Name: *

Email: *

Verification: *

What should you implement to meet the disaster recovery requirements for the PaaS solution?

• A.Availability Zones
• B.failover groups
• C.Always On availability groups
• D.geo-replication

Comment: *

Name: *

Email: *

Verification: *