You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 database server named MiracleInfocom -DB01 which you administer. MiracleInfocom -DB01 is used to store confidential company information. You established a domain security policy which requires every action to change permission on the database server to be logged. MiracleInfocom -DB01 can only be running when logging is enabled. You are required to enforce the security policy on the database server. What should you do?
A. By using the sp_configure statement c2 audit mode should be enabled.
B. From the Security page of MiracleInfocom -DB01’s Properties windows auditing should be enabled.
C. Through a Group Policy Object (GPO) an audit policy must be enabled.
D. Through the Local Security Policy auditing must be enabled.
Answer:A
You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 database server named MiracleInfocom -DB01 which you administer. MiracleInfocom -DB01 is used to store confidential company information. You established a domain security policy which requires every action to change permission on the database server to be logged. MiracleInfocom -DB01 can only be running when logging is enabled. You are required to enforce the security policy on the database server. What should you do?
A. By using the sp_configure statement c2 audit mode should be enabled. B. From the Security page of MiracleInfocom -DB01’s Properties windows auditing should be enabled. C. Through a Group Policy Object (GPO) an audit policy must be enabled. D. Through the Local Security Policy auditing must be enabled.