ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 467 - AZ-400 discussion

Report
Export

SIMULATION

Task 11

You need to write a KQL query that will count the number of inbound requests for each source IP address, for any connection made during the last three months of 2021.

Open Azure Data Explorer by using the following link:

https//dataexploter azure.com/clusters/help/databases/Securiitylogs

The requests are contained in a table named InboundBrowsing in the Securitylogs connection.

The query must return two columns named NumberOfRequests and SourcelP.

Export the query result to C:\Samples

A.
See the solution below in explanation
Answers
A.
See the solution below in explanation
Suggested answer: A

Explanation:

Step 1: Write the KQL Query

Open Azure Data Explorer:

Navigate to Azure Data Explorer and sign in with your credentials.

Access the Securitylogs Database:

Open theSecuritylogsdatabase.

Write the Query:

Use the following KQL query to count the number of inbound requests for each source IP address:

InboundBrowsing

| where Timestamp between (datetime(2021-10-01) .. datetime(2021-12-31))

| summarize NumberOfRequests = count() by SourceIP

| project SourceIP, NumberOfRequests

Step 2: Export the Query Results

Run the Query:

Execute the query in Azure Data Explorer.

Export the Results:

Once the query results are displayed, click on theExportbutton.

Choose the export format (e.g., CSV) and specify the export path asC:\Samples.

By following these steps, you will have successfully written a KQL query to count the number of inbound requests for each source IP address during the last three months of 2021 and exported the results toC:\Samples

asked 02/10/2024
sangilipandy Arumugam
24 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first