Essbase data load rules files provide flexible options for how new data interacts with existing values in the database. The three primary operations are: adding to existing values, subtracting from existing values, and overwriting existing values completely. Options B and C incorrectly include 'average with existing values,' which is not a standard data load operation.