DRAG DROP (Drag and Drop is not supported)You have several Azure virtual machines that run Windows Server 2022.You need to identify the distinct event IDs of each virtual machine as shown in the following table.How should you complete the Azure Monitor query? To answer, drag the appropriate values to the correct locations. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.Note: Each correct selection is worth one point.Select and Place:
Answer(s): A
You can use makelist to pivot data by the order of values in a particular column. For example, you may want to explore the most common order events take place on your machines. You can essentially pivot the data by the order of EventIDs on each machine.Example:Event| where TimeGenerated > ago(12h)| order by TimeGenerated desc| summarize makelist(EventID) by Computer
https://docs.microsoft.com/en-us/azure/azure-monitor/log-query/advanced-aggregations
You have a private GitHub repository.You need to display the commit status of the repository on Azure Boards.What should you do first?
Answer(s): C
To connect Azure Boards to GitHub.com, connect and configure from Azure Boards. Or, alternatively, install and configure the Azure Boards app from GitHub. Both methods have been streamlined and support authenticating and operating via the app rather than an individual.Note (see step 4 below):Add a GitHub connection:-1. Sign into Azure Boards.-2. Choose (1) Project Settings, choose (2) GitHub connections and then (3) Connect your GitHub account.-3. If this is your first time connecting to GitHub from Azure Boards, you will be asked to sign in using your GitHub credentials. Choose an account for which you are an administrator for the repositories you want to connect to.-4. The Add GitHub Repositories dialog automatically displays and selects all GitHub.com repositories for which you are an administrator. Unselect any repositories that you don't want to participate in the integration.
https://docs.microsoft.com/en-us/azure/devops/boards/github/connect-to-github
You are integrating Azure Pipelines and Microsoft Teams.You install the Azure Pipelines app in Microsoft Teams.You have an Azure DevOps organization named Contoso that contains a project name Project1.You subscribe to Project1 in Microsoft Teams.You need to ensure that you only receive events about failed builds in Microsoft Teams.What should you do first?
DRAG DROP (Drag and Drop is not supported)You have an app named App1. You have a Log Analytics workspace named Workspace1 that contains two tables named Events and Logs. App1 manages events in multiple locations and writes logs to Workspace1.You need to query Workspace1 for all log entries related to Asia that occurred during the last two days.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:
Step 1: LogsStep 2: | where continent == 'Asia'Step 3: | join ( EventsStep 4: | where timestamp > ago (2d)Step 5: ) on RequestIdExample:Get extended activities from a login that some entries mark as the start and end of an activity.Kusto let Events = MyLogTable | where type=="Event" ;Events| where Name == "Start"| project Name, City, ActivityId, StartTime=timestamp| join (Events| where Name == "Stop"| project StopTime=timestamp, ActivityId)on ActivityId| project City, ActivityId, StartTime, StopTime, Duration = StopTime - St
https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/joinoperator
DRAG DROP (Drag and Drop is not supported)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:
Step 1: AppEventsAppEvents firstStep 2: | where Name startswith "Clicked Create New Ticket"Followed by the where statementsStep 3: | where NumberOfClicks >= 3Step 4: | summarize ...After the where statements use the summarize statement.Step 5: | top 10 by NumberofClicks descThe top 10 statement with sorting to finish the query.Kusto example:Usage| where TimeGenerated > ago(32d)| where StartTime >= startofday(ago(31d)) and EndTime < startofday(now())| where IsBillable == true| summarize BillableDataGB = sum(Quantity) / 1000 by Solution, DataType| sort by Solution asc, DataType asc
https://learn.microsoft.com/en-us/azure/azure-monitor/logs/analyze-usage
Post your Comments and Discuss Microsoft AZ-400 exam prep with other Community members: