How should you complete the Azure PowerShell command?

HOTSPOT

A server named AzureSqlSvr1 hosts several Microsoft Azure SQL Database instances.

You need to configure audit logs for all databases to ensure that events are captured when a database schema is created, altered, or dropped.

How should you complete the Azure PowerShell command? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

Box 1: Set-AzureRmSqlServerAuditing The Set-AzureRmSqlServerAuditing cmdlet changes the auditing settings of an Azure SQL server. After the cmdlet runs successfully, auditing of the Azure SQL databases that are defined in the specified Azure SQL server is enabled.

Box 2: AuditActionGroup Parameters include AuditActionGroup, but not AuditAction.

Box 3: SCHEMA_OBJECT_CHANGE_GROUP SCHEMA_OBJECT_CHANGE_GROUP tracks whenever create, alter or drop is executed on a schema object such as a table, view or stored procedure.

If you enable this group in a server audit specification, it will track changes to schema objects in all of the databases of this instance of SQL Server. If you enable the group in a database audit specification, it will track changes to schema objects within that database only.