ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

Exam Professional Cloud Database Engineer topic 1 question 98 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 98
Topic #: 1
[All Professional Cloud Database Engineer Questions]

You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?

  • A. View Cloud SQL operations to view historical query information.
  • B. White a Logs Explorer query to identify database queries with high execution times.
  • C. Review application logs to identify database calls.
  • D. Use the Query Insights dashboard to identify high execution times.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by pk349 at Dec. 24, 2022, 11:20 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
pk349
Highly Voted 1 year, 10 months ago
D: Use the Query Insights *** dashboard to identify high execution times.
upvoted 10 times
...
dija123
Most Recent 5 months, 1 week ago
Selected Answer: D
Query Insights
upvoted 1 times
...
Pime13
5 months, 4 weeks ago
Selected Answer: D
D: Use the Query Insights
upvoted 1 times
...
Nirca
1 year, 7 months ago
Selected Answer: D
D. Use the Query Insights dashboard to identify high execution times.
upvoted 3 times
...
pk349
1 year, 10 months ago
A Cloud SQL instance configured for HA is also called a regional instance and has a primary and secondary zone within the configured region. Within a regional instance, the configuration is made up of a primary instance and a standby instance. Through synchronous replication to each zone's persistent disk, all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed. In the event of an instance or zone failure, the standby instance becomes the new primary instance. Users are then rerouted to the new primary instance. This process is called a failover.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago