Topic 1 Question 78

Professional Cloud Database Engineer

Topic 1 Question 78
You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?
- Shut down and restart each application.
- Write a utility to scan database query logs.
- Write a utility to scan application logs.
- Use query tags to add application-centric database monitoring.
ユーザの投票
コメント(3)
- 正解だと思う選択肢: D
  https://cloud.google.com/sql/docs/postgres/using-query-insights#specific-query:~:text=Store%20application%20tags,with%20application%20monitoring.
  
  👍 3
  chelbsik2022/12/25
- D: Use query tags to add application-centric database monitoring. Store application tags Stores application tags that help you determine the APIs and model-view-controller (MVC) routes that are making requests and group the data to run metrics against it. This option requires you to comment queries with a specific set of tags using the sqlcommenter open source object-relational mapping (ORM) auto-instrumentation library. This information helps Query insights identify the source of a problem and the MVC the problem is coming from. Application paths help you with application monitoring.
  
  👍 2
  pk3492022/12/24
- D. A is just wrong on so many levels. B and C represent work and unless you know which SQL belongs to which application won’t actually help. First you need to add query tags to help identify application SQL. D is therefore correct. https://cloud.google.com/sql/docs/postgres/using-query-insights#filter_by_query_tags
  
  👍 1
  dynamic_dba2023/03/13
シャッフルモード

ユーザの投票

コメント(3)