Microsoft Azure Architect Design (AZ-301) Practice Exam

Disable ads (and more) with a membership for a one time $4.99 payment

Prepare for the Microsoft Azure Architect Design Exam (AZ-301) with comprehensive quiz questions and detailed explanations. Our study materials, including interactive quizzes, aim to enhance your understanding and readiness for the exam.

Practice this question and more.


What retention period can be set for SQLInsights data stored in Azure if set to infinite?

  1. 30 days

  2. 90 days

  3. 730 days

  4. 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.