Exam AZ-305 topic 1 question 27 discussion

Correct answer is definitely 90 and 730. To those who say infinite: You may be thinking that the 90 days is how long it's storing the data "somewhere" before archiving to the storage account. This is not correct. The retention time boxes only appear after you select the "archive to storage account" checkbox. This retention period is applying specifically to the data in the storage account.

Please read the question carefully. It asks: 1. The amount of time that SQLInsights data will be stored in blob storage - yes, the 'maximum' is infinite, but 90 days has been selected in the diagram. 2. Second question is asking the 'maximum', so that answer is 730.

CORRECT

This question appeared in my exam on 13th May 2024. The given answer is correct. Thanks to ExamTopics.

Given Answer is correct 90 and 730 days Retention duration offered is one of 30, 60, 90, 120, 180, 270, 365, 550, or 730 days. Also as note, If retention greater than 730 days is required then you can use Continuous Export to copy it to a storage account during data ingestion. https://learn.microsoft.com/en-us/azure/azure-monitor/app/data-retention-privacy#how-long-is-the-data-kept

1. The amount of time that SQLInsights data will be stored in blob storage is "indefinite". This is because the option to "Archive to a storage account" is checked and there is no retention period specified for blob storage in the settings, which means it will retain the data until it is explicitly deleted. 2. The maximum amount of time that SQLInsights data can be stored in Azure Log Analytics is "90 days". This is explicitly set in the retention (days) for SQLInsights under the Log Analytics section of the diagnostic settings.

exam question on 07-12-2023

Got this on Sept. 29, 2023

I had question at 24th Sep 2023

Question does not apply anymore. Diagnostic settings storage retention are deprecated. See: https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/migrate-to-azure-storage-lifecycle-policy

Got this on Aug 5th, 2023.

on exam 5/2/23

1. 90 days 2. 730 days https://learn.microsoft.com/en-us/azure/azure-monitor/app/data-retention-privacy#how-long-is-the-data-kept Raw data points (that is, items that you can query in Analytics and inspect in Search) are kept for up to 730 days. You can select a retention duration of 30, 60, 90, 120, 180, 270, 365, 550, or 730 days. If you need to keep data longer than 730 days, you can use Continuous Export to copy it to a storage account during data ingestion.

in 14/2/2023 exam

...if you choose a retention policy that's greater than 0, the expiration date is attached to the logs at the time of storage. See tip in Step 5c. Storage https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/diagnostic-settings?tabs=portal#create-diagnostic-settings

SQL InsightsMetrics is stored in Azure Table, so technically the question shouldn't use the word blob!? https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-overview?view=azuresql

Thanks to all who mentioned the exam dates Ans is correct 90 and 730.