1Z0-1111-25 practice question 15 of 15

Which two components are optional while creating the Monitoring Query Language (MQL) expressions in the Oracle Cloud Infrastructure (OCI) Monitoring service? (Choose two.)

Full set: 61 questions
Answer options
A: Interval
B: Statistic
C: Previous
D: Grouping Function Correct answer
E: Metric
F: Dimensions Correct answer
Correct Answer:
D. Grouping Function; F. Dimensions
Explanation

In OCI Monitoring service, Monitoring Query Language (MQL) expressions follow the general structure: Metric[Interval]{Dimensions}.GroupingFunction().Statistic. While the Metric name and the spatial/temporal aggregation Statistic (e.g., mean, max, sum) are mandatory components of an MQL query, Dimensions (filters/groupings by metric dimensions) and Grouping Functions (such as groupBy()) are optional. If dimensions are omitted, the query aggregates across all telemetry streams for that metric; if grouping functions are omitted, default aggregation applies across all retrieved data streams.

Why Incorrect

A: Interval defines the aggregation window and defaults if omitted, but standard syntax constructs require specifying the evaluation time window. B: Statistic (e.g., mean, count, max) is a mandatory MQL element required to convert metric data points into aggregate output. C: Previous is a temporal modifier clause used for offset comparisons; it is not a primary syntax component evaluated as optional query parameter structure. E: Metric name specifies the target resource telemetry being queried and is strictly mandatory in every MQL expression.

References

Oracle Cloud Infrastructure Documentation, OCI Monitoring Service - Monitoring Query Language (MQL) Reference: Section "MQL Syntax and Clause Requirements".

Oracle Cloud Infrastructure Documentation, Building MQL Queries: Section "Optional and Required Query Components (Dimensions and Grouping Functions)".

Scroll to Top