Hi @Pradeep-Jaiswal
i don't think any option available to activate an audience by default to a destination with out explicitly configuring it.
you can also think of doing dataset export of profile snapshot, then data warehouse you can have this data loaded. You can also think of having some level of transformation to load only the details you want for audit. segment membership will also be available, so you know which profile is qualified for which segment. or you can keep the data set export file as it is in data lake, and use it only when needed.