Audit data storage depends on business requirements. It has to be some common cense discussion with finance people to define the required period (keeping in mind that in critical cases the audit data can be restored from old full server backup). After period is defined you have to provide enough space and server capacity.
P.S. In general it's hard to predict audit table growth. In some cases after running DM package multiple times the growth can be significant...
Add comment