Exam AZ-400 All Questions

View all questions & answers for the AZ-400 exam

Exam AZ-400 topic 8 question 65 discussion

Actual exam question from Microsoft's AZ-400

Question #: 65
Topic #: 8

DRAG DROP -
You have an app named App1. You have a Log Analytics workspace named Workspace1 that contains a table named AppEvents. App1 writes logs to
Workspace1.
You need to query the AppEvents table. The solution must meet the following requirements:
✑ Only query rows for a column named Name that starts with the following text: "Clicked Create New Ticket."
✑ Calculate the number of daily clicks per user.
✑ Return the top 10 users based on their number of clicks for any day.
✑ Sort the results based on the highest number of clicks.
✑ Ignore any users who have less than three daily clicks.
In which order should you arrange the query statements? To answer, move all statements from the list of statements to the answer area and arrange them in the correct order.
Select and Place:

Show Suggested Answer

Suggested Answer:

by syu31svc at Sept. 2, 2022, 10:33 a.m.

Comments

Submit Cancel

syu31svc

Highly Voted 2 years, 5 months ago

Answer is correct

upvoted 17 times

...

gabo

Highly Voted 2 years, 3 months ago

I think summarize has to be after "where" and before "Top". search, where, take, count, summarize, bin, top, extend, project, distinct

upvoted 8 times

Bear_Polar

1 year, 4 months ago

You need to summarize (count) the number of clicks by grouping by user, then store value to the var NumberOfClicks (the table does not have this column). After that, you can add where condition on NumberOfClicks to filter >= 3. So, the provided answer is correct.

upvoted 4 times

...

vsvaid

Most Recent 1 year, 1 month ago

Correct answer

upvoted 1 times

...

xRiot007

1 year, 6 months ago

Answer: 1. AppEvents - you need to say what you select 2. Where Name = ... - this is the most specific filter and should appear first, unless you have a time based filter that is better optimized 3. Summarize clicks - these "clicks" are calculated 4. Where clicks >= 3 - this is another value filter that will discard less than 3 5. Top 10 - select top 10 entries. The result may contain LESS than 10 entries as well, or no entries at all.

upvoted 2 times

...

Fal991l

1 year, 9 months ago

am confident that both the order b, e, a, d, and c and the order b, d, e, a, and c should work as long as the required filtering, aggregation, and sorting are performed correctly. However, I must clarify that the order of the query statements does matter to some extent since the order of the statements can affect the performance of the query. For example, applying the filter | where statement early on in the query can reduce the amount of data processed, which can improve query performance. Therefore, it is always a good practice to arrange the query statements in the most optimal way that meets the requirements and provides the desired results.

upvoted 1 times

mfawew223

1 year, 2 months ago

d cannot come before a, because a defines NumberOfClicks and d uses NumberOfClicks

upvoted 1 times

...

Fal991l

1 year, 9 months ago

That's from GPT

upvoted 1 times

...

NK203

1 year, 9 months ago

How is the order of 'where' and 'summarize' decided? Why does summarize need to be placed between two 'where'?

upvoted 1 times

Whammer

1 year, 9 months ago

The second "Where" referenced the "NumberOfClicks" variable initialized in the "Summarize". Logically you would not be able to reference a variable that hasn't been created yet.

upvoted 4 times

...

binhdortmund

2 years, 1 month ago

I think the order should be BEDAC

upvoted 1 times

binhdortmund

2 years, 1 month ago

sorry ignore my post. Given answer is correct

upvoted 1 times

...

Darkeh

2 years, 4 months ago

correct answer

upvoted 3 times

...