ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-103 All Questions

View all questions & answers for the AZ-103 exam
Go to Exam

Exam AZ-103 topic 2 question 17 discussion

Actual exam question from Microsoft's AZ-103
Question #: 17
Topic #: 2
[All AZ-103 Questions]

HOTSPOT -
You have an Azure subscription that contains several virtual machines and an Azure Log Analytics workspace named Workspace1.
You create a log search query 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: 14 days -
Two weeks will be covered.
Note: Startofweek returns the start of the week containing the date, shifted by an offset, if provided.
Start of the week is considered to be a Sunday.
Endofweek returns the end of the week containing the date, shifted by an offset, if provided.
Last day of the week is considered to be a Saturday.
Box 2:
The render operator renders results in as graphical output. Timechart is a Line graph, where the first column is x-axis, and should be datetime. Other columns are y-axes. In this case the Y axis has avg(CounterValue) Values.
Reference:
https://docs.microsoft.com/en-us/azure/azure-monitor/log-query/log-query-overview https://docs-analytics-eus.azurewebsites.net/queryLanguage/query_language_renderoperator.html
by Exam103 at March 22, 2020, 1:01 p.m.

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
Submit Cancel
Tarek_Wefky
Highly Voted 5 years, 1 month ago
Suppose Today is Monday 16-3-2020, 16 -9 equal 7, it is Saturday 7-3-2020. the start of this week is Monday 2-3-2020. let's come to the end of the week, its 16 - 2= 14, it is Saturday 14-3-2020. the end of that week is Sunday 15-3-202. so, the calculation from 2-3-2020 until 15-3-2020 it is 14 days.
upvoted 31 times
[Removed]
4 years, 11 months ago
Returns the start of the week containing the date, shifted by an offset, if provided. Start of the week is considered to be a Sunday.
upvoted 3 times
...
...
matie
Highly Voted 4 years, 9 months ago
My understanding of this is: Startofweek Returns the start of the week containing the date, shifted by an offset, if provided. Start of the week is considered to be a Sunday. https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/startofweekfunction EndofWeek Returns the end of the week containing the date, shifted by an offset, if provided. Last day of the week is considered to be a Saturday. https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/startofweekfunction Running the report on Monday (say today 15-July-2020), will give: startofweek as past Sunday 12-July-2020 endofweek as this coming Saturday 18-July-2020 12-July minus 9 days (ago 9d) gives 3-July-2020 18-July minus 2 days (ago 2d) gives 16-July-2020 3-July to 16-July is 14 days
upvoted 21 times
walexkino
4 years, 1 month ago
The most simple explanation thanks mahn
upvoted 1 times
...
...
Amir1909
Most Recent 1 year, 2 months ago
Correct
upvoted 1 times
...
DA0410
4 years, 7 months ago
The answer is correct. Today is 2/10/2020. Query ran today . 27/09/20 9 days ag0 28 29 30 31 1 2 Query ran today oct 2nd 2020.2/10/2020 3 4 5 6 7 8 i.e 2 days before end of week 8 /10/2010 9 10 End of week from 27/09/20 to 8/10/2020 = 14 days!
upvoted 5 times
...
hstorm
4 years, 8 months ago
Lets say you run the Query 24/9 24/9 - 9 days = sat 15/9 -> Start of that week is sun 9/9 24/9 - 2 days = sat 22/9 -> End of that week is sat 22/9 9/9 to 22/9 = 14 days
upvoted 9 times
...
imnotabot
4 years, 8 months ago
This doesn't make sense to me. Ran Query as seen here Perf | where CounterName == "% Processor Time" | where ObjectName == "Processor" | where TimeGenerated between (startofweek(ago(9d)) .. endofweek(ago(2d))) | summarize avg(CounterValue) by Computer, bin(TimeGenerated, 5min) | render timechart Chart comes back and shows Aug 9th to the 18th. That's 10 days. yup. confused
upvoted 1 times
imnotabot
4 years, 8 months ago
Nevermind. Question says done on monday. Today is Tuesday. In order to make up the difference, I set the to ago(10d) and endofweek(ago(3d). This actually returned a 14 day period. check out the available stuff here to practice and observe. https://ms.portal.azure.com/#blade/Microsoft_Azure_Monitoring_Logs/DemoLogsBlade It adds the monitoring data to your env and lets you run hem as if you actually have a bunch of data being recorded.
upvoted 2 times
...
...
senseibrutal
4 years, 11 months ago
given answer is correct
upvoted 4 times
...
Monkeybizzz
4 years, 12 months ago
The problem with this question is its assuming we know that the start of a week is on Sunday. If it stated in the question, not the answer, that the start of a work week is Sunday, then 14 days makes sense because 9 days prior to Monday is a Saturday- aka the end of a week. But the statement wants the beginning of that work week, meaning we migrate back to the Sunday that started that work week. It's just annoying because it doesnt say in the question that Sunday is considered Day 1 of a Workweek.
upvoted 3 times
...
Exam103
5 years, 1 month ago
Should be just 7 days imho the offset is from date that the query is run. Monday - 9 is Sunday before (that is also startofweek of that date) Monday - 2 is Saturday before (that is also the endofweek of that date) In between of those is just 7 days
upvoted 5 times
certificatores
5 years, 1 month ago
I may second you but there is really no MS document to prove this. I checked several documents. we can only prove this by actually trying.
upvoted 1 times
...
FrancisFerreira
5 years, 1 month ago
Monday - 9 = Saturday (not Sunday). So, startofweek is 3 Sundays back. The endofweek you got right. So, endofweek is 1 Saturday back. That gives us a span of 14 days. Although we can't exactly call it "the last 14 days", can we? (since last Sunday, aka yesterday, is not included in it)
upvoted 13 times
certificatores
5 years, 1 month ago
wording in this question is very weird. if today is Monday, we can not call "last x days" for any week.
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago