Hotspot Question You deploy several Azure SQL Database instances. You plan to configure the Diagnostics settings on the databases as shown in the following exhibit. Use the drop-down menus to select…

Question

Exhibits

Answer Area

• The amount of time that SQLInsights data will be stored in blob storage is90 days
  30 days90 days730 daysindefinite
• The maximum amount of time that SQLInsights data can be stored in Azure Log Analytics is730 days
  30 days90 days730 daysindefinite

Explanation

The exhibit shows the Diagnostic settings for Azure SQL Database. For the first statement, "The amount of time that SQLInsights data will be stored in blob storage," the SQLInsights category in the exhibit explicitly shows a "Retention (days)" value of 90. This directly corresponds to the data retention in blob storage, as confirmed by the provided explanation: "Box 1: 90 days. The retention policy is only for storage account, this is set to 90 days." For the second statement, "The maximum amount of time that SQLInsights data can be stored in Azure Log Analytics," the exhibit does not show a specific retention setting for Log Analytics directly on the SQLInsights line. However, the provided explanation clarifies the general capability of Azure Log Analytics: "Box 2: 730 days. How data points...are kept for up to 730 days." Therefore, the maximum retention for data in Azure Log Analytics is 730 days.

No community discussion yet for this question.