A team manages a Cloud Spanner instance. They want to be notified immediately when the instance encounters errors, such as failed requests or internal errors, to respond quickly. What should they configure?

Cloud Scheduler to run a health check script periodically.

Query Insights to analyze slow queries.

Cloud Monitoring alerting policies on the error metrics for the instance.

Cloud Audit Logs to track who made changes.

What is the primary purpose of enabling audit logging for a database?

To automatically fix database errors

To track database access and changes for security and troubleshooting

A team manages a Cloud SQL for PostgreSQL instance. They see high CPU and memory usage, and Query Insights shows a query with high execution time. The query is a join between two large tables. The team suspects a missing index on the join columns. What should they do to confirm and resolve?

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

Enable audit logging to track who is running the query.

Examine the query plan in Query Insights to see if it uses a nested loop join without indexes.

Increase the instance's memory to improve join performance.

When investigating a slow-running query, which type of data is most useful for correlating the query's performance with potential locking issues?

Query execution statistics and lock wait events

Google CloudProfessional Cloud Database Engineer

Domain 2Objective 2

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

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 1–5

1application · medium
A team manages a Cloud Spanner instance. They want to be notified immediately when the instance encounters errors, such as failed requests or internal errors, to respond quickly. What should they configure?
Select an answer first
2foundation · medium
What is the primary purpose of enabling audit logging for a database?
Select an answer first
3foundation · medium
Which Google Cloud component is commonly used to store and review database audit logs?
Select an answer first
4expert · hard
A team manages a Cloud SQL for PostgreSQL instance. They see high CPU and memory usage, and Query Insights shows a query with high execution time. The query is a join between two large tables. The team suspects a missing index on the join columns. What should they do to confirm and resolve?
Select an answer first
5foundation · medium
When investigating a slow-running query, which type of data is most useful for correlating the query's performance with potential locking issues?
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.