Google Cloud Professional Cloud Database Engineer — Question 113

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 on several Cloud Spanner databases. What should you do?

Answer options

• A. Use replication to roll out changes to higher environments.
• B. Use backup and restore to roll out changes to higher environments.
• C. Use Liquibase to roll out changes to higher environments.
• D. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.

Correct answer: C

Explanation

The correct answer is C because Liquibase provides a robust framework for managing database changes, including auditing capabilities. Options A and B do not specifically address the auditing requirement, as they focus on methods of rolling out changes rather than tracking them. Option D is less efficient and does not provide an automated way to ensure compliance.