Free Preparation Discussions
MENU
Salesforce Certified Platform Developer II (Plat-Dev-301) Exam - Topic 2 Question 123 Discussion
Topic #: 2
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 6 and 12 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 6 to 12 months old?
A)
B)
C)
D)
Given the code snippet, the correct query to retrieve Account History records between 6 and 12 months old would be the one that includes a WHERE clause filtering records where the CreatedDate is greater than or equal to initialDate and less than or equal to endDate. Option B's statement does this correctly by using the >= and <= operators to define the range between initialDate (which is set to today's date minus 12 months) and endDate (set to today's date minus 6 months). Options A, C, and D either use incorrect comparison operators or compare against the wrong variables, resulting in an incorrect data set being returned.
Reference
SOQL Date Formats and Date Literals: SOQL and SOSL Reference Guide
Herminia
29 days agoChanel
1 month agoLeonardo
1 month agoAlisha
2 months agoBarrie
2 months agoPeggy
2 months agoCatarina
2 months agoOmer
2 months agoJacquelyne
2 months agoOdette
3 months agoFausto
3 months agoGlory
3 months agoTaryn
4 months agoKris
4 months agoCristen
4 months agoDominque
4 months agoMicheal
4 months agoMarvel
4 months agoBlair
5 months agoDarrin
5 months agoBo
5 months agoDetra
5 months agoTabetha
5 months agoAnastacia
24 days ago