Microsoft AZ-400 Exam Questions
Designing and Implementing Microsoft DevOps Solutions (Page 6 )

Updated On: 16-Mar-2026

You have an Azure subscription that contains an Azure Kubernetes Service (AKS) instance named AKS1.

You collect and analyze metrics for AKS1 by using the Azure Monitor managed service for Prometheus.

You need to analyze the performance of AKS1.

Which query language should you use?

  1. PL/SQL
  2. PromQL
  3. SparkQL
  4. KQL

Answer(s): B

Explanation:

Azure Monitor managed service for Prometheus
Azure Monitor managed service for Prometheus is a component of Azure Monitor Metrics, providing more flexibility in the types of metric data that you can collect and analyze with Azure Monitor. Prometheus metrics are supported by analysis tool like Azure Monitor Metrics Explorer with PromQL and open source tools such as PromQL and Grafana.


Reference:

https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/prometheus-metrics-overview



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:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




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: timespan
The 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)

PrimaryResult
Span
1.13:40:00

Note: Kusto, extend operator
Creates calculated columns and append them to the result set.

Syntax
T | extend [ColumnName | (ColumnName[, ...]) =] Expression [, ...]

Example

StormEvents
| project EndTime, StartTime
| extend Duration = EndTime - StartTime
The following table shows only the first 10 results. To see the full output, run the query.


Reference:

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



SIMULATION

Navigate to https://dev.azure.com, select Start Free, and specify the following credentials:

User: User1-12345678@ExamUsers.com

Password: 0123456789

Use 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.

  1. See Explanation section for answer.

Answer(s): A

Explanation:

Phase 1: Create an organization

Azure DevOps, Create an organization

Step 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 project
Crate a project in Azure DevOps

Step 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 user
Azure DevOps, Add external users to your organization

Invite external user

Step 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]


Reference:

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



SIMULATION

For the RG1lod12345678 resource group, you need to create an action group named DevOpsAG that can be triggered in any region by using Alerts.

The action group must email two users named admin1@contoso.com and admin2@contoso.com and notify members of the Owner role for the resource.

Use only the common alert schema for notifying the resource owners.

  1. See Explanation section for answer.

Answer(s): A

Explanation:

Create an action group in the Azure portal

Step 1: Go to the Azure portal.

Step 2: Search for and select Monitor. The Monitor pane consolidates all your monitoring settings and data in one view.

Step 3: Select Alerts, and then select Action groups.



Step 4: Select Create.



Step 5: Configure basic action group settings. In the Project details section:

Select values for Subscription and Resource group [Select RG1lod12345678].
Select the region.

The action group is saved in the subscription, region, and resource group that you select.

Step 6: In the Instance details section, enter values for Action group name [Enter DevOpsAG ] and Display name. The display name is used in place of a full action group name when the group is used to send notifications.



Step 7: Configure notifications. Select Next: Notifications, or select the Notifications tab at the top of the page.

Step 8: Define a list of notifications to send when an alert is triggered.

Step 9: For each notification:
9a. Select the Notification type, and then fill in the appropriate fields for that notification. The available options are:
* Email Azure Resource Manager role
Send an email to the subscription members, based on their role. [Choose the Owner role]

Enter the primary email address configured for the Microsoft Entra user.

9b. Select if you want to enable the Common alert schema. [Skip]



9c. Select OK.

* Email
Enter the email where the notification should be sent. [Enter admin1@contoso.com and admin2@contoso.com]

Step 10: Finished the Wizard.
* Details omitted *


Reference:

https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/action-groups



SIMULATION

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.

On Azure Data Explorer by using the following link:

https://dataexplorer.azure.corn/clusters/help/databases/SecurityLogs

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

The query must return two columns named NumberOfRequests and SourceIP.

Export the query result to C:\Samples.

  1. See Explanation section for answer.

Answer(s): A

Explanation:

Task l: Add connection

Azure Data Explorer, To add a new cluster connection, do the following:

Step 1: On the left menu, select Query.
Step 2: In the upper left pane, select Add connection.

Step 3: In the Add connection dialog box, enter the cluster Connection URI and Display name. [Enter; https://dataexplorer.azure.corn/clusters/help/databases/SecurityLogs]

Step 4: Select Add to add the connection.

Tasks 2: Build and run a query
Run queries
To run a query, you must select the database on which you want to run the query in order to set the query context.

Step 5: In the Cluster connection pane, under the help cluster, select the SecurityLogs database [if it is not already selected].



Step 6: Enter the following query into the query windows:
InboundBrowsing
Project NumberOfRequests SourceIP

Step 7: Click Run

Sample query output:



Task 3: Download/export query resutl
To download a KQL file of the query, follow these steps:

Step 8: In the query window, select the query that you want to download.

Step 9: Select Export > Download.


Reference:

https://learn.microsoft.com/en-us/azure/data-explorer/web-query-data https://learn.microsoft.com/en-us/azure/data-explorer/web-share-queries



Viewing page 6 of 72
Viewing questions 26 - 30 out of 355 questions



Post your Comments and Discuss Microsoft AZ-400 exam dumps with other Community members:

AZ-400 Exam Discussions & Posts

AI Tutor 👋 I’m here to help!