Google Cloud Professional Data Engineer — Question 125

You are deploying MariaDB SQL databases on GCE VM Instances and need to configure monitoring and alerting. You want to collect metrics including network connections, disk IO and replication status from MariaDB with minimal development effort and use StackDriver for dashboards and alerts.
What should you do?

Answer options

• A. Install the OpenCensus Agent and create a custom metric collection application with a StackDriver exporter.
• B. Place the MariaDB instances in an Instance Group with a Health Check.
• C. Install the StackDriver Logging Agent and configure fluentd in_tail plugin to read MariaDB logs.
• D. Install the StackDriver Agent and configure the MySQL plugin.

Correct answer: D

Explanation

The correct answer is D because installing the StackDriver Agent and configuring the MySQL plugin allows for seamless integration and collection of metrics specific to MariaDB with minimal development effort. Options A and C require more extensive customization and development, while option B focuses on health checks rather than comprehensive monitoring and alerting.