Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing…

Question

Options

• AUse replication to roll out changes to higher environments.
• BUse backup and restore to roll out changes to higher environments.
• CUse Liquibase to roll out changes to higher environments.
• DManually capture detailed DBA audit logs when changes are rolled out to higher environments.

• A
  7% (3)
• B
  11% (5)
• C
  80% (35)
• D
  2% (1)

Explanation

The correct answer is C. Liquibase is a database schema change management and version control tool that maintains a detailed, ordered changelog of every database change (DDL and DML). This changelog provides a complete, auditable history of all schema modifications, making it ideal for compliance auditing and rollout tracking to production. Auditors can review exactly what changed, when, and in what order. Options A and B (replication and backup/restore) are data movement strategies and do not produce an audit trail of schema changes. Option D (manual DBA audit logs) is unreliable, error-prone, and not a scalable or Google-recommended practice for compliance tracking across multiple environments.

No community discussion yet for this question.