Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam

Exam Professional Data Engineer topic 1 question 90 discussion

Actual exam question from Google's Professional Data Engineer

Question #: 90
Topic #: 1

[All Professional Data Engineer Questions]

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?

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.

Show Suggested Answer

Suggested Answer: D 🗳️

by [deleted] at March 22, 2020, 5:59 p.m.

Comments

Submit Cancel

Barniyah

Highly Voted 4 years, 2 months ago

Answer : A MariaDB needs costume metrics , and stackdriver built-in monitoring tools will not provide these metrics . Opencensus Agent will do this for you For more info , refer to : https://cloud.google.com/monitoring/custom-metrics/open-census

upvoted 26 times

fire558787

2 years, 9 months ago

It is definitely A. B: can't be because Health Checks just checks that machine is online C: StackDriver Logging is for Logging. Here we talk of Monitoring / Alerting D: StackDriver Agent monitors default metrics of VMs and some Database stuff with the MySQL Plugin. Here you want to monitor some more custom stuff like Replication of MariaDB (I didn't find anything of this sort in the plugin page), and you may want to use Custom Metrics rather than default metrics. "Cloud Monitoring automatically collects more than 1,500 built-in metrics from more than 100 monitored resources. But those metrics cannot capture application-specific data or client-side system data. Those metrics can give you information on backend latency or disk usage, but they can't tell you how many background routines your application spawned." https://cloud.google.com/monitoring/custom-metrics/open-census#monitoring_opencensus_metrics_quickstart-python

upvoted 13 times

...

[Removed]

Highly Voted 4 years, 2 months ago

Answer: C Description: The GitHub repository named google-fluentd-catch-all-config which includes the configuration files for the Logging agent for ingesting the logs from various third-party software packages.

upvoted 13 times

Atulthakur

2 years, 10 months ago

I think its D, because its Selfmanaged DB and for this we use Stackdriver Agents. and in this question its asking about metrics not logs.

upvoted 2 times

...

rocky48

Most Recent 6 months, 2 weeks ago

Selected Answer: D

Here's the rationale: StackDriver Agent: The StackDriver Agent is designed to collect system and application metrics from virtual machine instances and send them to StackDriver Monitoring. It simplifies the process of collecting and forwarding metrics. MySQL Plugin: The StackDriver Agent has a MySQL plugin that allows you to collect MySQL-specific metrics without the need for additional custom development. This includes metrics related to network connections, disk IO, and replication status – which are the specific metrics you mentioned. Option D is the most straightforward and least development-intensive approach to achieve the monitoring and alerting requirements for MariaDB on GCE VM Instances using StackDriver.

upvoted 2 times

...

BlehMaks

7 months, 2 weeks ago

Selected Answer: A

replication status seems to be not included in sql agent metrics. but I do not like A in terms of efforts

upvoted 1 times

...

ninjatech

1 year, 3 months ago

it can't be A as it saying minimal development but for opencensus the development is needed.

upvoted 1 times

...

slade_wilson

1 year, 6 months ago

Selected Answer: A

To use metrics collected by OpenCensus in your Google Cloud project, you must make the OpenCensus metrics libraries and the Stackdriver exporter available to your application. The Stackdriver exporter exports the metrics that OpenCensus collects to your Google Cloud project. You can then use Cloud Monitoring to chart or monitor those metrics.

upvoted 1 times

...

zellck

1 year, 6 months ago

Selected Answer: D

D is the answer. https://cloud.google.com/stackdriver/docs/solutions/agents/ops-agent/third-party/mariadb

upvoted 10 times

wan2three

1 year, 5 months ago

For supplement, ‘Stackdriver agent' now called as Ops agent, 'Operations Suite'

upvoted 4 times

...

dish11dish

1 year, 7 months ago

Selected Answer: D

Option D is Correct MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS). To collect logs and metrics for MariaDB, use the mysql receivers. The mysql receiver connects by default to a local MariaDB server using a Unix socket and Unix authentication as the root user. reference:-https://cloud.google.com/stackdriver/docs/solutions/agents/ops-agent/third-party/mariadb

upvoted 5 times

...

girgu

1 year, 7 months ago

Selected Answer: D

https://cloud.google.com/monitoring/agent/ops-agent/third-party/mariadb

upvoted 3 times

...

clouditis

1 year, 9 months ago

C is the answer, fluentd plug in is needed as the DB is on GCE

upvoted 2 times

...

ducc

1 year, 9 months ago

Selected Answer: D

go for D

upvoted 2 times

...

eRaymox

1 year, 10 months ago

A StackDriver Agent monitors default metrics of VMs and some Database stuff with the MySQL Plugin. Here you want to monitor some more custom stuff like Replication of MariaDB (I didn’t find anything of this sort in the plugin page), and you may want to use Custom Metrics rather than default metrics. “Cloud Monitoring automatically collects more than 1,500 built-in metrics from more than 100 monitored resources. But those metrics cannot capture application-specific data or client-side system data. Those metrics can give you information on backend latency or disk usage, but they can’t tell you how many background routines your application spawned.” https://cloud.google.com/monitoring/custom-metrics/open-census#monitoring_opencensus_metrics_quickstart-python

upvoted 2 times

...

Kriegs

1 year, 12 months ago

I'm not 100% sure as I have no experience with that issue, but I would say it's D - both A and D should work, but the keyword is "with minimal development effort" (and using pre-built plugin > creating custom metric in terms of simplicity, that's obvious) and all of the relevant data (as per question) should be there: https://cloud.google.com/monitoring/api/metrics_agent#agent-mysql I'm not sure if C would work, but it also seems more advanced in implementation than D. B is 100% wrong and insufficient for that use case. Feel free to prove me wrong :)

upvoted 2 times

...

NR22

2 years, 1 month ago

A and D both seem like viable options here, unsure which is Google's preferred method as that would be deemed the correct answer in the exam. Any opinions?

upvoted 1 times

...

Didine_22

2 years, 2 months ago

Selected Answer: D

D mariaDB is an extension of mysql and mysql plugin must work fine to extract the metrics of mariaDB.

upvoted 5 times

ST42

2 years ago

"MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS). To collect logs and metrics for MariaDB, use the mysql receivers." https://cloud.google.com/monitoring/agent/ops-agent/third-party/mariadb

upvoted 2 times

...