You have an analytics application that runs hundreds of queries on BigQuery every few minutes using BigQuery API. You want to find out how much time these queries take to execute. What should you do?
A.
Use Stackdriver Monitoring to plot slot usage.
B.
Use Stackdriver Trace to plot API execution time.
C.
Use Stackdriver Trace to plot query execution time.
D.
Use Stackdriver Monitoring to plot query execution times.
Stackdriver Trace provides detailed traces of individual requests, including the time spent in each function and database query.
However, Stackdriver Monitoring doesn't provide detailed information about individual query execution times.
D. Use Stackdriver Monitoring to plot query execution times.
Stackdriver Monitoring (now part of Google Cloud's operations suite) provides capabilities to monitor BigQuery and create custom dashboards to visualize various metrics, including query execution times. You can track how long your queries take to run by plotting the query_execution_times metric in a custom dashboard.
The correct answer is C. Use Stackdriver Trace to plot query execution time. Stackdriver Trace is a distributed tracing system that allows you to profile and debug your application's performance. It allows you to trace requests across multiple services, and it provides a detailed breakdown of where time is being spent within your application. Since you want to find out how much time your queries take to execute, using Stackdriver Trace to plot query execution time would be the most appropriate approach.
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.
saurabh1805
Highly Voted 4 years, 5 months agofraloca
4 years, 4 months agosyu31svc
3 years, 10 months agoStelSen
4 years, 2 months agoPinkeshExampTopics
Most Recent 4 months, 3 weeks agosantoshchauhan
1 year, 1 month agomohammeddigital
1 year, 4 months ago__rajan__
1 year, 7 months agomaxdanny
1 year, 8 months agoTeraflow
2 years, 1 month agotelp
2 years, 3 months agotomato123
2 years, 8 months ago