You are asked to measure useful quantitative data about a MySQL Database Service system. You must provide information such as current connection information, statement activity, latency, and host OCPU, memory, and disk I/O utilization.
Which three Oracle Cloud Infrastructure monitoring methods should you use? (Choose three.)
Correct Answer: B,D,E
Oracle Cloud Infrastructure (OCI) provides various methods to monitor the performance and availability of your MySQL Database Service system. You can use the following methods to collect and analyze useful quantitative data about your system1:
* Data points: A data point is a single value that represents a metric at a specific point in time. Data points are collected by the OCI Monitoring service and stored in a time series database. You can use data points to track the changes in your system over time and compare different metrics2.
* Metrics: A metric is a named set of data points that share the same namespace, dimensions, and unit of measurement. Metrics are used to measure the behavior and utilization of your system, such as connection count, statement count, latency, OCPU usage, memory usage, and disk I/O. You can use
* metrics to create charts and dashboards to visualize your system performance3.
* Queries: A query is a way to retrieve and manipulate data points from the time series database. You can use queries to filter, aggregate, transform, and analyze metrics data. You can also use queries to create alerts and notifications based on certain conditions or thresholds4.
Therefore, statements B, D, and E are true, and statements A and C are false. Notifications and alarms are not methods to measure data, but rather methods to notify you when certain data points meet certain criteria5.
References: 1: Monitor your MySQL Database Service using MySQL Enterprise Monitor 2: [Oracle Cloud Infrastructure Documentation], Monitoring Overview 3: [Oracle Cloud Infrastructure Documentation], Metrics Overview 4: [Oracle Cloud Infrastructure Documentation], Query Language Reference 5: [Oracle Cloud Infrastructure Documentation], Alarms Overview