A developer needs to implement a system audit feature that allows users, assigned to a custom profile named “Auditors”, to perform searches against the historical records in the Account object. The developer must ensure the search is able to return history records that are between 12 and 24 months old. Given the code below, which select statement should be inserted below as a valid way to retrieve the Account History records ranging from 12 to 24 month old?

Select an option, then click Submit answer.
Reference / correct answer:
Most accepted answer: C.
Community votes: C=1
C is correct option upvoted 1 times
Selected Answer: C All Rows keyword is not allowed to AccountHistory object. D is wrong. upvoted 2 times moitam 2 years, 5 months ago I have tried out on Anonymous Console and I got no issue using ALL ROWS, "14:19:15:000 CUMULATIVE_PROFILING AnonymousBlock: line 3, column 1: [SELECT AccountId, DataType, Field, NewValue, OldValue, CreatedById, CreatedDate FROM AccountHistory WHERE CreatedDate >= :initialDate AND CreatedDate <= :endDate ALL ROWS]: executed 1 time in 103 ms" So based on this, and considering that this is for auditing purposes I guess D is correct since including the ones that are deleted or archived must be displayed too upvoted 3 times ...
I have tried out on Anonymous Console and I got no issue using ALL ROWS, "14:19:15:000 CUMULATIVE_PROFILING AnonymousBlock: line 3, column 1: [SELECT AccountId, DataType, Field, NewValue, OldValue, CreatedById, CreatedDate FROM AccountHistory WHERE CreatedDate >= :initialDate AND CreatedDate <= :endDate ALL ROWS]: executed 1 time in 103 ms" So based on this, and considering that this is for auditing purposes I guess D is correct since including the ones that are deleted or archived must be displayed too upvoted 3 times