Disable ads (and more) with a membership for a one time $4.99 payment
What retention period can be set for SQLInsights data stored in Azure if set to infinite?
30 days
90 days
730 days
Infinite
The correct answer is: Infinite
When SQLInsights data is configured with an infinite retention period in Azure, it means that the data will be retained indefinitely. This setting is particularly useful for organizations that need to maintain historical data for long-term analysis, compliance, or regulatory purposes without the concern of data aging out or being deleted after a specific duration. The other retention options such as 30 days, 90 days, and 730 days provide finite durations for data retention. If the period is set to a specific number of days, the data will be automatically purged once it exceeds that duration. However, choosing an infinite retention period allows you to keep all insights data available for as long as necessary, which supports various analytical tasks and ensures that no relevant data is lost over time.