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 78 discussion

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

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?

  • A. Shut down and restart each application.
  • B. Write a utility to scan database query logs.
  • C. Write a utility to scan application logs.
  • D. Use query tags to add application-centric database monitoring.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by pk349 at Dec. 24, 2022, 11:49 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
dynamic_dba
Highly Voted 1 year, 7 months ago
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
upvoted 6 times
...
Pime13
Most Recent 5 months, 3 weeks ago
Selected Answer: D
https://cloud.google.com/sql/docs/postgres/using-query-insights#filter_by_query_tags To troubleshoot an application, you must first add tags to your SQL queries. Query load tags provide a breakdown of the query load of the selected tag over time.
upvoted 2 times
...
badrisrinivas9
1 year, 3 months ago
Selected Answer: D
D: Use query tags to add application-centric database monitoring.
upvoted 2 times
...
chelbsik
1 year, 10 months ago
Selected Answer: D
https://cloud.google.com/sql/docs/postgres/using-query-insights#specific-query:~:text=Store%20application%20tags,with%20application%20monitoring.
upvoted 3 times
...
pk349
1 year, 10 months ago
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.
upvoted 3 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