問題文
A compliance officer asks for two separate capabilities on the credit decision table. First, reconstruct what a row looked like on a given date last year. Second, give an external auditor cryptographic proof that no row has been maliciously altered, even by a database administrator. Which option correctly assigns the features to those two needs?
選択肢
- A temporal table serves both needs, because the history table cannot be modified once system versioning is enabled.
- Auditing to an immutable log store serves both needs, because the audit log records every read and write with the previous values.
- A system-versioned temporal table serves the point-in-time reconstruction, and a ledger table with database digests stored outside the database serves the proof of integrity.
- A ledger table serves both needs, so the temporal table is unnecessary and the table should be created in a ledger database.