Topic 1 Question 98
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?
View Cloud SQL operations to view historical query information.
White a Logs Explorer query to identify database queries with high execution times.
Review application logs to identify database calls.
Use the Query Insights dashboard to identify high execution times.
ユーザの投票
コメント(3)
D: Use the Query Insights *** dashboard to identify high execution times.
👍 8pk3492022/12/24A 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.
👍 1pk3492022/12/24- 正解だと思う選択肢: D
D. Use the Query Insights dashboard to identify high execution times.
👍 1Nirca2023/03/08
シャッフルモード