Question 280
An application team must address both issues before release. A regulated workflow needs tamper-evident verification that past financial entries were not silently modified after acceptance. A temporal table's history grows indefinitely and breaches retention policy after every minor order-status correction. What is the most appropriate plan for this situation?
Explanation
Correct Answer
First, ledger tamper evidence addresses integrity verification, which ordinary row history does not provide by itself. Second, history tables accumulate earlier row versions and need lifecycle governance rather than indefinite default retention.
Incorrect Answers
Evaluate SQL ledger tables and their cryptographic digest verification as part of the audit design; evaluate a system-versioned temporal table with history retention and query records using supported temporal clauses: history tables accumulate earlier row versions and need lifecycle governance rather than indefinite default retention.
Evaluate SQL ledger tables and their cryptographic digest verification as part of the audit design.
Explain the difference between temporal history and tamper-evident ledger verification and select controls to match the threat model; configure a supported temporal-history retention and cleanup plan aligned with policy and recovery requirements: ledger tamper evidence addresses integrity verification, which ordinary row history does not provide by itself.



Developing AI-Enabled Database Solutions (DP-800) Practice Tests