Which metrics and logs would be most useful for investigating resource contention in a database?

CPU utilization, I/O wait times, and lock wait events

A company runs a Cloud SQL for MySQL instance. They want to be alerted when the instance encounters errors, such as connection failures or internal errors, to respond quickly. They also want to review the audit logs to understand the cause. What should they do?

Enable Query Insights to analyze slow queries.

Set up a Cloud Function to run a health check script periodically.

Create a Cloud Monitoring alert on the error metrics and enable Cloud Audit Logs.

Create a Cloud Logging sink to export all logs to BigQuery.

What is resource contention in a database context?

Network latency between application and database

Multiple processes competing for limited resources like CPU, memory, or I/O

Backup files taking up too much space

A single query using too many indexes

A company runs a Cloud SQL for PostgreSQL instance. They want to detect missing indexes that cause slow queries and be notified when new recommendations are available. What should they do?

Enable audit logging and review logs for slow queries.

Increase the instance's storage to improve performance.

Set up a Cloud Function to periodically run EXPLAIN on all queries.

Use Query Insights to view query plans and set up alerts on the 'missing index' metric.

Google CloudProfessional Cloud Database Engineer

Domain 2Objective 2

2.2 Configure Database Monitoring and Troubleshooting Options PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 5)

Part of the Manage a solution that can span multiple database technologies domain, which accounts for ~25% of the PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam.

29questions here

6free pages

8concepts

~25%of the exam

Questions 21–25

21foundation · medium
Which metrics and logs would be most useful for investigating resource contention in a database?
Select an answer first
22application · medium
A company runs a Cloud SQL for MySQL instance. They want to be alerted when the instance encounters errors, such as connection failures or internal errors, to respond quickly. They also want to review the audit logs to understand the cause. What should they do?
Select an answer first
23foundation · medium
What is resource contention in a database context?
Select an answer first
24foundation · medium
Which type of metric would be most appropriate for an alert that triggers when database CPU utilization exceeds 80%?
Select an answer first
25application · medium
A company runs a Cloud SQL for PostgreSQL instance. They want to detect missing indexes that cause slow queries and be notified when new recommendations are available. What should they do?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-CLOUD-DATABASE-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-CLOUD-DATABASE-ENGINEER” is a trademark of its owner, used for identification only.