Practice Test 5 | Designing And Implementing Microsoft DevOps Solutions | AZ-400 | Dumps | Mock Test

Correct Answer: E, D and B

• where
• summarize
• render
• A is incorrect because the operator let in the let statements binds a variable to a scalar or tabular expression.
• B is correct because to present the data, Kusto Query Language(KQL) provides tabular operator render.
• C is incorrect because the tabular operator extend creates calculated columns and outputs them in the result set.
• D is correct because To aggregate the input data and present it in the output table, need to use a tabular operator Summarize
• E is correct because Kusto Query Language(KQL) uses where tabular operator for table data.

Microsoft Azure Monitor stores two types of data: logs and metrics. This data helps users monitor, tune, and troubleshoot their applications and services. Azure Monitor collects data from applications, operating systems, Azure resources, subscriptions, tenants, and custom sources.

Kusto Query Language uses where tabular operator for filtering table data (e.g., Perf, Line 1) on conditions (Line 2 – 4). The condition consists of a Boolean expression for the table’s columns or predicate. The predicates are “stacked” using Boolean “and” operator (Line 3 – 4).

To aggregate the input data and present it in the output table, you need to use a tabular operator summarize (Line 5).

To present the data, KQL provides a tabular operator render. This operator generates the result data in a particular way, e.g., visualize data as a chart (e.g., piechart (Line 6)), card, table (default), and interactive time pivot. The render should always be the last operator in tabular expression.

References:

• Tutorial: Kusto queries | Microsoft Docs
• Examine Kusto Query Language (KQL) – Learn | Microsoft Docs