Practice Test 1 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
You have a MySQL database installed on a Google Cloud Compute Engine virtual machine. MySQL database is used for a WordPress website. You want to monitor the database instance’s application performance and availability by showing CPU, uptime, and number of connections. How can you achieve this?
A. Cloud Monitoring can detect and receive application performance stats from virtual machines automatically.
B. Install Cloud Monitoring MySQL plugin. No extra steps are required.
C. Install Cloud Monitoring MySQL plugin. Create a user for the Cloud Monitoring plugin in MySQL database with the required permissions to run the SHOW_STATUS command.
D. Install Prometheus on a different virtual machine. Allow Prometheus access to MySQL database to collect data. Create a dashboard on Prometheus to monitor database’s performance and availability.
Answer: C.
Description:
Cloud Monitoring is a tool from Google to monitor and manage services, containers, applications, and infrastructure. Cloud Monitoring aggregates metrics, logs, and events from infrastructure, giving developers and operators a rich set of observable signals that speed root-cause analysis and reduce mean time to resolution (MTTR). Cloud Monitoring doesn’t require extensive integration and it does not lock developers into using a particular cloud provider.
Cloud Monitoring has a plugin to monitor on-premise and manually installed MySQL databases. After installing the plugin, it will detect the database by:
-
- Searching instance names for “mysql”
- Checking for ports opened to 3306 via firewall rules
For MySQL collection, you must add a user with a password to MySQL that can run the “SHOW STATUS” command. This user and password are referred to as STATS_USER and STATS_PASS in the config file installed.
Answer A is incorrect: Cloud Monitoring will receive performance and availability stats from Compute Engine virtual machine. However, Cloud Monitoring will not receive any from the MySQL database installed on the virtual machine.
Answer B is incorrect: You need to meet the prerequisites mentioned on the plugin page (See source). So, you need to create a user which can run the SHOW STATUS command.
Answer D is incorrect: No need to use Prometheus for this scenario. Cloud Monitoring is a good alternative.
Source(s):
Cloud Monitoring – MySQL Plugin: https://cloud.google.com/monitoring/agent/plugins/mysql
Comments are closed, but trackbacks and pingbacks are open.