Contosoという名前のMicrosoft SQL Server 2016データベースをServer01という名前のサーバー上で管理します。 ユーザーがServer01の固定サーバーロールに追加または削除されたときにメッセージをアプリケーションログに書き込む必要があります。 何を作るべきですか?
正解:G
Explanation The SQL Server Audit feature enables you to audit server-level and database-level groups of events and individual events. Audits can have the following categories of actions: Server-level. These actions include server operations, such as management changes and logon and logoff operations. Database-level. These actions encompass data manipulation languages (DML) and data definition language (DDL) operations. Audit-level. These actions include actions in the auditing process. References: http://technet.microsoft.com/en-us/library/cc280663(v=sql.105).aspx