Question 460
An audit team needs to reconstruct a customer's recorded address as it appeared last month without overwriting today's address. A developer assumes turning on temporal versioning also proves that a privileged administrator never changed the history. What is the most appropriate plan for this situation?
Explanation
Correct Answer
First, temporal history preserves prior row versions for point-in-time analysis without replacing the current operational state. Second, tracking versions and cryptographically detecting unauthorized changes are distinct assurances and require different controls.
Incorrect Answers
Explain the difference between temporal history and tamper-evident ledger verification and select controls to match the threat model; do not evaluate a system-versioned temporal table with history retention and query records using supported temporal clauses: evaluate a system-versioned temporal table with history retention and query records using supported temporal clauses.
Configure a supported temporal-history retention and cleanup plan aligned with policy and recovery requirements; Explain the difference between temporal history and tamper-evident ledger verification and select controls to match the threat model: temporal history preserves prior row versions for point-in-time analysis without replacing the current operational state.
Evaluate a system-versioned temporal table with history retention and query records using supported temporal clauses; evaluate SQL ledger tables and their cryptographic digest verification as part of the audit design: tracking versions and cryptographically detecting unauthorized changes are distinct assurances and require different controls.



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