Practice Test 3 | Microsoft Azure Administrator | AZ-104 | Dumps | Mock Test
A team has set up Log Analytics for a virtual machine named demovm. They are running the following query in the Log Analytics Workspace.
If a query is run on Monday, then the query will return events from the last
A. 1 day
B. 7 days
C. 11 days
D. 14 days
E. 16 days
Explanation:
Answer – D
The query will return events for the last 14 days.
We are using Kusto Query Language (KQL) for this query. The query needs to calculate the time between startofweek(ago(9d)) and endofweek(ago(2d)).
In KQL start of the week usually is Sunday. If today is Monday, 21st, 9 days ago was Saturday, 12th. But we are looking for the start of the week for this Saturday, 12th. It was Sunday, 6th.
Our startofweek(ago(9d)) is Sunday, 6th.
In KQL end of the week usually is Saturday. If today is Monday, 21st, 2 days ago was Saturday, 19th. This is precisely the end of the previous week.
Our endofweek(ago(2d)) is Saturday, 19th.
The difference between endofweek(ago(2d))-startofweek(ago(9d)) is 2 full weeks or 14 days.
A week number one – from Sunday, 6th, till Saturday, 12th, – 7 days.
A week number two – from Sunday, 13th, till Saturday, 19th, – 7 days.
For more information on performing log queries, please visit the below URLs-
https://docs.microsoft.com/en-us/azure/azure-monitor/log-query/log-query-overview
https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/
https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/startofweekfunction
https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/endofweekfunction
Comments are closed, but trackbacks and pingbacks are open.