Exam AZ-103 All Questions

View all questions & answers for the AZ-103 exam

Exam AZ-103 topic 2 question 17 discussion

Actual exam question from Microsoft's AZ-103

Question #: 17
Topic #: 2

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

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

Submit Cancel

Tarek_Wefky

Highly Voted 4 years, 8 months 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, 6 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, 4 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

3 years, 8 months ago

The most simple explanation thanks mahn

upvoted 1 times

...

Amir1909

Most Recent 9 months, 3 weeks ago

Correct

upvoted 1 times

...

DA0410

4 years, 2 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, 3 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, 3 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, 3 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, 5 months ago

given answer is correct

upvoted 4 times

...

Monkeybizzz

4 years, 6 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

4 years, 8 months 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 4 times

certificatores

4 years, 8 months 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

4 years, 8 months 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

4 years, 8 months 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

...