What is the most efficient way to Query such information?

As part of a custom development, a developer creates a Lightning Component to show how a particular opportunity progresses over time.

The component must display the date stamp when any of the following fields change:

• Amount Probability, Stage, or Close Date

What is the most efficient way to Query such information?
A . [Select Amount, CloseDate, StageName, Probability FROM OpportunityHistory WHERE Opportunityld = :oppId];
B . [Select Newvalue, Oldvalue From OpportunityField_History Where Oppportunity = oppid AND Field IN
C . [Select NewValue, Oldvalue FROM Opportunity FieldHistory WHERE Opportunityld = :oppId AND Field IN
D . (‘StageName’, Probability’,Amount /CloseDate’)];
E . [Select Amount CloseDate. StageName, Probability FROM Opportunity_History WHERE Opportunityld – :oppId];

View Answer

Answer: C