A team manages a Cloud Spanner instance. They notice a sudden increase in latency. Query Insights shows a specific query is slow, and metrics show high CPU utilization. The query is a point lookup that should be fast. They suspect a missing index. What should they do to confirm?

Examine the query plan in Query Insights to see if it performs a full table scan.

Enable audit logging to see who ran the query.

Increase the number of nodes in the Spanner instance.

Set up an alert on CPU utilization to notify when it's high.

A team manages a Cloud SQL for MySQL instance. They observe high CPU usage and slow query performance. Metrics show high I/O wait times. Query Insights reveals a query that performs a full table scan on a large table. The team needs to reduce contention. What should they do?

Increase the instance's CPU quota.

Add an index on the columns used in the WHERE clause of the slow query.

Set up an alert on I/O wait time to notify when it's high.

Enable audit logging to track who is running the query.

What is the purpose of configuring alerts on performance metrics for a database?

To replace the need for query optimization

To automatically increase resource capacity

To notify when thresholds are breached, enabling timely intervention

To reduce the cost of the database

A financial services company must track all access to sensitive data in their Cloud SQL for MySQL instance for security and troubleshooting. They need to know who accessed what and when, and be alerted if any access is denied. What should they enable?

Cloud Monitoring dashboards for CPU and memory.

Cloud Audit Logs and set up an alert on the logs for 'denied' events.

Query Insights to analyze slow queries.

Cloud NAT to control outbound traffic.

Google CloudProfessional Cloud Database Engineer

Domain 2Objective 2

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

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 11–15

11expert · hard
A team manages a Cloud Spanner instance. They notice a sudden increase in latency. Query Insights shows a specific query is slow, and metrics show high CPU utilization. The query is a point lookup that should be fast. They suspect a missing index. What should they do to confirm?
Select an answer first
12expert · hard
A team manages a Cloud SQL for MySQL instance. They observe high CPU usage and slow query performance. Metrics show high I/O wait times. Query Insights reveals a query that performs a full table scan on a large table. The team needs to reduce contention. What should they do?
Select an answer first
13foundation · medium
A database administrator wants to identify queries that are consuming the most resources over time. Which Google Cloud tool is designed to analyze query performance data and help identify slow-running queries?
Select an answer first
14foundation · medium
What is the purpose of configuring alerts on performance metrics for a database?
Select an answer first
15application · medium
A financial services company must track all access to sensitive data in their Cloud SQL for MySQL instance for security and troubleshooting. They need to know who accessed what and when, and be alerted if any access is denied. What should they enable?
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.