DRAG DROP (Drag and Drop is not supported)You have a web app named App1 that is hosted on multiple servers. App1 uses Application Insights in Azure Monitor.You need to compare the daily CPU usage from the last week for all servers.How should you complete the query? To answer, drag the appropriate values to the correct targets. 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
Box 1: bin(timestamp,1d)Summarizing each day’s request count into a timechart (a line chart). We also have options got a bar chart (barchart), pie chart (piechart), area chart (areachart) and scatter chart (scatterchart)requests| summarize request_count = count() by bin(timestamp, 1d)| render timechartBox 2: render (timechart,1d)
https://putridparrot.com/blog/basics-of-kql/
DRAG DROP (Drag and Drop is not supported)You have a web app named App1 that uses Application Insights in Azure Monitor.You need to compare the hourly CPU usage of App1 from the last 24 hours. The solution must include a graph that has a threshold line at 75 percent.How should you complete the query? To answer, drag the appropriate values to the correct targets. 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:
Box 1: bin(TimeGenerated, 1h)We need to compare the hourly CPU usage, not the daily usage.Box 2: extendIncorrect:* renderThe next command would be render, but cannot be used in conjunction with threshold.
https://learn.microsoft.com/en-us/azure/azure-monitor/logs/get-started-queries
HOTSPOT (Drag and Drop is not supported)You are using Agile process methodologies in Azure DevOps.You need to deploy a dashboard that will provide progress reports for the following work items:-How long it took to close a work item after it was created.-How long it took to close a work item after the work was started.Which type of widget should you use for each work item? To answer, select the appropriate options in the answer area.Note: Each correct selection is worth one point.Hot Area:
Box 1: Lead timeHow long it took to close a work item after it was created.Lead time measures the total time elapsed from the creation of work items to their completion.Box 2: Cycle timeHow long it took to close a work item after the work was started.Cycle time measures the time it takes for your team to complete work items once they begin actively working on them.Incorrect:* Burndown chart, Burnup chartBurndown and burnup charts support project management to visually track work completed over time.Burndown charts begin with the total amount of planned work and then as work is completed graphs the remaining work. With the progression of time, the amount of to-do work decreases.Burnup charts track work as it is completed over time. They're useful to show the rate at which work is getting completed.
https://learn.microsoft.com/en-us/azure/devops/report/dashboards/burndown-guidance
SIMULATIONNavigate to https://dev.azure.com, select Start Free, and specify the following credentials:-User: User1-12345678@ExamUsers.com-Password: 0123456789Use the default setting to sign up for Azure DevOps and create an Azure DevOps organization. Once the organization is created, create a private project named Project1.You need to add an external user that has an email address of User2-12345678@ExamUsers.com as a stakeholder of the User1-12345678 Azure DevOps organization.The user must be added to the most restrictive Azure DevOps group.To complete this task, sign in to the Azure DevOps portal as User1-12345678@ExamUsers.com.
See explanation below.Phase 1: Create an organizationAzure DevOps, Create an organizationStep 1: Sign in to Azure DevOps.Step 2: Select New organization.Step 3: Confirm information, and then select Continue.Congratulations, you're an organization owner!Phase 2: Create a Private projectCrate a project in Azure DevOpsStep 4: Sign in to your organization (https://dev.azure.com/{yourorganization}).Step 5: Select New project.Step 6: Enter information into the form provided.Provide a name for your project. [Enter Project1]Choose the visibility, initial source control type, and work item process. [Select Private]Step 7: Select Create. Azure DevOps displays the project welcome page.Phase 3: Add an external userAzure DevOps, Add external users to your organizationInvite external userStep 8: Sign in to your organization (https://dev.azure.com/{yourorganization}).Step 9: Select gear icon Organization settings.Step 10: Select Users, and then select Add users.Step 11: Enter information based on the following guidance, and then select Add.Users: Enter the email address for the user. [Enter User2-12345678@ExamUsers.com]
https://learn.microsoft.com/en-us/azure/devops/organizations/accounts/create-organization https://learn.microsoft.com/en-us/azure/devops/organizations/projects/create-project https://learn.microsoft.com/en-us/azure/devops/organizations/accounts/add-external-user
HOTSPOT (Drag and Drop is not supported)You are interrogating logs by using KQL.You execute the query 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:
Box 1: Six_____________ columns will be returned in the query output.Line 3 specifies five columns.Line 4 specifies an additional sixth column with extend.Box 2: timespanThe data type of the Duration column is _______________.One of the datatypes in Kusto is timespan. If you subtract two datetetime columns, the results is a timespan.Execute in [Web] [Desktop] [cluster('kuskuseus.eastus.kusto.windows.net').database('Kuskus')]print Span=datetime(2024-3-10 22:30)-datetime(2024-3-9 08:50)PrimaryResultSpan1.13:40:00Note: Kusto, extend operatorCreates calculated columns and append them to the result set.SyntaxT | extend [ColumnName | (ColumnName[, ...]) =] Expression [, ...]ExampleStormEvents| project EndTime, StartTime| extend Duration = EndTime - StartTimeThe following table shows only the first 10 results. To see the full output, run the query.
https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/extend-operator https://techcommunity.microsoft.com/t5/azure-data-explorer-blog/timespan-duration-values-in-kql-power-query -and-power-bi/ba-p/4086091
Post your Comments and Discuss Microsoft AZ-400 exam prep with other Community members: