CompTIA DataSys+ (DS0-001)Database Management and MaintenanceHard
A database administrator is configuring a database for a new application that processes sensitive financial transactions. They need to ensure that database changes are recorded in a way that provides an immutable, auditable trail of all operations, including who made them and when. Which database feature is primarily designed for this purpose?
- ASchema Versioning
- BTransaction Rollback
- CDatabase Auditing
- DSnapshot Isolation
Show answer & explanationAnswer & explanation
Correct answer: C. Database Auditing
Database auditing is explicitly designed to record specific database actions (e.g., DDL, DML, user logins, data access) along with details like user, timestamp, and affected objects, creating an immutable and auditable trail for regulatory compliance and security.
Why the other options are wrong
- A. Schema Versioning tracks changes to the database structure (DDL), not all data modifications or user activities.
- B. Transaction Rollback undoes changes made within a transaction; it doesn't create a persistent, auditable record of all operations.
- D. Snapshot Isolation is an isolation level for transactions, focusing on concurrency control, not on recording an auditable trail of all changes.
Database Auditing
A database security feature that records and stores information about specific database events, such as user logins, data access, and changes to data or schema.
- Crucial for regulatory compliance (e.g., SOX, HIPAA, GDPR).
- Provides an immutable trail of 'who did what, when, and where'.
- Can be configured to audit different levels of activity.
Memory trick: Auditing is like keeping a detailed 'audit' log, leaving no trace undone.