exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 1 question 27 discussion

Actual exam question from Microsoft's AZ-305
Question #: 27
Topic #: 1
[All AZ-305 Questions]

HOTSPOT -
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 the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: 90 days -
As per exhibit.

Box 2: 730 days -
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.
Reference:
https://docs.microsoft.com/en-us/azure/azure-monitor/app/data-retention-privacy

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
jellybiscuit
Highly Voted 2 years, 2 months ago
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.
upvoted 48 times
FabrityDev
1 year, 10 months ago
It appears to be true, judging by what is described in https://learn.microsoft.com/en-us/azure/active-directory/reports-monitoring/quickstart-azure-monitor-route-logs-to-storage-account
upvoted 1 times
...
...
kay000001
Highly Voted 2 years, 2 months ago
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.
upvoted 20 times
sw1000
1 year, 6 months ago
Yes, agree, it's one of those questions that do not test your knowledge, but your skill to read carefully. Technically, you could store it in Blob storage indefinitely
upvoted 3 times
...
...
SeMo0o0o0o
Most Recent 3 weeks, 6 days ago
CORRECT
upvoted 1 times
...
rtsh06
6 months, 3 weeks ago
This question appeared in my exam on 13th May 2024. The given answer is correct. Thanks to ExamTopics.
upvoted 3 times
...
Lazylinux
7 months, 1 week ago
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
upvoted 3 times
...
Cg007
8 months ago
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.
upvoted 2 times
...
venkya5555
1 year ago
exam question on 07-12-2023
upvoted 5 times
...
Exams_Prep_2021
1 year, 2 months ago
Got this on Sept. 29, 2023
upvoted 4 times
...
Forex19
1 year, 2 months ago
I had question at 24th Sep 2023
upvoted 2 times
...
DonatoDonato
1 year, 3 months ago
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
upvoted 3 times
...
InvalidNickname
1 year, 4 months ago
Got this on Aug 5th, 2023.
upvoted 2 times
...
zzreflexzz
1 year, 7 months ago
on exam 5/2/23
upvoted 2 times
...
zellck
1 year, 9 months ago
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.
upvoted 6 times
...
lanntt
1 year, 9 months ago
in 14/2/2023 exam
upvoted 4 times
...
[Removed]
1 year, 10 months ago
...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
upvoted 1 times
...
totalz
1 year, 10 months ago
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
upvoted 1 times
...
OPT_001122
1 year, 10 months ago
Thanks to all who mentioned the exam dates Ans is correct 90 and 730.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago