Valid AZ-400 Dumps shared by ExamDiscuss.com for Helping Passing AZ-400 Exam! ExamDiscuss.com now offer the newest AZ-400 exam dumps, the ExamDiscuss.com AZ-400 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com AZ-400 dumps with Test Engine here:
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
Correct Answer:
See the solution below in explanation. 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 the Securitylogs database. * 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 the Export button. * Choose the export format (e.g., CSV) and specify the export path as C:\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 to C:\Samples