To comply with regulations, which maintenance process should a database administrator focus on?

• A. Review audit logs
• B. Increase server capacity
• C. Implement user training
• D. Set up data encryption

Answer: (A)

Focusing on reviewing audit logs is crucial for a database administrator striving for compliance with regulations. Audit logs contain detailed records of database activities, including changes made to data, user access information, and execution of transactions. By regularly reviewing these logs, administrators can ensure that any unauthorized access or suspicious activities are promptly detected and addressed. This practice is also essential for demonstrating compliance during external audits, as it provides tangible evidence of adherence to security policies and regulations.

While increasing server capacity, implementing user training, and setting up data encryption are also important tasks within database management, they do not directly relate to regulatory compliance in the same way that reviewing audit logs does. Increasing server capacity may enhance performance but does not ensure compliance. User training is significant for operational security but does not provide direct visibility into actions taken on data. Data encryption is pivotal for protecting data confidentiality but does not offer the same level of oversight and accountability regarding user activities and database interactions as audit logs do.